Posted by fireball on 01/03/07 14:05

Uzytkownik "Erland Sommarskog" <esquel@sommarskog.se> napisal w wiadomosci

once in my script:
declare @db varchar(255), @sch varchar(255)
set @db = 'somebase'
set @sh = 'someschema'

But I failed trying sql:
create schema somebase.someschema
/set @sql = 'create schema ' + quotename(@db) + '.' + quotename(@sch);
exec sp_executesql @sql/
- how to name it fully?

[Back to original message]