Set Parameter value from select query

sql-server-2008

I have two parameter

DECLARE @nOdc_Id VARCHAR(50)
DECLARE @nProject_Id VARCHAR(50)

And a Select Query

Select nOdc_Id ,nProject_Id  From ProjectTable Where ProjectId='53'

Now I want to set the parameter's value as

Set @=nOdc_Id =nOdc_Id 
And @nProject_Id =nProject_Id

Please any one help how can I implement this in StoredProcedure.

Best Solution

Select @nOdc_Id = nOdc_Id, 
       @nProject_Id = nProject_Id  
From ProjectTable 
Where ProjectId = 53

Related Solutions

SQL Server SELECT INTO @variable

If you wanted to simply assign some variables for later use, you can do them in one shot with something along these lines:

declare @var1 int,@var2 int,@var3 int;

select 
    @var1 = field1,
    @var2 = field2,
    @var3 = field3
from
    table
where
    condition

If that's the type of thing you're after

Sql – How to Select Every Row Where Column Value is NOT Distinct

This is significantly faster than the EXISTS way:

SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN
  (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)

Best Solution

Related Solutions

SQL Server SELECT INTO @variable

Sql – How to Select Every Row Where Column Value is NOT Distinct

Related Question