Customize Your Desktop - ObjectDock

Looking for a quick/fun way to add your shortcuts on your desktop, ObjectDock is a great choice.

You can download the ObjectDock from the website http://www.stardock.com/products/ObjectDock/.

Even the free version can save you a lot of time and making your desktop looks nice.

SQL - Insert Multiple Records into one tables at one time

How are you going to insert multiple records into a table at one time?

Here is the code you can do that:

Insert into Table
(Column1, Column2, Column3)

select Value01, Value02, Value03
Union ALL

select Value11, Value12, Value13
Union ALL

select Value21, Value22, Value23

It works and save time by avoiding multiple insert scripts.

Coordinate coversion

If you have some knowledge about geography, you my be familiar with different projection system. The projection system will display earth surface on the flat paper. Sometimes you may need to convert coordinates into different projection system. You can do this with GIS software. But you want to do it online, there is website for this task.

It is:

Earth Point

I found the coordinates conversion features very useful.

Envelope-free to deposit checks in ATM

Wachovia Bank now can deposit your check without envelopes. You do not have to even put the amount y0u are going to deposit. The ATM machine can read and scan checks and automatically know how much money that will be. You can deposit multiple checks at one time. It is very convenient. Then if you want a receipt, you did have a choice to get a receipt with scanned check images.

Not sure if the ATM machines in other banks have the same kind of features, I do find this new feature is very useful to customers.

Link to Wachovia bank

GIS Map templates

Would like to create a professional map, or create a map like ESRI sample map viewer, please go to the webpage to download the sample map documents.

http://resources.esri.com/maptemplates/index.cfm?fa=codeGallery

All you need to do is to change the data source and/or the coordinate system (projection).

calling a stored procedure from asp.net

If you would like to use the asp.net code to call a stored procedure from SQL, the following article will show you how to do it step-by-step.

http://www.macronimous.com/resources/calling_stored_procedures_from_ASP.NET_and_VB.NET.asp

SQL insert,

If you like to insert value in SQL table based on a selected data set from another table, you can use the following syntax:

Insert into table1 (Col1, Col2, col3)
select Col1, Col2, col3 from table2 where Col1 > 'abcde'