Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- t1.Routine_Definition
- FROM
- [server1].MyDatabase.INFORMATION_SCHEMA.Routines t1
- LEFT JOIN
- [server2].MyDatabase.INFORMATION_SCHEMA.Routines t2 ON t1.Routine_Name = t2.Routine_Name
- WHERE
- t2.Routine_Name is null
- --Some comment
- SELECT Column
- FROM Somewhere
- declare @sql varchar(8000) -- varchar(max) in SQL 2005+
- SELECT
- @sql = t1.Routine_Definition
- FROM
- INFORMATION_SCHEMA.Routines t1
- print @sql
- DECLARE MY_CURSOR Cursor
- FOR
- SELECT
- t1.Routine_Definition
- FROM
- [server1].MyDatabase.INFORMATION_SCHEMA.Routines t1
- LEFT JOIN
- [server2].MyDatabase.INFORMATION_SCHEMA.Routines t2 ON t1.Routine_Name = t2.Routine_Name
- WHERE
- t2.Routine_Name is null AND
- LEN(t1.Routine_Definition) < 4000
- Open My_Cursor
- DECLARE @sql VARCHAR(MAX)
- FETCH NEXT FROM MY_Cursor INTO @sql
- While (@@FETCH_STATUS <> -1)
- BEGIN
- IF (@@FETCH_STATUS <> -2)
- Print @sql
- FETCH NEXT FROM MY_CURSOR INTO @sql
- END
- CLOSE MY_CURSOR
- DEALLOCATE MY_CURSOR
- GO
Add Comment
Please, Sign In to add comment