[shavei7]

how good are you in SQL scripting? on a scale of 1 to 10 when it comes to TSQL, how do you rate? just curious....

[mann3r]

can we make the range from 0-10, lol, 0 for me, well just kidding, next to zero maybe 1.

[shavei7]

then never mind. i have a question to ask that nobody seem to know the answer. i've been looking up books and searching the net but still nada. freaking frustrating *grrr*

if anybody else knows this answer to this one post away pls!

you have a stored proc that should return an ID that was just created

table:
ID - auto increment
name - varchar(50)

create procedure getID
as
insert into table1 (name) values ('joe')
return @@ ---- ?? // should return the newly generated unique ID by the database

i was told there's a function that does this but even the guy who told me this couldn't remember what it is....

[shavei7]

wooh0o! a friend was able to find the answer on a book. the function that returns the auto-incremented id is @@IDENTITY. solved :)

[ScottHughes]

Is TSQL used the same as mySQL? What's the difference?