'CREATE SCHEMA' must be the first statement in a query batch

by Joe Hunter 11. December 2011 18:23
If you receive this error when trying to create a schema in a stored procedure try this instead:

exec('use db; exec sp_executesql N''create schema test''')

sql

Tags:

T-SQL

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen