It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.
2019-06-07 (first published: 2017-10-30)
11,602 reads
Hi, I installed MS SQL Server 2000 + SP2 with default options. It was installed in a mixed mode. Now I noticed that the SQL server login passwords are not case sensitive. i.e. for e.g 'PASSWORD' and 'password' are same. Usually passwords are case sensitive. Why it is like this? Regards Unnic
2004-11-26
1 reads
Superfast set based query (0.093 sec for a table of 10000+ records of 40-50 characters): CREATE TABLE [Numbers] ( [PkNumber] [int] IDENTITY (1, 1) NOT NULL , CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED ( [PkNumber] ) ON [PRIMARY] ) ON [PRIMARY] GO Declare @i as int set @i = 0 while @i < 8000 begin Insert […]
2004-11-02
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers