OmniCompare: A free tool to compare SQL Instances
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,879 reads
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,879 reads
It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write...
2016-06-14
1,139 reads
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,369 reads
The host for T-SQL Tuesday #79 is Michael J. Swart (b|t), and his topic of choice is to write about...
2016-06-14
645 reads
Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...
2016-06-14
4,749 reads
This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016
I’ve been...
2016-06-14
268 reads
Well, today is a busy T-SQL Tuesday no. 79, (it's also Flag Day in the U.S, and also a clerical...
2016-06-14
1,881 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
11 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
24 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
284 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...
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