ASP.NET Blogs | CodeAsp.Net

Difference Between COALESCE() AND ISNULL()

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()

COALESCE ISNULL Sql
Vijendra Shakya

7/19/2009
0
/5

0 (0votes)

0

11429
What is SQLCommand Objects in ADO.NET

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=”Selec...

ado.net c# ExecuteNonQuery ExecuteReader ExecuteScalar Sql SQLCommand
Vijendra Shakya

7/12/2009
0
/5

0 (0votes)

2

9119
How To Rename ColumnName in SQL

Many times there is needed to change the column name of table.

ColumnName Rename Sp_Rename Sql
Vijendra Shakya

7/2/2009
0
/5

0 (0votes)

0

4719
Find Nth highest salary in SQL

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 followi...

2nd 3rd asp.net c# Count Highest Min MSSQL Nth ORACLE query Sql
Vijendra Shakya

6/27/2009
4.88
/5

4.88 (2votes)

5

38448
Count Number of Tables/Columns in Database

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.

asp.net c# column Count query Scema SELECT Sql table
Vijendra Shakya

6/27/2009
0
/5

0 (0votes)

1

11360
Use of Count Function in SQL

In SQL Count() function returns number of Rows in a certain table. Count() is an aggerate function(aggerate function returns a single value).

Count Sql
Vijendra Shakya

6/16/2009
0
/5

0 (0votes)

0

9549

Page 1 of 1 (6 items)

ASP.NET Blogs | CodeAsp.Net

Blogs

Difference Between COALESCE() AND ISNULL()

What is SQLCommand Objects in ADO.NET

How To Rename ColumnName in SQL

Find Nth highest salary in SQL

Count Number of Tables/Columns in Database

Use of Count Function in SQL

Filter Blogs

Blog Archives

ASP.NET Blogs | CodeAsp.Net

Blogs

Difference Between COALESCE() AND ISNULL()

What is SQLCommand Objects in ADO.NET

How To Rename ColumnName in SQL

Find Nth highest salary in SQL

Count Number of Tables/Columns in Database

Use of Count Function in SQL

Filter Blogs

Blog Archives

Loading ...