2008-03-04
3,643 reads
2008-03-04
3,643 reads
This article will show how you can produce a return regardless of variables passed and debugging tool for @SQL String.
2008-03-04
5,292 reads
2008-03-03
4,695 reads
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
2008-02-27
7,220 reads
Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.
2010-07-30 (first published: 2008-02-27)
81,570 reads
2011-04-01 (first published: 2008-02-23)
3,856 reads
2008-04-18 (first published: 2008-02-22)
3,894 reads
This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.
2009-04-10 (first published: 2008-02-21)
40,172 reads
2008-02-13
4,114 reads
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
2008-02-12
13,053 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