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

MSSQL Mistake

I have piece of query:

SET @.UserID = @.@.ROWCOUNT

And its incorrect, where is mistake?

I have only this piece because its excercise.

Sorry if bad subforum. :)

You won′t get any other resposnes here as in the public newsgroups, because that is valid SQL. If there is a problem in this row the @.@.ROWCOUNT can′t be converted to the type @.userId is based on, but that was already said in the groups. Try to get more information about the code and post this back.

HTH, Jens Suessmeyer.

|||I have only this and i can't get more... Maybe it's logical problem?