gillesnebel
Programmer
Hi,
Can somebody help me with the following stored procedure. I want to declare dynamically the name of table that has to be filled. But there must be a syntax error.....
CREATE PROCEDURE [sp_TransferTax]
(
@DataTableName VarChar (150)
)
AS
INSERT INTO @DataTableName (x,y,z) VALUES (1,2,3)
GO
Can somebody help me?
Thanks
Can somebody help me with the following stored procedure. I want to declare dynamically the name of table that has to be filled. But there must be a syntax error.....
CREATE PROCEDURE [sp_TransferTax]
(
@DataTableName VarChar (150)
)
AS
INSERT INTO @DataTableName (x,y,z) VALUES (1,2,3)
GO
Can somebody help me?
Thanks