SQL Query to remove whitespace character from string in SQL Server.

Description: In this example we explain that how to TRIM the string in SQL Server or how to remove the white space in string in SQL Server.SQL Query to remove the white space character from string [...]

Reverse the String in SQL Server.

Description: In this example we explain that how to Reverse the string in SQL Server or how to fetch string in reverse  order from SQL Server.SQL Query to reverse the string or fetch the string [...]

SQL function to remove non numeric characters

Description: In this example we explain that how to remove non numeric character from string in SQL Server.or fetch the string without non alphabet character or removing non numeric character from [...]

SQL function to remove non alphabet characters

Description: In this example we explain that how to remove non alphabet character from string in SQL Server.or fetch the string without non alphabet character or removing non alphabet character [...]

SQL Query to delete all stored procedures in SQL Server

Description: In this example we explain that how to delete all stored procedure in SQL Server.or remove all the stored procedure from SQL Server.SQL Query to remove all the stored procedure from [...]

Get file name from file path in SQL

Description: In this example we explain that how to Get file name from file full path in SQL Server.or hoe to fetch the file name from the SQL Server.as we know that we will store the full path [...]

SQL Query to delete all view in SQL Server

Description: In this example we explain that how to delete all views in SQL server or how to remove all View in SQL Server.below is the SQL Query to remove all the views form SQL Server. Here [...]

Check given date is weekend or not in sql

Description: In this example we explain that how to find given date is weekend or not or check inputed date is weekend or not in SQLServer.SQL Query to check given date is weekend or not. Here [...]

SQL Query to reset the Identity

Description: In this example we explain that how to reset the identity of table in SQL Server.or Reset identity seed after deleting records in SQL Server.or How to RESET identity column values in [...]

JQuery Date Picker example to disable previous dates.

Description: In this example we explain that how to disable previous dates in datepicker using jQuery.or how to disable previous date in Date picker in jQuery in asp.net.we all know that the basic [...]

Close jQuery UI Dialog Modal Popup when outside (Overlay Background) is clicked

Description: In this example we explain that how to close jQuery Dialog Modal Popup when outside is clicked or how to hide the Modal popup when click on overlay Background. How to close or hide [...]

confirmation box with yes/no button options using modalpopup in asp.net.

Description: In this example we explain that how to display jQuery UI Dialog Modal Popup with YES NO Confirm button in asp.net.here we use jQuery UI Dialog popup to display popup to user with YES,NO [...]

Show a loading gif while iframe page content loads using jQuery.

Description: In this example we explain that Display animated GIF image before iframe content is loaded .or display gif image before iframe content is not loaded. Suppose if you are working [...]