New Whitepaper: 5 Most Common Critical SQL Integrity Issues
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,213 reads
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,213 reads
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but...
2013-09-16
835 reads
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,279 reads
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The...
2013-09-16
27,171 reads
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-16
930 reads
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,589 reads
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...
2013-09-16
902 reads
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
673 reads
You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow...
2013-09-16
2,007 reads
Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very...
2013-09-16
836 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