DECLARE @varTable table(
Id int IDENTITY(1,1),
UserName VARCHAR(25),
Passwd VARCHAR(15)
)
INSERT into @varTable(UserName,Passwd)
Values('Jib','JibsPasswd')
INSERT into @varTable(UserName,Passwd)
Values('Jax','JaxsPasswd')
INSERT into @varTable(UserName,Passwd)
Values('Who','WhosPasswd')
SELECT *
From @varTable
UPDATE @varTable
Set Passwd='awesome'
Where UserName='Jib'
SELECT *
From @varTable
GO
More to Come, CA.
No comments:
Post a Comment