How to use cursor in sql server and update table

  By Adil Shahbaz   Posted on January-26-2018   719

MS Sql Server

How to use cursor, How to update table using cursor, How to get and set in cursor in MS Sql Server 2008,2008R2, 2012,2014

DECLARE @userid bigint
DECLARE @getAccountID CURSOR
SET @getAccountID = CURSOR FOR
SELECT Users_ID
FROM IE_User
OPEN @getAccountID
FETCH NEXT
FROM @getAccountID INTO @userid
WHILE @@FETCH_STATUS = 0
BEGIN
declare @email varchar(500)
set @email=(select LEFT(u.Email, CHARINDEX('@', u.Email) - 1) AS username from IE_User u where Users_ID=@userid)
 
update IE_User set LastName=@email where Users_ID=@userid


FETCH NEXT
FROM @getAccountID INTO @userid
END
CLOSE @getAccountID
DEALLOCATE @getAccountID

By  adilshehbaz    26-Jan-2018 Views  719



You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links