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?

• Next in forum: Re: argue why sql2005
• Prev in forum: SS2000 shows password in icon tooltip
• Thread view: Re: when to use fully qualified names ([database].[schema].object)

[Reply to this message]