Win a SQLBits Pass
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
573 reads
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
573 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage?
Code coverage is a way to see how...
2016-04-13 (first published: 2016-04-08)
4,448 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
49 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
60 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see how many statements in your database code have been...
2016-04-08
15 reads
The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database
Method 1:
1. select the database...
2016-04-08
490 reads
In my previous blog we saw the Full-Text Index architecture.
http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html
In this blog we shall see its implementation. Before you proceed...
2016-04-13 (first published: 2016-04-08)
2,654 reads
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-14 (first published: 2016-04-08)
1,961 reads
I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...
2016-04-07
618 reads
There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...
2016-04-07
332 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