2006-07-28
1,966 reads
2006-07-28
1,966 reads
2006-07-26
1,685 reads
to get information about tables+columns+primarykeys+foreignkeys+identity, i firstly used SQL server built-in INFORMATION_SCHEMA.xxx. however, my company have various DBAs and each of them owns objects. when using INFORMATION_SCHEMA.xxx, it retrieves data based on current login (version 2005 resolves this schema v.s. object owner problem already... yeah) , which bring me a great trouble. if you want […]
2006-08-30 (first published: 2006-07-25)
609 reads
2006-07-14
1,832 reads
The benefits and drawbacks of GUIDs as primary keys are generally known. Despite the drawbacks, some people use them to fulfill specific business requirements (the IDs are unique across multiple servers).
2006-06-30
2,858 reads
2006-06-21
1,972 reads
2006-06-14
1,704 reads
After replying to a post today I thought I'd share this with all.This is a user defined function that I use to return a table of parameters passed in a parameter string. Function UsageSelect * From dbo.fnParseParamString ([@ParamString='Delimited String of parmaters'],[@Delimeter='Delimiting Character'])Lets say you are concatenating a list of form data from a web page […]
2006-06-13 (first published: 2006-06-07)
401 reads
2006-05-24
1,900 reads
Continuing with his series on SQL Server 2005 from the developer's perspective, M. ChoirulAmri examines the ROW_NUMBER function and gives a few examples of how you can use this in your application.
2006-05-11
13,507 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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