Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
26,785 reads
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
26,785 reads
2008-07-23
500 reads
While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.
2008-07-21
5,482 reads
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
2008-07-21
4,977 reads
2008-09-19 (first published: 2008-07-20)
1,524 reads
2008-07-20
1,651 reads
2008-09-08 (first published: 2008-07-20)
1,305 reads
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,567 reads
2008-10-10 (first published: 2008-07-20)
1,930 reads
All of us have problems with Duplicate rows, here is a simple and efficient way of removing duplicate rows
2008-10-03 (first published: 2008-07-18)
1,704 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