Are you looking for sys.schemas? IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name=”jim”) BEGIN EXEC(‘CREATE SCHEMA jim’) END Note that the CREATE SCHEMA must be run in its own batch (per the answer below)
I know this has already been answered, but I just spent more time than I care to admit coming up with single-line SQL statements to accomplish this, so I’ll share them here in case anyone else needs to do the same: — Encode the string “TestData” in Base64 to get “VGVzdERhdGE=” SELECT CAST(N” AS XML).value( … Read more
How long should I expect ALTER DATABASE … SET ENABLE_BROKER to run? alter database [<dbname>] set enable_broker with rollback immediate;
Take out the parentheses and the curly braces, neither are required when adding columns.
Note that TRUNCATE won’t work if you have any referential integrity set. In that case, this will work: EXEC sp_MSForEachTable ‘DISABLE TRIGGER ALL ON ?’ GO EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’ GO EXEC sp_MSForEachTable ‘SET QUOTED_IDENTIFIER ON; DELETE FROM ?’ GO EXEC sp_MSForEachTable ‘ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL’ GO … Read more
Schemas logically group tables, procedures, views together. All employee-related objects in the employee schema, etc. You can also give permissions to just one schema, so that users can only see the schema they have access to and nothing else.
I think this: SELECT ISNULL(NULLIF(listing.Offer_Text, ”), company.Offer_Text) AS Offer_Text FROM … is the most elegant solution. And to break it down a bit in pseudo code: // a) NULLIF: if (listing.Offer_Text == ”) temp := null; else temp := listing.Offer_Text; // may now be null or non-null, but not ” // b) ISNULL: if (temp … Read more