Dynamic Script

Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2014-12-31 (first published: 2014-12-10)

1,322 reads

Blogs

This is an interesting invitation this month. Jeff Ianucci is a new host, and...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

The first version of my accounting assistant could not find a single purchase of...

Comments posted to this topic are about the item Pay for Performance, which is...

Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa Tengah 56200

Jl. Pangeran Diponegoro No.120, RT.002/RW.010, Serdo Barat, Kutoarjo, Kec. Kutoarjo, Kabupaten Purworejo, Jawa Tengah...

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;