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 in SQL Server. fetch string with trimming the white space character form string in SQL Server.

Here we use TRIM() function of the SQL Server to remove the whitespace character.here we use LTRIM() and RTRIM() function of the SQL Server to remove left side and right side whitespace 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 in reverse order from SQL Server.

Here we use REVERSE() function of the SQL Server it was introduced in SQL Server 2008.REVERSE() function will returns the string in reverse order of inputted by user.if you pass the non alphabet character(Integer) value then it will first convert it into string and then it will return in reverse order.

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 string using SQL Server function.

Here we create one SQL Server user defined function that will return string or text with removing non numeric character in SQL Server.here we simply input the value to SQL Server function and it will returns the string or value with removing non numeric character.

So below is the SQL Server user defined function that will remove non numeric characters from the given input value.

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 from string using SQL Server function.

Here we create one SQL Server user defined function that will return string or text with removing non alphabet character in SQL Server.here we simply input the value to SQL Server function and it will returns the string or value with removing non alphabet character.

So below is the SQL Server user defined function that will remove non alphabet characters from the given input value.

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 SQL Server.below is the SQL Query to remove or delete or drop the all the stored procedure in SQL Server.

Here we use cursor to fetch the stored procedure one by one from SQL Server and remove from the list.

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 of the file in SQL Server so how can I fetch the only file name from the SQL Server.below is the SQL Query that will fetch the file name from the full path in SQL Server.

The below query return the file name like “Customer.xlxs”

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 we use the Cursor to loop each view one by one and drop or delete this view from SQL Server.

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 we demonstrate to check the date is weekend or not in SQL Server.some time in our application we must have scenario in which we have to disable the date or give proper message to user that given date or inputted date is weekend so please enter the another date.

Sometime also we have to find the report or generate report based on the weekend or any attendance report with weekend calculation at that time this below SQL query is very useful for us.

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 SQL Server. As we know that when we truncate the data ,table identity will be reset automatically but when we delete the records from the tables the identity will not be reset automatically so to reset identity of the column after perform delete operation in table in SQL Server below is the SQL Query to automatically reset the identity of the column.

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 requirement is that always disable the previous date in our web appliacation or disable minDate in date picker using jQuery in asp.net.

Here we use minDate property of the jQuery Date picker to  disable the previous date of the calender.

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 modal popup in jQuery when click is perform outside the Modal popup. Here the background is in overlay mode or in invisible mode so when click on any part of the body the modal popup will be automatically close or hide regardless of the click on the close button.

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 and confirm popup to perform the Delete operation in asp.net.

Here we demonstrate jQuery UI Dialog Popup example with yes no and confirm button in asp.net to perform the any operation with confirmation by user.

Here we have a button and if click on delete button then popup will asked user for the confirmation with YES NO option and perform the operation as per option click by user.

Generally we used that types of dialog box in any delete operation.

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 with iframe then iframe content take time to load,so if you may want to display a simple gif loading image that indicate the end user that loading process is working so wait for some time.