T-SQL EXCEPT and INTERSECT
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...
2015-03-03 (first published: 2015-02-23)
9,053 reads
“sp_helptext“ – Useful command to view detail TIP #85
It might be already known to you but I thought for sharing because I frequently use this command and it...
2015-02-22
393 reads
SQL Saturday NYC Update #4
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
268 reads
SQL Saturday NYC Update #4
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
783 reads
A Critical SQL Server 2014 Cumulative Update
If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...
2015-02-20
275 reads
A Critical SQL Server 2014 Cumulative Update
If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...
2015-02-20
768 reads
Friday Followup For February 20, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-20
447 reads
A .Net Developers Favorite Learning Resources
At a recent Brighton Alt.Net the question came up “What learning resources do people use to continuously learn?”, as a...
2015-02-20
66 reads
SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-02-20
260 reads
Source control isn't just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
452 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
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