What is difference between Delete and Truncate Truncate and Delete both will be used to delete data from a table.Both the SQL statements are used to delete only the data from table but both are differ from each other in many area like syntax, performance, resource uses. Truncate The TRUNCATE command in SQL removes all rows from a […]
Categories
How to Create WordPress Shortcodes
How to Create WordPress Shortcodes In WordPress shortcode is one of the greatest feature that enable you to perform functions inside in a wordpress posts. WordPress shortcodes allow customizing of the layout and inserting certain formatting snippets in your post so quickly. INTRODUCTION:- The basic purpose of using a shortcode is to replace the placeholder […]
To get running processes list on your computer, you can use Windows Instrumentation command-line interface (WMIC) . This tips applies for Windows XP Professional, Windows Vista, Windows Server 2003 and Windows Server 2008, Window 7, Window vista. Open command prompt (window+R) and type CMD and press enter. Otherwise Go to Start > All Programs > Accessories […]
Triggers:- Trigger is a special kind of stored procedure they executes themselves when an INSERT, UPDATE, or DELETE statement modifies the data in table. A trigger can query other tables as well and we can create complex Transact-SQL statements. We often create triggers to enforce referential integrity or consistency among logically related data in tables.You […]