Pass tablename as parameter

Question

0.00/5 (No votes)

See more:

How to pass tablename as parameter in sqlserver???
using only T-SQL(stored procedure) not through c# or vb...
So many times I googled But i Cannot get actual result..
plz help me...
Thanx in advance...

Posted 19-Sep-11 23:44pm

abintj

Add a Solution

4 solutions

Solution 2

Try this.

SQL

Create procedure tabproc
(
@tablename Varchar(500)
)
as
begin

   EXEC('Select count(*) from '+ @tablename )

End

Posted 19-Sep-11 23:48pm

Toniyo Jackson

v2

Solution 3

Hope this sample code helps:

SQL

CREATE PROCEDUER TableNameProc
@TableName NVARCHAR(100)
AS
Begin
Declare @ResultSet Nvrarchar(100)

Set @ResultSet = 'Select * from ' + @TavkeName

exec(@ResultSet)
End

Posted 19-Sep-11 23:49pm

Ganesan Senthilvel

Solution 4

Let try this one:

SQL

Create Procedure GetTableData @TableName
As
Begin
    Exec('Select * from ' + @TableName)
End

Posted 19-Sep-11 23:53pm

Bun Leap_kh

Comments

abintj 21-Sep-11 0:51am

Thanx to all...

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2011-09-19T23:47:00

Solution 1

You pass it as a string, but then in your stored proc, you have to use "dynamic sql":

SQL

CREATE PROCEDURE [dbo].[spn_executeSQLExample] 
(
    @tableName VARCHAR(100)
)
AS
BEGIN
    DECLARE @sqlStatement AS NVARCHAR(500)
    SET @sqlStatement = 'SELECT COUNT(*) FROM ' + @tableName

    exec sp_executesql @sqlStatement
END

Posted 19-Sep-11 23:47pm

#realJSOP

Comments

abintj 20-Sep-11 5:54am

I got it..Thanx John..

Pass tablename as parameter

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Pass tablename as parameter

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us