>>Personally I use SELECT @@IDENTITY or even SELECT CAST(0 as bit) , but query any other system variable will do the same.
>
>Both you and Dragan know only about 1000 times more than I do :)
>
>I wish there was a definitive way to find out which one is faster Select @@version or SELECT @@IDENTITY. For me, the resulting number is not important. Only if the SELECT worked or no.
>
>Thank you!
SELECT @@VERSION -- Returns nvarchar variable, not sure how long it is
SELECT @@IDENTITY -- Returns 4 byte int
SELECT CAST(0 as bit) - returns 1 bit.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.