Temporal Tables in 60 seconds
If you've ever designed a database you've most certainly run into the need for what we called history tables, those...
2016-10-11
444 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those...
2016-10-11
444 reads
#TSQL2SDAY is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam...
2016-10-11
215 reads
This month is an interesting T-SQL Tuesday topic, and it’s brought to us by Andy Mallon, with the topic of...
2016-10-11
623 reads
On Monday, October 24, 2016, there will be a Free-Con in Seattle for those that might not be attending a...
2016-10-11
443 reads
Today is the last day to register to vote in Texas. I’m not sure about other states in the US...
2016-10-11
434 reads
Busy, busy, busy.
A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the...
2016-10-11
446 reads
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and...
2016-10-11
423 reads
As I scrolled through the twitter feeds I ran across one from Tom LaRock (b|t) on PASS Summit being three...
2016-10-11
418 reads
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...
2016-10-11
434 reads
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
424 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...
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