SQL Server Training in the Summer Time
Its been a long winter so far this weekend has seen the first signs of spring here in South Wales,...
2013-04-22
686 reads
Its been a long winter so far this weekend has seen the first signs of spring here in South Wales,...
2013-04-22
686 reads
There are two different command you can use to check if you are running 32-bit or 64-bit version of SQL...
2013-04-22
1,138 reads
Last week I had the following error message repeating over and over again in the SQL Server log of one of...
2013-04-25 (first published: 2013-04-22)
60,155 reads
Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...
2013-04-22
945 reads
This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...
2013-04-20
6,872 reads
SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the...
2013-04-20
1,226 reads
Have you ever been to a SQL Saturday where someone 'rocks up' for a beginner's presentation. In fact he or...
2013-04-20
619 reads
Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....
2013-04-20
600 reads
Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...
2013-04-19
1,332 reads
I wish this were the mantra of all people, but certainly those in technology:
Filed under: Blog Tagged: career, syndicated
2013-04-19
769 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