比如:
CREATE PROCEDURE test_add_newTable
@nid int
AS
select top 0 * into t_@nid_test from t_test
GO
当我执行test_add_newTable 1的时候
t_@nid_test要变成t_1_test,该怎么写啊。谢谢各位啊
CREATE PROCEDURE test_add_newTable
@nid int
AS
select top 0 * into t_@nid_test from t_test
GO
当我执行test_add_newTable 1的时候
t_@nid_test要变成t_1_test,该怎么写啊。谢谢各位啊
@nid int
AS
exec ('select top 0 * into t_'+@nid+'_test from t_test')
GO