InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:59:40 GMT20http://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspx[quote][b]raghuldrag (10/10/2012)[/b][hr]if you dnt mind would please explain the "sp_executesql" what is the use??and what should be do there??[/quote]Check this link on the site [url]http://www.sqlservercentral.com/Forums/Topic1244180-1292-1.aspx[/url].There are few more just google "sp_executesql vs EXEC"...PedroThu, 11 Oct 2012 00:38:44 GMTPiManéhttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspxif you dnt mind would please explain the "sp_executesql" what is the use??and what should be do there??Wed, 10 Oct 2012 22:48:52 GMTraghuldraghttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspxIt'sEXEC GetData 't1', 'name'GO... without parentheses.Wed, 10 Oct 2012 06:35:29 GMTArthur Kirchnerhttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspxwhile executing dis query error occured on output:execWed, 10 Oct 2012 05:46:11 GMTraghuldraghttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspx[quote][b]ChrisM@home (10/10/2012)[/b][hr]You could also use dynamic sql for this.[/quote][code="sql"]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 @QueryENDGOEXEC GetData('t1', 'name')GO[/code]In this example you can specify the columns you want on the output...PedroWed, 10 Oct 2012 04:08:10 GMTPiManéhttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspx[quote][b]raghuldrag (10/9/2012)[/b][hr]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 inputshow the output of name only!!!!exec pro(t1)expecting output:NAMEramamsambamkam[/quote]exec pro(t1) won't work, this will: exec pro('t1')Assuming the table name is captured into parameter Tablename, your stored procedure could look something like this:IF @Tablename = 'T1' SELECT DISTINCT Name FROM t1ELSE IF @Tablename = 'T2' SELECT DISTINCT Name FROM t2You could also use dynamic sql for this.Wed, 10 Oct 2012 01:03:31 GMTChrisM@homehttp://www.sqlservercentral.com/Forums/Topic1370673-392-1.aspxHi 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 inputshow the output of name only!!!!exec pro(t1)expecting output:NAMEramamsambamkamTue, 09 Oct 2012 22:58:51 GMTraghuldrag