NIHAR'S BLOG

How to use   : I will be writing about things I like from time to time. That is SQL Server things - other than beer, good books and company. For today, one small thing but how useful. In SQL Server Management Studio 2008 you can script objects as DROP and CREATE in one go: Why to use :     This is very useful for us, as we store all database objects in our SVN as DROP..CREATE scripts. Using this feature saves quite a bit of time each time we want to update the source control. I noticed an interesting behavior - if you script your table this way, all constraints defined in the table are scripted with drop statements before the actual DROP TABLE statement is included. This is quite handy as you can easily modify this script to change constraint names or definitions without having to script them separately. 

Basic steps   “ How to debug the code “ Steps : 1)       Put the breakpoint (Click on left-hand side of window ) Yellow colored line shows you are Compiling following line.Red Symbol showing your debugging started from that line  [Note : You can’t put breakpoint to GUI or presentation like .aspx file. Only in *.aspx.cs,*.cs etc   and you can’t put breakpoint for NAMESPACES ] 1)       For Debugging you have some Important   shortcut keys like F10 -   Start debugging F11 – Go inside to the   Particular method when that yellow color available on that line 2)       When you   move your curser through objects,variables , methods etc its show description of that . 3)       When you start debugging again and again then , no need to stop process .Only just right click from where you   want to start debugging and click “SET NEXT STATEMENT” That blue-mark …...