2012-02-02
3,429 reads
2012-02-02
3,429 reads
2012-02-02
25,447 reads
2012-01-26
2,530 reads
2012-01-24
2,494 reads
This article presents an easy method to get YTD data grouped by months in T-SQL.
2012-01-24
19,172 reads
2012-01-17
2,812 reads
2012-01-10
2,481 reads
Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Word so I have to take it like that. I use it a lot to help me capture the results of a stored procedure.
2012-01-06
4,436 reads
2012-01-04
2,787 reads
This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.
2011-12-26
10,216 reads
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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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