Learn Different Options for Importing Data Into SQL Server
Most of the time users need to import their data into SQL Server for its proper management. Select from the...
2018-01-22
830 reads
Most of the time users need to import their data into SQL Server for its proper management. Select from the...
2018-01-22
830 reads
After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well,...
2018-01-22
260 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-22
1,166 reads
System-versioned temporal tables is new database feature of SQL Server 2016. Another improved version of table level auditing with some...
2018-01-22
802 reads
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
133 reads
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
386 reads
SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or stopping SQL Service, knowing how many instances and what...
2018-01-21
26 reads
SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or stopping SQL Service, knowing how many instances and what...
2018-01-21
22 reads
SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or...
2018-01-21
14,306 reads
(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as...
2018-01-20
1,136 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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