Mega Code Archive
Create a dynamic sql statement and save it in a varchar type variable
<![CDATA[
3> CREATE TABLE Employees (
4> EmployeeID int NOT NULL ,
5> LastName nvarchar (20) NOT NULL ,
6> FirstName nvarchar (10) NOT NULL ,
7> Title nvarchar (30) NULL ,
8> TitleOfCourtesy nvarchar (25) NULL ,
9> BirthDate datetime NULL ,
10> HireDate datetime NULL ,
11> Address nvarchar (60) NULL ,
12> City nvarchar (15) NULL ,
13> Region nvarchar (15) NULL ,
14> PostalCode nvarchar (10) NULL ,
15> Country nvarchar (15) NULL ,
16> HomePhone nvarchar (24) NULL ,
17> Extension nvarchar (4) NULL ,
18> Photo image NULL ,
19> Notes ntext NULL ,
20> ReportsTo int NULL ,
21> PhotoPath nvarchar (255) NULL
22>
23> )
24> GO
1>
2>
3> DECLARE @InVar varchar(200)
4>
5> SET @InVar = 'DECLARE @OutVar varchar(50)
6~ SELECT @OutVar = FirstName FROM Employees WHERE EmployeeID = 1
7~ SELECT ''The Value Is '' + @OutVar'
8>
9> EXEC (@Invar)
10> GO
---------------------------------------------------------------
NULL
(1 rows affected)
1>
2> drop table Employees;
3> GO
]]>