create sqlserver procedure in a specify db on remote server or linkedserver

来源:这里教程网 时间:2026-03-02 10:42:29 作者:
declare @sql nvarchar(max)

set @sql = '
create procedure p_test as select * from sysobjects;
'

set @sql = REPLACE(@sql, '''', '''''')
set @sql = 'declare @sql nvarchar(max); set @sql = ''' + @sql + '''; use testdb; exec sp_executesql @sql; select db_name();'

execute(@sql) at [mylinkedserver1]

相关推荐