why does it fail though? I'm speculating that the constraint is merging the INSERTED and the DELETED rows to get the count or [INSERTED] and [tbl], so it finds...

your example was interesting!

I see how that fails, when I'd obviously think that was jsut fine...That's what you mean about having to test the business condition in the trigger instead,...

I saw mine jump up; thanks!

I got promoted as a result and I'm in the "Hall of Fame" now. only 17,000 more posts and I can be like

Steve Jones...

here's a simple example I whipped up to show the table constraint preventing more than three items checked out per student id:

Create Table tblStudent (

StudentID int identity(1,1)...

David Portas (8/14/2009)[hr

SQL Server unfortunately has quite poor support for referential integrity and other declarative constraints in the database. Such rules often have to be implemented in procedural code either...

recursive triggers is a per-database option; it is usually rare that you really need to call a trigger recursively, so it's disabled by default.

right click...properties for the database in quesiton...Options...

another thing you can try to change is this:

WHERE searchstring like '%@search1%' AND searchstring like '%@search2%' searchstring like '%@search3%'...

if you search for LIKE '%something%' , then it requires a...

ok i know i have SQL Express with Advanced Options instealled...i certainly have the options i was describing: some i've turned off, some are turned on...you can decide which to...

thanks!

i think the script is pretty kewl, but there's so many ways to skin a cat...you can do the same in SMO and stuff, so not too many people want...

pretty sure the SSMS can do this for you; it's just some check marks int he scripting options to include triggers, constriants, etc.(TOOLS>>Options>>Scripting>> section for TABLE...check/uncheck various scripting options)

i contributed...

you cannot reuse the numbers if there are gaps...at least not easily.

assuming you want a 10 digit number, ie 1 with 9 preceeeding zeros:

'0000000001'

Alter Table MyTable Add MyCalculatedColumn As RIGHT('0000000000'...

Sarab is right, it's already a built in option:

here's how I doing: bulk insert with dynamic SQL:

note the forum strips out the slash -n, so i put a placeholder {slash-n}

--bulk insert won't take a variable name, so make...

something like this: testing if any child data exists?

IF NOT EXISTS

( SELECT 1 FROM CHILDTABLE1 WHERE PK IN (SELECT...

doh thanks Matt; I did flub that up to get more than 15 instead of less than 15.