How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,564 reads
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,564 reads
TweetG’day,
Saturday 8th April 2017 will see the biggest ever SQL Saturday South Island New Zealand. The event started in 2013...
2017-03-28
972 reads
Requirement: Recently we got the information from management
that our project will be getting the customers from China, so our application
should...
2017-03-28
189 reads
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
1,003 reads
Welcome to the 4th Interview of Data Channel. We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory OLTP" tables. Interview was...
2017-03-28
13 reads
Welcome to the 4th Interview of Data Channel. We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory OLTP" tables. Interview was...
2017-03-28
23 reads
Welcome to the 4th Interview of Data Channel.
We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New...
2017-03-27
292 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-03-27
320 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-27
709 reads
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
516 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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