34,590
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('Proc_Test') IS NOT NULL
DROP PROC Proc_Test
GO
CREATE PROC Proc_Test
AS
BEGIN
SET NOCOUNT ON
IF OBJECT_ID('test') IS NOT NULL DROP TABLE test
CREATE TABLE test
(
费项 NVARCHAR(50)
)ON [PRIMARY]
DECLARE @table_id INT,
@sql_getid NVARCHAR(2000)
SET @sql_getid =
'select @table_id_int = [id] from sysobjects where name =''test'''
EXEC sp_executesql @sql_getid,
N'@table_id_int int output',
@table_id OUTPUT
SELECT @sql_getid [@sql_getid],
@table_id [@table_id] --调试备用
DROP TABLE test
END
GO
EXEC Proc_Test
declare @table_id_int int,@sql_getid nvarchar(2000)
set @sql_getid='select @table_id_int = [id] from ' +@dbname+ '.' +@ownername+ '.sysobjects
where name =''' +@tablename+ ''''
exec sp_executesql @sql_getid , N'@table_id_int int output' , @table_id_int output