Monday, September 26, 2016

select record in variable SQL

DECLARE @var1 varchar(30)  
SELECT @var1 = 'Generic Name'  
SELECT @var1 = ((SELECT top 10 Client_account_number FROM #TempTable1))  
SELECT @var1 AS 'account_number' ;

No comments:

Post a Comment