Insertion Query Creation of a Table in Milliseconds
This script helps you to constitute insertion procedures for tables in a millisecond.
2012-08-30 (first published: 2007-11-05)
2,368 reads
This script helps you to constitute insertion procedures for tables in a millisecond.
2012-08-30 (first published: 2007-11-05)
2,368 reads
A simple way to find any term in all banks or only in a specific database.
2012-08-28 (first published: 2012-08-17)
826 reads
A few brief selects to expose snippets of data which may be useful for debugging larger issues.
2012-08-27 (first published: 2012-08-15)
3,894 reads
2012-08-24 (first published: 2007-09-29)
1,727 reads
2012-08-23 (first published: 2008-06-05)
1,733 reads
2012-08-22 (first published: 2008-03-24)
1,917 reads
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
3,011 reads
Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.
2012-08-20 (first published: 2012-07-27)
1,628 reads
Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.
2012-08-16 (first published: 2012-08-02)
977 reads
Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.
2012-08-14 (first published: 2012-08-08)
2,274 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...
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