In SQL many times we have null values and we wants return another value, for that purpose in SQL there is two methods: 1. COALESCE() 2. ISNULL()
In ASP.NET to execute the SQL Query or Storeprocedure, we use the SqlCommand object. We use the SqlCommand object as follows: // create the SqlCommand object String sqlQuery=”Select * from User”; SqlC...
Many times there is needed to change the column name of table.
Here I will discuss how to find nth highest salary. Consider we have a User table the column name of the user table are UserName, Salary, City ,Suppose inthis table we have following data
Many time s we want to know How many Tables we used in our Database. Here I have write the query to find the total number of tables/columns used in Database.
In SQL Count() function returns number of Rows in a certain table. Count() is an aggerate function(aggerate function returns a single value).