marifrahman/SQL_Update_sequentially

Created June 4, 2013 00:53

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/marifrahman/5702787.js"></script>
Save marifrahman/5702787 to your computer and use it in GitHub Desktop.

Download ZIP

SQL Query for MS SQL Server to sequentially update a column

Raw

SQL_Update_sequentially

	DECLARE @myVar numeric
	SET @myVar = 10

	UPDATE
	tblMyTable
	SET
	@myvar = myId = @myVar + 1
	Where condition = 'Something' And isDeleted = 0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment