SQL Server vs Oracle: Convert string to date
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,367 reads
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,367 reads
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
694 reads
One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the...
2017-08-11
1,288 reads
Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on...
2017-08-29 (first published: 2017-08-11)
1,884 reads
Original help was identified from this article Why is VirtualBox only showing 32 bit guest versions on my 64 bit...
2017-08-10
145 reads
Well, that’s something to be proud of. This is my 500th post on this blog. Not including a handful of...
2017-08-10
423 reads
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up...
2017-08-10
506 reads
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing...
2017-08-10
425 reads
And like the wind another SQL Saturday Louisville has come and gone. This past weekend seemed to be a huge...
2017-08-09
490 reads
I always have a special place in my heart for the SQL Server user groups of the mid-west. I ran...
2017-08-09
148 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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