Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,352 reads
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,352 reads
2007-12-12 (first published: 2007-10-12)
3,497 reads
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,812 reads
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
Comments posted to this topic are about the item Why Would You Do That?
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers