@@version n @@spid

  • who knw d statement was true or false?

    statement A : the @@version variable return date, version, and other information on the current version

    statement B : the @@spid variable return stored procedure ID of the currently-executing procedure

    thx a lot...

  • karseng91 (3/22/2012)


    who knw d statement was true or false?

    statement A : the @@version variable return date, version, and other information on the current version

    statement B : the @@spid variable return stored procedure ID of the currently-executing procedure

    thx a lot...

    statement A : the @@version variable return date, version, and other information on the current version --

    Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

    statement B : the @@spid variable return stored procedure ID of the currently-executing procedure --

    Returns the session ID of the current user process.

    Of course, if you went to Books Online you could have found this out yourself. BOL is your friend, learn to use it.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply