|
|
Browse by Tags
All Tags » SQL Server 2005 » Database Development
-
This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it.
USE [tempdb]
GO
CREATE TABLE [dbo].[Table_1](
[Col1] [int] IDENTITY(1,1) NOT NULL,
[Col2] [char](1) NOT NULL
) ON [PRIMARY]
GO
delete from ...
-
I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals.
I think it's an excellent read. The only thing I don't think it covers is what is not included in the product. The most notable piece of Team System Unit Testing functionality that isn't included with DB Pro is Code ...
-
I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option. I thought it might be helpful to put up a post with tests for all the other object types that can have this option set.
select object_id,name,is_not_for_replication from sys.foreign_keys where ...
-
Recently I had a need to create some unit tests for a change to the database that was under development. I needed to change the database so that the NOT FOR REPLICATION option was set on all keys, constraints, indexes and triggers. Following an agile engineering best practice I created a schema unit test for ...
-
On Thursday 26th April Conchango hosted meetings of the London SQL Server User Group and the London SQL Server BI User Group. For those that aren't familiar with these groups they are external communities much like our own that are run independently by enthusiasts for the respective technology. Both groups emanate from Tony's ...
|
|
|