david.alcock (1/12/2011)

---

Okay, I've just had a look..apologies for the lame naming!

CREATE SCHEMA dba

CREATE ROLE schema_test

GRANT EXECUTE ON SCHEMA::dba TO schema_test

CREATE PROCEDURE dba.Test_Schema

AS SELECT * FROM dbo.MyTestTable

When I view the permissions...

Agreed. Fortunately I still...

Thank you, Mr. Coffee.

Solomon Rutzky (12/31/2010)

---

Hello Gianluca. First, thanks for your answer about how to update the state of the DB via a CLR Function.

Now, I do have a MySQL instance to...

Happy New Year to all the threadizens!

See you next year!

magarity kerns (12/30/2010)

---

Excellent article - For more fun, check other DBMSes. I checked on Oracle and "select 'A' from dual where 1=0 or 1/0 = 1;" gives a division by...

Thank you, Jason.

sknox (12/30/2010)

---

Gianluca Sartori (12/30/2010)

---

When first name is null and middle name is not null, the second part of the or...

magarity kerns (12/30/2010)

---

Check this out: My friendly local Oracle DBA told me Oracle is backwards!

select 'A' from dual where 1/0 = 1 AND 1=0;

(at least on Oracle 10g) will give...

Solomon Rutzky (12/30/2010)

---

Hello Gianluca. Thanks for a great and thorough article :).

This is slightly off topic, but...

Daniel Ruehle (12/30/2010)

---

Agree, but if the query plan says its going to scan the table, then it does come down to how long does it take to process each row....

magarity kerns (12/30/2010)

---

Excellent article - For more fun, check other DBMSes. I checked on Oracle and "select 'A' from dual where 1=0 or 1/0 = 1;" gives a division by...

Thanks, Lutz.

When first name is null and middle name is not null, the second part of the or expression does not...

Daniel Ruehle (12/30/2010)

---

One easy way to make sure short circuiting works the way you want it is using case statements:

select

*

from

Person

where

1 = 1

and...