So how do you release new production databases?

base table C has (let's say) 100 rows.

If any of the identifying fields in base table c do not match with the table it is joined to, you will get...

Is SQL Server Browser running? How exactly are you trying to connect (what are you typing in for server name)? Is it a default or named instance? Do you...

yogi123 (7/18/2012)

---

SQLKnowItAll (7/18/2012)

---

Can I ask why you want your results like that from a query? Are you going to be having the end users run this in SSMS or...

Take a look at this blog post. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Can I ask why you want your results like that from a query? Are you going to be having the end users run this in SSMS or at the...

Jeff Moden (7/18/2012)

---

Doh! (or should I say Bwaa ha ha!) This site certainly does some crazy things when you reply and others are posting......

Hmm... Nope. SELECT .09 % 10

Its not that it doesn't, its that you don't know when it will or won't becasue it is up to the optiizer to choose the best execution plan. I...

Thanks Jasmine. This is just for Customer Service and QA to do quick data checks, so should be good.

A constraint is a unique index.

You can do it in your create table statement: CREATE TABLE accountBalance (accountNo BIGINT PRIMARY KEY --CLUSTERED or NONCLUSTERED

, accountBalance)

You can...

Ok many thanks for all the contributions.

So. I think we are down to the following options :

1. Use Locks during the update with also a constraints rule

or

2. Have a 'Constraint...

Jasmine D. Adamson (7/18/2012)

---

GilaMonster (7/17/2012)

---

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

And to toss fuel on the fire, several of the query patterns mentioned in this thread would cause all sorts of hell when the plans are...

patrickmcginnis59 (7/18/2012)

---

gerard-593414 (7/18/2012)

---

OK thanks for that.

But I dont understand how the database Engine will prevent (without additional error checking or rules) TWO ACCOUNTS WITH THE SAME NUMBER BEING ADDED. Two...