You can also generate a similar output in SQL 2000 with this statement:

DECLARE @mystring VARCHAR(8000)

SELECT @mystring = ''

SELECT @mystring = @mystring + CAST(MyId AS VARCHAR) + ';'

FROM MyTable

SELECT...

Of course you could save some time by executing the following:

EXEC sp_msforeachtable 'GRANT ALL ON ? TO { user_or_role_name }'

One of the easiest ways to use strings which contain single quotes is to replace all instances of the single quote with two single quotes. SQL Server handles two single...