quote:

---

Regarding your last comment, I can't really place a default in a VARCHAR, because say the user leaves it blank on the...

quote:

---

Frank - I'd say an honest 4-6 weeks. Incredbile that in 2003 anything can take that long, but I sent several books...

Hi Sarat,

a short explaination why you need to wrap it in a view:

GETDATE() is nondeterministic, meaning same input different output.

SQL Server can handle only deterministic stuff in a function.

Check BOL...

...there is also sp_depends

Frank

http://www.insidesql.de

quote:

---

In SQL 6.5, the upgrade changes the -- by removing it. This allows that command to execute in the stored procedure.

All...

If you have your logfile you should be able to restore it by using RESTORE LOG.

Check BOL for complete syntax or take a look at logs-> applying backup when...

Hi Lenard,

quote:

---

You are correct....but what if both @areaDesignatorID and AreaDesignatorID are NULLs? The statement won't evaluate to TRUE. That is my...

Hi Rahul,

quote:

---

One of our user accidentally deleted all the tables. Please tell us as how to restore those tables. I have last...

quote:

---

Also be careful using -- to comment.

---

any issues with that?

Frank

http://www.insidesql.de

I might reiterate myself, but to me QOD is (educational) fun!

And IMHO the intention should not be to answer all questions straight out of the head.

Nobody knows everything in...

quote:

---

You mean use Char or Varchar? But that will loose the benefit of datetime data type when it comes to date calculations,...

Hi,

I guess unless you haven't a backup or a copy from that time you're pretty much out of luck

Frank

http://www.insidesql.de

Hi Matthieu,

quote:

---

I'm seeking some code or piece of code (or idea ?) to convert this sentence in :

---

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]