XQuery – Accessing the Attributes Axis
Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...
2014-12-26 (first published: 2014-12-19)
1,579 reads
Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...
2014-12-26 (first published: 2014-12-19)
1,579 reads
Hey all, Continue to my whats New series, I am going through its new features and the more I am...
2014-12-19
579 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-12-19
443 reads
Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5...
2014-12-19
491 reads
If you’re currently an Office 365 customer that is using Power BI sites then you probably found an early Christmas...
2014-12-19
1,257 reads
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
866 reads
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what...
2014-12-18
629 reads
Reviewing the year 2014, I can see that I have truly started improving my life by lowering the number of...
2014-12-18
435 reads
I’ve spoken at lots of events, but all in the US and the UK. Next year I get my first...
2014-12-17
811 reads
OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...
2014-12-23 (first published: 2014-12-17)
7,886 reads
By alevyinroc
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...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
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