Learn how to unit test SQL Server T-SQL code
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art of writing repeatable, using unit tests for even the...
2017-09-05
12 reads
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art of writing repeatable, using unit tests for even the...
2017-09-05
12 reads
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn’t order) files....
2017-09-04
78 reads
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn’t order) files....
2017-09-04
78 reads
I have been trying to get my blogging going again after a gap of two months. It has been incredibly...
2017-09-04
517 reads
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files. I have been thinking about ssis quite a lot...
2017-09-04
28 reads
In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...
2017-09-04
433 reads
In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...
2017-09-04
791 reads
The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think...
2017-09-04
803 reads
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
775 reads
If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...
2017-09-04
532 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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