Code Snippets
Showing posts with label
t-sql
.
Show all posts
Showing posts with label
t-sql
.
Show all posts
Thursday, August 13, 2009
Select Into Multiple Variables
DECLARE @x nvarchar(max)
DECLARE @y nvarchar(max)
select @x=name,@y=city FROM (SELECT TOP 1 name, city FROM Table1) a
SELECT @x, @y
Older Posts
Home
Subscribe to:
Posts (Atom)