Why rewrite things when you can...

It still needs to be a TABLE level CHECK contraint.

pklug (3/12/2009)

---

Yeah, my question was a bit vague; Sorry about that.

The basic operation of this will (should) be:

1. Customer selects a combination of 3 attributes, as shown in the...

frankivey (3/12/2009)

---

Yes...

Start with this and go from there:

declare @price table (

PriceID int,

UnitPrice money

);

declare @PriceGroup table (

PriceID int,

...

Nope. I still have BOL for SQL Server 2000 on one of my desktop systems. Read about SAVE TRANSACTION in BOL.

SQL Guy (3/12/2009)

---

I need to create a check constraint on a phone table.

This table has :

phone_id (PK, identity),

user_id (FK),

phone_num,

decsription,

is_primary bit

The rule is that only one...

I just sent "she who must be obeyed" the link you provided.

We'll see...

GilaMonster (3/12/2009)

---

It's available on...

JacekO (3/12/2009)

---

Lynn,

That's my point. The proper nesting is not supported by the SQL. Maybe it's because of the violation of the ACID rules but it is not there.

I ...

JacekO (3/12/2009)

---

Lynn,

If I am not mistaken the SAVE POINTS still does not provide you with an option to nest. It allows you to rollback to a certain point but...

Here is some test code. Let me know if this helps.

declare @teststr varchar(20);

set @teststr = 'p_a3c_master';

select

@teststr

where

@teststr like '__[A-Za-z][A-Za-z][A-Za-z]%';

set @teststr = 'p_abc_master';

select

...

Regarding transactions, you can use SAVE POINTS to avoid ROLLBACK undoing all your work. You can do this to nest your transactions, and yet ensure that some of the...

Or:

declare...

Here is some test code for you to work with:

create table #Temp (

Column1 datetime,

Column2 datetime null

);

insert into #Temp (Column1)

select '2009-03-12 07:00' union...