Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification...
2013-09-02
1,224 reads
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification...
2013-09-02
1,224 reads
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...
2013-09-02
2,652 reads
In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...
2013-09-02
3,408 reads
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
551 reads
The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the...
2013-09-01
948 reads
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,218 reads
The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...
2013-08-31
4,262 reads
We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM...
2013-08-31
1,186 reads
How to find sql server version,edition,Server Name?
SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .
By using this function you can...
2013-08-31
26,303 reads
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-08-31
1,449 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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