Upcoming SQL Saturdays & Precons
This coming weekend is the SQL Saturday #307 in Iowa City, Iowa. I am really looking forward to attending this event...
2014-06-04
469 reads
This coming weekend is the SQL Saturday #307 in Iowa City, Iowa. I am really looking forward to attending this event...
2014-06-04
469 reads
If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started,...
2014-06-04
339 reads
This is a good question for me to ask. I’ve been learning it, and working through examples in my PowerShell...
2014-06-06 (first published: 2014-06-04)
3,785 reads
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,097 reads
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,077 reads
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....
2014-06-04
1,294 reads
I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations...
2014-06-03
1,137 reads
Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting...
2014-06-03
480 reads
I was interested to see that the online voting system has changed this year to one powered by Simply Voting....
2014-06-03
414 reads
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you...
2014-06-03
488 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