Ranga_The_Donga Posted March 20, 2015 Report Share Posted March 20, 2015 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 Link to comment Share on other sites More sharing options...
Darling999 Posted March 20, 2015 Report Share Posted March 20, 2015 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 Link to comment Share on other sites More sharing options...
Ranga_The_Donga Posted March 20, 2015 Report Share Posted March 20, 2015 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 Link to comment Share on other sites More sharing options...
mtkr Posted March 20, 2015 Report Share Posted March 20, 2015 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... Link to comment Share on other sites More sharing options...
Darling999 Posted March 20, 2015 Report Share Posted March 20, 2015 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. Link to comment Share on other sites More sharing options...
Yuvatha Posted March 20, 2015 Report Share Posted March 20, 2015 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. Link to comment Share on other sites More sharing options...
Yuvatha Posted March 20, 2015 Report Share Posted March 20, 2015 i guess truncate iz lyk dropping the whole object n recreating it.... so its not manipulating the structure... but its defining the structure... Link to comment Share on other sites More sharing options...
mtkr Posted March 20, 2015 Report Share Posted March 20, 2015 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.... Link to comment Share on other sites More sharing options...
mtkr Posted March 20, 2015 Report Share Posted March 20, 2015 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... Link to comment Share on other sites More sharing options...
manjunath455 Posted March 20, 2015 Report Share Posted March 20, 2015 Nenu adigina Q ki evaru answer cheyaledu Link to comment Share on other sites More sharing options...
Yuvatha Posted March 20, 2015 Report Share Posted March 20, 2015 eeda galeez cheyyaku.. baitiki poi oopkoopoo... ok. #respect Link to comment Share on other sites More sharing options...
mtkr Posted March 20, 2015 Report Share Posted March 20, 2015 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: Link to comment Share on other sites More sharing options...
manjunath455 Posted March 20, 2015 Report Share Posted March 20, 2015 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 Link to comment Share on other sites More sharing options...
Darling999 Posted March 20, 2015 Report Share Posted March 20, 2015 help... help... em aina scenario undaa ba?? U also in market? Link to comment Share on other sites More sharing options...
Yuvatha Posted March 20, 2015 Report Share Posted March 20, 2015 U also in market? Yes his Fat A$$ coming soon board pettadu Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts