how to pass tablename as parameter in sql server

Question

hello frnds i need to pass a table name as parameter to stored procedure

CREATE PROCEDURE six @tablename nvarchar AS SELECT * FROM + @tablename Go exec six Entry_sixsigma_mag

it gives error like

Msg 102, Level 15, State 1, Procedure six, Line 3 Incorrect syntax near '+'. Msg 208, Level 16, State 1, Procedure six, Line 3 Invalid object name '@sixsigma'.

Probable duplicate of stackoverflow.com/questions/3346842/… — goodeye
– goodeye, Commented May 12, 2012 at 0:23

Glorfindel · Accepted Answer · 2022-03-11 09:02:15Z

4

Try something like

CREATE PROCEDURE six @tablename nvarchar(100) AS EXEC('SELECT * FROM ' + @tablename) Go exec six Entry_sixsigma_mag

Have a look at EXECUTE (Transact-SQL)

But you should also have a look at

before using this blindly.

edited Mar 11, 2022 at 9:02

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered Nov 17, 2010 at 8:48

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bhushan Over a year ago

hey it gives error Msg 208, Level 16, State 1, Line 1 Invalid object name 'E'.

Adriaan Stander Over a year ago

You need to change nvarchar to nvarchar(100) or what ever your length is you need. You have to remember that if you do not specify the length of a NVARCHAR/VARCHAR it will assume 1.

littlegreen Over a year ago

Instead of EXEC('...') you can also use sp_executesql: msdn.microsoft.com/en-us/library/ms188001.aspx

Collectives™ on Stack Overflow

how to pass tablename as parameter in sql server

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related