Ranga_The_Donga Posted March 20, 2015 Report 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
Darling999 Posted March 20, 2015 Report 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
Ranga_The_Donga Posted March 20, 2015 Report 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
mtkr Posted March 20, 2015 Report 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...
Darling999 Posted March 20, 2015 Report 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.
Yuvatha Posted March 20, 2015 Report 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.
Yuvatha Posted March 20, 2015 Report 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...
mtkr Posted March 20, 2015 Report 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....
mtkr Posted March 20, 2015 Report 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...
manjunath455 Posted March 20, 2015 Report Posted March 20, 2015 Nenu adigina Q ki evaru answer cheyaledu
Yuvatha Posted March 20, 2015 Report Posted March 20, 2015 eeda galeez cheyyaku.. baitiki poi oopkoopoo... ok. #respect
mtkr Posted March 20, 2015 Report 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:
manjunath455 Posted March 20, 2015 Report 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
Darling999 Posted March 20, 2015 Report Posted March 20, 2015 help... help... em aina scenario undaa ba?? U also in market?
Yuvatha Posted March 20, 2015 Report Posted March 20, 2015 U also in market? Yes his Fat A$$ coming soon board pettadu
Recommended Posts