|
|
Browse by Tags
All Tags » ASP.NET 2.0 - G... » Databases & SQL
-
Another tip from the great book by David Sceppa is how to handle null column values:
Suppose you have a column in your table in the Database, and that column can have NULL values, the column is named ColA. Now you wanted to updated a record by checking if ColA is NULL in the WHERE clause to allow updating:
UPDATE ..... WHERE ColA = ?
The ...
-
I have always misunderstood the difference between NULL and DBNULL until recently while I was working on ASP.NET web application, and was talking to a Webservice and I found an exception coming from one of the web methods inside the Webservice which is using the SqlCommand.ExecuteScalar() method.
What happens when the ExecuteScalar() method is ...
-
I am working on a Custom DotNetNuke module. I wanted to have a DropDownList of all the countries in the world.
I had to google a little bit to find all the countries available, which I beleive are 222 countries.
I wanted to share with you the SQL Script I created.
You can download this script from the Files Area.
When you run this script using ...
|
|
|