2015年
-
编辑 删除
create sqlserver procedure in a specify db on remote server or linkedserver
declare @sqlnvarchar(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 [mylinkeds...
