The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,569 reads
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,569 reads
2008-06-20
4,355 reads
2008-06-18
4,371 reads
2008-08-08 (first published: 2008-06-16)
988 reads
Discusses the use of the newly introduced APPLY Statement in SQL Server 2005
2009-02-27 (first published: 2008-06-16)
25,042 reads
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
2008-06-13
1,978 reads
T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.
2008-08-04 (first published: 2008-06-11)
1,393 reads
When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.
2008-06-10
2,938 reads
2008-06-09
3,984 reads
2008-06-08
1,959 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