CTE - Limitations
Hi
Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...
2014-07-27
1,454 reads
Hi
Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...
2014-07-27
1,454 reads
Hi Greetings to everyone,
Today I am going to report a bug in SSIS 2012. In one of the packages I...
2014-07-27
1,004 reads
AdvertisementsThere are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...
2014-08-01 (first published: 2014-07-27)
15,910 reads
The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2014-07-27
764 reads
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...
2014-07-25
216 reads
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.
There is a technological event...
2014-07-25
215 reads
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...
2014-07-25
1,479 reads
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...
2014-07-25
887 reads
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-07-25
818 reads
One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign...
2014-07-25
670 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