Posted by David Portas on 06/09/05 02:17

If possible, simplify your DDL to just the essential columns (including the
keys). Yes, it's a good idea to keep a scratch database on your laptop or
desktop for this sort of thing. See also:
http://www.aspfaq.com/etiquette.asp?id=5006

Glad I helped.

--
David Portas
SQL Server MVP
--

• Next in forum: Re: what type of Constraint to prevent duplicates
• Prev in forum: Re: Triggers on tables underlying a partitioned view
• Thread view: Re: Select distinct one some fields, but return all feilds

[Reply to this message]