raghuldrag (10/9/2012)

---

Hi friends,
create tab T1(name varchar(22),age numeric(22))
create tab T2(name varchar(22),age numeric(22))
insert into t1 values('ram',22)
insert into t1 values('am',26)
insert into t1 values('sam',28)
insert into t1 values('bam',23)
insert into t1 values('kam',21)

insert into t2 values('yam',22)
insert into t2 values('dam',22)
insert into t2 values('gam',22)
insert into t2 values('pam',22)

now i need to create procedure if am giving the table name has input
show the output of name only!!!!

exec pro(t1)

expecting output:

NAME
ram
am
sam
bam
kam

ChrisM@home (10/10/2012)

---

You could also use dynamic sql for this.

CREATE PROCEDURE GetData(@TableName NVARCHAR(120), @Columns NVARCHAR(255))
AS 
BEGIN
	DECLARE @Query AS NVARCHAR(MAX)
	SET @Query = 'SELECT ' + @Columns + ' FROM ' + @TableName
	EXEC sp_executesql @Query
END
GO

EXEC GetData('t1', 'name')
GO

raghuldrag (10/10/2012)

---

if you dnt mind would please explain the "sp_executesql" what is the use??
and what should be do there??