Database

uroojkhan wrote:

EXEC executes the stored procedure not the variable.

Colin Angus Mackay wrote:

Exec can be used to execute dynamic SQL as well as stored procedures.

Saira Tanwir wrote:

i understand that the stored procedure treats the 'table_name' in the SELECT clause as a constant name.
how can i make it a variable

Saira Tanwir wrote:

i'm creating a stored procedure that will give me the structure of whichever table name i provide it with.

CREATE PROCEDURE Describe_table (@table_name varchar) AS 
SET NOCOUNT OFF
Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @table_name
GO

Ravi Shankar43 wrote:

iam getting error when setting the value to the variable

SET @abc='Its varchar typed'

SELECT @abc='Its new value'

Emp_Id  Emp_Name  Emp_Salary
1	ABC	2500.0000
2	ACD	1000.0000
3	AND	6000.0000
4	SVN	10000.0000
5	AYK	8500.0500
6	AT	8500.0000
7	NM	8500.0000
8	AK	5000.0000
9	VD	20000.0000
10	VP	100.0000
11	CV	8500.0000

SELECT *
FROM (SELECT TOP 3 *
FROM (SELECT TOP 5 *
FROM EMP	
ORDER BY EMP_ID ASC) AS T10
ORDER BY EMP_ID DESC) AS T5
ORDER BY EMP_ID ASC