I need a review on SQL Server format.

archie flockhart (3/13/2013)

---

I was confused by people saying how rare it was to find matching values. When I tested the original code, I found that it was not infrequent at...

I often use sp_help to get db object info,...

+2 😎

I agree. So what I learned from this question...

This was a tough one for me. I didn't know the default cut off year. thanks.

L' Eomot Inversé (3/8/2013)

---

Primo Dang (3/8/2013)

---

It...

You're right. Look like a lot of people have fun figure out this one. The question did more good...

demonfox (3/7/2013)

---

actually, It's...

demonfox (3/6/2013)

---

did I miss something ???

or there are more than 2 failures ...

select db_id('dbdb')

-- and the second one

select object_id('dbdb')

I don't think it will return the same value for a database.

I...

Abu Dina (2/14/2013)

---

I do FULL backups every two weeks and daily differentials on a number of SQL instances.

The backup command I use for the differential backups in my sproc is...

anthony.green (2/14/2013)

---

You dont have an INIT and FORMAT so it is appending the diff backup to the media set not overwriting it, so it contains all 13 days diff backups.

Highly...

haha. this not really about IsNumeric(). these type of questions are fun to solve. 😀

I had to do some research for this one. good question.

thanks for the question.

This is a fun question. Of course, the code will fail the syntax validation if executed all at once. Two proc call each other, eventually SQL Server will freak out....