Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...
2014-03-10
393 reads
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...
2014-03-10
393 reads
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
3,004 reads
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,257 reads
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-27 (first published: 2014-02-24)
3,365 reads
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-24
368 reads
If you are reporting from a Cube in SSRS and you want to drill through to another report you can...
2014-02-10
1,244 reads
If you are reporting from a Cube in SSRS and you want to drill through to another report you can...
2014-02-10
360 reads
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
1,697 reads
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
430 reads
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
826 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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