2008-11-18
4,523 reads
2008-11-18
4,523 reads
2008-11-14
18,636 reads
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
4,101 reads
2008-12-08 (first published: 2008-11-07)
495 reads
2008-11-06
4,079 reads
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
2008-11-06
4,328 reads
This script will return record count of all user tables from the current database
2008-11-05
1,105 reads
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
2008-11-05
3,263 reads
2008-11-04
3,442 reads
Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!
2008-11-04
11,887 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