Monday, February 20, 2012

MSSQL Mistake (Excercise)

I have an excercise:
SET @.UserID = @.@.ROWCOUNT
it is said that there is mistake, nad to complete it there i no need of knowledge mssql? So where is mistake?@.@.ROWCOUNT is system variable that returns the number of rows affected by the last sql statement. It is usually used to verify the results of inserts and updates.

So I do not see how this would return a userid.

If you want to learn more, I would start here...

http://www.microsoft.com/downloads/details.aspx?FamilyId=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en|||@.@.ROWCOUNT is system variable that returns the number of rows affected by the last sql statement. It is usually used to verify the results of inserts and updates.

So I do not see how this would return a userid.

If you want to learn more, I would start here...

http://www.microsoft.com/downloads/details.aspx?FamilyId=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en

I know... But how correct it?|||if you want the userid use
select system_user|||So it must be
Select userid
Set @.userid = @.@.rowcount? :||||should be
select @.userid = system_user|||I don't think that you have posted the clearest definition of your problem

No comments:

Post a Comment