mollari_uk (11/22/2007)

---

Why do these two behave differently? I don't know, but T-SQL is providing you the two ways you can use as needed. In the case where you want all...

Mark Fyffe (11/22/2007)

---

Excellent explanations especially the logging behaviour of both commands. I was hoping I would have saw some details on the behaviour of these commands on temporary tables....

Jai Kumar (11/22/2007)

---

Good one. Before reading this article I my idea was that there is no logging for TRUNCATE tables.

Thanks.

One question from my side

Is this article is applicable for both...

Hi,

I tried the same querry in the SQL 2000 Server, but its not working, i d't know why???

its giving me teh folloeing error;

Server: Msg 170, Level 15, State 1, Line...

Hi,

Now i got the link, i think it is the problem of that underscore but how that is there i d'y know caz i have'nt added it there its comming...

Hi murrayb3024 ,

Please post the scenario by specifying table name and column then wht is desired output u want???

liek below,

Table test1

Id Name

1 Hello

2 Hi

Table Test2

Id Class

1 12

2...

Hi Jeff,

Can u please gice me the columnnames wht u want, like in the output u want ItemID froim which table u want this itemid caz u have itemid field...

Hi Marcus Farrugia,

I think u need to do some modification in the where claues otherwise i d't think it is possible to get the NUll and also the record of...

Hi Aaron Ingold ,

That is ok that we can use ISNULL to solve this problem BUT How we can make use of COLESAC function here to solve this problem???

Can u...