This script will help you locate columns that you provide in a comma delimited format. You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in.
2004-08-13 (first published: 2004-01-22)
162 reads
This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database. This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP. It will then generate, and execute, all […]
2004-01-22
309 reads
2004-01-22
435 reads
This script starts in the master database, and then goes to each USER database and creates the DDL for each USER table in every database. You can then save the results or copy them to a new query window to run on another server.
2003-11-14
544 reads
This script will create another script that has all foreign key DDL that exists in a given database. You only have to run this, and then select the results of this script and paste it into another query window, or if for some reason you have lost your DDL this will enable you to retrieve […]
2003-11-12
278 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers