Introduction to XML DML (Part 3) - Using the modify() method: delete
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
10,330 reads
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
10,330 reads
We’ve had two of them since right after the launch and overall I’m pleased. They get used quite a bit...
2012-02-06
583 reads
Hi, all! It's been a while, since I posted a blog entry, and is directly related to today's Meme Monday...
2012-02-06
1,914 reads
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...
2012-02-06
1,225 reads
Hello Dear Reader! Last year I tossed my hat in the ring on the world of Presenting. This was a...
2012-02-06
773 reads
It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...
2012-02-06
1,001 reads
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,141 reads
On a dark and spooky night in the land of SQL Server make-believe, a young warrior was asked to slay...
2012-02-05
1,157 reads
When you are creating multiple threads that need to access a shared resource then you need to implement some form...
2012-02-05
77 reads
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
496 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...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
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