Decare @A

Hi all! I'm trying to set the value of @d to a value from col1 in
tblTest. I have tried the following code but it didn't work.

DECLARE @d VARCHAR(25)
SELECT * FROM tblTest
SET @d = tblTest.col1

Someone please help me! Thanks!

SELECT @d = col1 FROM tblTest

or

SET @d = SELECT col1 FROM tblTest

Where col1 is THE COLUMN NAME not the first column.

--
Nik Marshall-Blank MCSD/MCDBA

"Stanley" <xstanley@gmail.com> wrote in message
news:1128081085.771682.230680@f14g2000cwb.googlegroups.com...
> Hi all! I'm trying to set the value of @d to a value from col1 in
> tblTest. I have tried the following code but it didn't work.
>
> DECLARE @d VARCHAR(25)
> SELECT * FROM tblTest
> SET @d = tblTest.col1
>
> Someone please help me! Thanks!
>

DECLARE @d VARCHAR(25)
SELECT  @d = col1 FROM tblTest

http://sqlservercode.blogspot.com/

"Stanley" wrote:

> Hi all! I'm trying to set the value of @d to a value from col1 in
> tblTest. I have tried the following code but it didn't work.
>
> DECLARE @d VARCHAR(25)
> SELECT * FROM tblTest
> SET @d = tblTest.col1
>
> Someone please help me! Thanks!
>
>

Thanks so much, that's what I really need!!