RE: Loading a variable
From: Alley (anonymous_at_discussions.microsoft.com)
Date: 01/12/05
- Next message: Rodrigo Fernandes: "Re: Port 1433 won't bind"
- Previous message: Alley: "Re: Loading a variable"
- In reply to: Brad Feaker: "RE: Loading a variable"
- Next in thread: Brad Feaker: "RE: Loading a variable"
- Reply: Brad Feaker: "RE: Loading a variable"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 Jan 2005 10:53:00 -0800
Sorry I want the variable to be char or varchar so that I
can email out the results using xp_sendmail.
>-----Original Message-----
>Try using a table variable...see the following article:
>
>http://www.aspfaq.com/show.asp?id=2475
>
>Brad Feaker
>Ex nihilo, nihil fit
>
>"Alley" wrote:
>
>> Let's say I have a simple three column table, temp27,
>> with a couple of rows in sql server 2000.
>>
>> How can I load "select * from temp27" into a
variable. I
>> am looking to do something like
>>
>> set @variablename = exec ('select * from temp27')
>>
>> but cannot get anything to work. Any tips would be
>> appreciated.
>>
>.
>
- Next message: Rodrigo Fernandes: "Re: Port 1433 won't bind"
- Previous message: Alley: "Re: Loading a variable"
- In reply to: Brad Feaker: "RE: Loading a variable"
- Next in thread: Brad Feaker: "RE: Loading a variable"
- Reply: Brad Feaker: "RE: Loading a variable"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
