Post reply

set variable in select statement

  • December 27, 2010 at 10:56 pm

    #242804

    Hi how do you set a variable in a select statement like:

    declare @FirstName varchar(50)

    declare @LastName varchar(50)

    SELECT top 1 @FirstName =FName , @LastName =LName FROM Contacts

  • December 27, 2010 at 11:16 pm

    #1266616

    i did not understand the question if the how do you set var in a query you write the answer your self

    declare @FirstName varchar(50)

    declare @LastName varchar(50)

    SELECT top 1 @FirstName =first_name , @LastName =last_name FROM customer

    select @FirstName

    select @LastName

  • December 27, 2010 at 11:43 pm

    #1266624

    I ran it again and it worked. ??? Thanks :hehe:

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

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