It has been seen that sometime IIS will stop to work on unexpected reason, in this situation we...
SQL Server
How to restart IIS using schedule tasks step by step
How to create MERGE statement with variable in SQL Server
In SQL Server 2008, you can perform insert, update, or delete operations in a single statement...
Best way to find table wise rows and size in sql
This is a simple stored procedure which you can search through all the data (table wise rows and...
Store Procedure with the TRY… CATCH Block
The procedure, UpdateSales, modifies the value in the SalesLastYear column in the LastYearSales...
Search string in whole table (all row/column) in SQL Server
Hello Everyone. In this post, we want to discuss about a nice function to search string in whole...
SQL: Get information on all of the tables
After some searching, I could not find an easy way to get information on all of the tables. There...
Using Cursor in SQL
Hello Reader. In this post, we want to discuss about a nice function for using Cursor in SQL Server...
Counting sql rows, adding value of every row to the next
Hello Everyone! In this article, we want to discuss about a nice function of adding value of every...
Enable, Disable Login, Change name of the ‘SA’
In SQL SERVER 2005, all the login (including ‘sa’ ) can be enabled and disabled using ALTER LOGIN...
How to format a Datetime value in SQL Server
In this post, we want to discuss about efficient way to convert datetime format in SQL Server...
Interview QA
Android Interview Questions & Answers 1
1) What is Android? It is an open-sourced operating system that is used primarily on mobile...
Android Tutorials
Variables and Data Types in Java
In short Variable is name of reserved area allocated in memory. In other words, it is a name of...
