But i found this in sql server 007 SP 00.001 :-D:-D:-D

Good one. New thing come to know.

Thank. Keep it up !!! 🙂

Easy question 😀 and lots of points.:w00t:

Hi Arju,

Sorry for reply to0 late. Please check the below link. this will help you.

http://www.sqlservercentral.com/scripts/T-SQL/97571/

I have also create different kind of scripts related to copy objects from...

Easy question, But unfortunately i selected wrong in hurry. :pinch:

Good one Ron 🙂

I think you have posted two questions on this topic earlier. If it is possible, then please post more questions on this topics with different kind of...

+1 🙂

Very good question !!! 🙂

Hi,

Sorry, but i am unable to understand question completely.:ermm:

If you increase varchar length then it will give right answer. Please try below T-sql statements

SELECT CONVERT(VARCHAR,GETDATE(),20)

SELECT CONVERT(VARCHAR,GETDATE(),21)

SELECT CONVERT(VARCHAR,GETDATE(),106)

SELECT CONVERT(VARCHAR,GETDATE(),107)

SELECT CONVERT(VARCHAR,GETDATE(),109)

SELECT CONVERT(VARCHAR,GETDATE(),113)

I think due to different behavior of truncate command, it's consider as DDL...

demonfox (3/20/2013)

---

I prefer not to have delete cascade on design .. to let the error display...

Good question.

In real life scenario, we need to take care of cascade option.

+1 🙂

:-):-):-)

kapil_kk (3/15/2013)

---

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as...