No Image

Sql Server Truncate VS Delete Statement

Truncate and Delete statement used for same purpose. I.e. it’s for removing data but there are some different between both commands. TRUNCATE The TRUNCATE Statement delete all rows from a table by deallocating data pages…



No Image

jQuery: Disabled Right Click

Hello All, It’s pretty simple to disabled right click using jQuery. Just add below code in <head> section. <script type=”text/javascript” language=”javascript”> jQuery(function(){ jQuery(this).bind(“contextmenu”, function(e){ e.preventDefault(); }) }); </script> Enjoy Coding…



No Image

Read and Write excel sheet in SQL Server

Recently, one of the projects needs to insert mass data into SQL server database. Data present in excel sheet with large number of row. There is a way to insert data into database through any…


No Image

Disable past date in jquery datepicker

jQuery UI is open source. jQuery UI provides very useful widget for developing web application. Like Date Picker, Slider, Accordion, Dialog and many more. It’s very easy to play jQuery UI widget. See here put…


No Image

SQL Server: Get table list from column name

Every business application must have database and it becomes very huge and complex day by day and difficult to remember everything. I.e. which table has which fields? Sometimes needs to find out all table lists…



No Image

SQL Server Rank() v/s Dense_rank()

Yesterday night I was searching about SQL Server system functions and got a nice puzzle of SQL Server. The puzzle likes to find out second highest salary of each department and tie salary should also count. Finally…