How many records/columns in customers

As J.O.S. was suggesting

SELECT Sn.[id],COUNT(*) AS coun_id

FROM Sn RIGHT JOIN SilokE ON sn.[id]=SilokE.[id]

Where sn.[id] IS NULL

GROUP BY SilokE.[id]

For all remove the where clause.

Have a look at : Making the most of SQL Server 2000 collations at http://www.itworld.com/AppDev/136/ITW3856/pfindex.html

Quit interesting the subjective part of the discussion.

Remind me of an article, think it was a Barbara Kitchen, why do a lot of projects fail : Visibility and Communications. Chuck...

SQL Internal Datetime:

datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds)....

I basic need/purpose is to perform some integrity checks, whether through triggers, foreign keys, stored procedures, etc.

I think one should look at the seq in which the server apply foreign...

What about the nested firing of triggers are on?

Oops, should have added the following:

Open Query Analyser.

Change database to your database.

Copy and paste code from previous post.

Is this what you want?

CREATE TABLE [dbo].[Test] (

[ColA] [int] NOT NULL ,

[ColB] [varchar] (5) NOT NULL ,

[ColC] [money] NOT NULL)

GO

ALTER TABLE [dbo].[Test] WITH NOCHECK ADD

CONSTRAINT [PK_Test] PRIMARY KEY ...

Thanks for replying.

Just read the thread again.

You have said it already, "No hints, no special tricks, just good development practives, proper testing and keeping transaction ops short and batchs down/overnight."...

CKempste will you supply a bit more info. on your environment, standards, etc.

To leave the database in a consistent state.

If the trigger detect an error a rollback / undo of the 'insert' is automatically performed.

Read about Codd and his 10 relational commandments.

I think there was a discussion on this site about the 'limit' in 2000, bit low on fuel to search for it.

Other potential problem with IN is NULLS and NOT...

Stop SQL server. Copy mdf / ldf to another SQL Server and try to attach the database.

What is better to use the on clause exclusive for the links between tables or to add everything into the on clauses, thus making the where clause fairly small