Splitting CSV strings in SQL 2016
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,751 reads
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,751 reads
One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.
To verify this,...
2016-09-08
588 reads
Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...
2016-09-08
435 reads
I’m happy to announce that I’m speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas...
2016-09-08
359 reads
This is nothing new but it’s still a fun idea.
The problem:
The vendor app we just purchased (and are told we...
2016-09-08
502 reads
Are you going to SQL Saturday Denmark, which is running on Saturday 17th September? If you are David Postlethwaite or @postledm...
2016-09-08
436 reads
Special
Table Types
Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...
2016-09-08
215 reads
This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL...
2016-09-08
400 reads
If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.
Over the...
2016-09-08
208 reads
Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...
2016-09-08
214 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers