Object permissions are stored in system tables in each database, so it isn't really possible for the permissions to be different, because they are restored along with the rest of...

Well, it is up to them to make the decision. Just tell them your opinion, give them the facts, and let them make it.

If it all goes wrong, they...

Fraggle-805517 (9/30/2009)

---

Mark Marinovic (9/30/2009)

---

For...

Fraggle-805517 (9/30/2009)

---

Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database without disturbing the...

Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database without disturbing the old...

The problems that I see with generalizations is that they tend to conform to the opinions and prejudices of the author, and are rarely backed up by meaningful data.

Even if...

If you post 5 or 6 number/datetime pairs, there is a good chance someone could figure it out. Numbers over a large range of time would be best.

It's hard to speculate what is wrong with code you didn't post.

Maybe it has nothing to do with dynamic SQL. Maybe the query is just not returning any rows.

When you divide 1 by 2 (1/2) you are doing integer math, so the remainder is dropped. Cast the values to numeric first if you want numeric results.

Example:

select A...

321 MySQL (9/29/2009)

---

GSquared (9/28/2009)

---

Tobie-189314 (9/28/2009)

---

Forgive me for being simple... LOL! Had to read the question a couple of times, but, isn't it easier just to do the following? Or did...

You could also have it do almost nothing.

declare @a int , @b int, @c int

select @a=0,@b=0

if @a=0 and @b=0

set @c=@c

else

select * from table1 where id=@id

If you come to SSC or other site just looking for a quick answer and are not prepared to test them yourself, you are setting yourself up for trouble.

It’s no...

The idea of providing enhanced access to the competent is good in theory, but in the real world, the access gets provided to technically incompetent people who are just good...

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

Ankur Bajaj (9/24/2009)

...

If having the facility to install Oracle server on windows OS does not limit its utility or performance then what is the reason Microsoft does not allow(or have...