Ms Sql Server Technology Discussions

[Ranga_The_Donga]

Delete and truncate lo Rollback vaadachu kadaa... only Delete antaaru entii, I can do truncate rollback asloo in the SSMS.

 some one explain... Loveindia

you can do any DML statements between

 

Begin Tran

 

---

---

---

 

Rollback

 

it will rollback watever u do

[Darling999]

you can do any DML statements between

 

Begin Tran

 

---

---

---

 

Rollback

 

it will rollback watever u do

ilaa try chesteyy work ayindiii...

 

Begin Tran

 

Truncate table Test

 

Rollback Tran

 

but Truncate DML kaadu akda its DDL...Y antaav its working its rolling back the transaction changes

[Ranga_The_Donga]

 

ilaa try chesteyy work ayindiii...

 

Begin Tran

 

Truncate table Test

 

Rollback Tran

 

but Truncate DML kaadu akda its DDL...Y antaav its working its rolling back the transaction changes

 

Thats the power of ROLLBACK :)

 

na sagam testing ah syntax lone chestha :D

[mtkr]

 

ilaa try chesteyy work ayindiii...

 

Begin Tran

 

Truncate table Test

 

Rollback Tran

 

but Truncate DML kaadu akda its DDL...Y antaav its working its rolling back the transaction changes

 

 

 

i guess truncate iz lyk dropping the whole object n recreating it.... so its not manipulating the structure... but its defining the structure... 

[Darling999]

i guess truncate iz lyk dropping the whole object n recreating it.... so its not manipulating the structure... but its defining the structure... 

oka interview looo.. ee Qn ki answer chesinaa  We cant rollbacl Truncate , but delete can be done ani.. Vaduu vadinchaaduu Y cant we do can you explain it aniii.. appudu cehsaa ee test and it was working as he said.

[Yuvatha]

oka interview looo.. ee Qn ki answer chesinaa  We cant rollbacl Truncate , but delete can be done ani.. Vaduu vadinchaaduu Y cant we do can you explain it aniii.. appudu cehsaa ee test and it was working as he said.

[Yuvatha]

i guess truncate iz lyk dropping the whole object n recreating it.... so its not manipulating the structure... but its defining the structure... 

[mtkr]

oka interview looo.. ee Qn ki answer chesinaa  We cant rollbacl Truncate , but delete can be done ani.. Vaduu vadinchaaduu Y cant we do can you explain it aniii.. appudu cehsaa ee test and it was working as he said.

 

 

untaaruu.. ala saava10gevallu untaaruu....

[mtkr]

eeda galeez cheyyaku.. baitiki poi oopkoopoo...

 

i guess truncate iz lyk dropping the whole object n recreating it.... so its not manipulating the structure... but its defining the structure... 

 

 

[manjunath455]

Nenu adigina Q ki evaru answer cheyaledu

[Yuvatha]

eeda galeez cheyyaku.. baitiki poi oopkoopoo...

ok. #respect

[mtkr]

help... help...

 

 

em aina scenario undaa ba??

 

 

 

why can't we use case statement in dynamic sql statement? Evarikaina teliste pls cheppandi :3D_Smiles_38:

 

[manjunath455]

Actual ga nakoka chitra vichitramaina req. vachindi ba. Drill through feature ni cube lo implement cheyali stored procedure raasi for reporting. Makoka reporting tool separate ga vundi. Repu office ki vellinappudu clear ga post vestale ba. Hope andariki kottaga anipinchochu and help avvochu.Stored procedures kuda vunnayi

[Darling999]

help... help...


em aina scenario undaa ba??

U also in market?

[Yuvatha]

U also in market?

Yes his Fat A$$ coming soon board pettadu