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