Loading

How to make table name dynamic

Amit Kumar Singh

8y987

Hello,

I have more then one table.I have written stored procedure for Insertion.I want to make table name dynamic so i dont have to write insert query many times.

Thanks in Advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Accepted answer
Please try this
CREATE PROCEDURE asd
(@table nvarchar(10), @id int)
AS
BEGIN
    DECLARE @sql nvarchar(max)
    SET @sql = 'INSERT INTO ' + @table + ' (id) VALUES (' + CAST(@id AS nvarchar(max)) + ')'
    EXEC sp_executesql @sql
END
+1
Shahriar Nikkhah8y ago
You have to write and INSERTion for each table,
having a SP is not right, why ? becasue each table has different fields different data type and etc...

each needs to be treated differently

good luck
+1