World All country City,state list database,dropdown excel csv

I guess a lot of people search for this list and very less get successful finding the list. I also required world's all Country and corresponding City or states for binding the drop down from sql server one of my project. i searched a lot and finally found a very good list, with the approved codes etc. you can use Ajax or anything after importing it to your database in required format in you any of oracle, mysql, access, sql-server, postgresql.
here's Updated link.

http://www.unece.org/cefact/codesfortrade/codes_index.html

above link is for download, below link is for details of various terminologies used.

http://www.unece.org/cefact/locode/welcome.html

on the page you will get list in various acceptable formats from

• txt
• CSV
• excel
• mdb. 

as there is no just download latest file which is on the top of the list and import it to your database.
its very detailed and informative list even got longitude details, district, state, city. so you can drill down to very depth or very less according to your requirements

my best to share the information as far as possible.

Please like this article on Facebook and G+ to make people to find it easily.

Migration / Conversion from Oracle to Sql server

As .net developer sometimes we need to work on heterogenous databases. like Oracle, MS Sql 2005/2008, posgresql, mysql etc. This document is only about Migration from Oracle to Sql server and vice-versa. Both databases come with features those are vendor specific .
Oracle’s stored procedure language, PL/SQL, has many features not supported in Transact-SQL (T-SQL), the stored procedure language of SQL Server, and even where similar features exist, the languages contain many syntactic and semantic differences. To migrate a PL/SQL object that uses a feature that has no T-SQL counterpart requires that that capability be emulated in T-SQL using the available features.

Stored procedures/Functions.
Cursor
Triggers
Data types
loops
conditions
Joins.
Null Handling
Temporary Tables

all have diffrent syntax in both databases.rather than copying i am providing some good links for migration.
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

http://download.microsoft.com/download/3/d/b/3db5c89a-3765-4bae-8647-ec878989054f/SSMA_for_Oracle.doc

http://www.scribd.com/doc/18501463/SQL-2-Oracle?secret_password=kxh3g29hzidy86usbne

if still any doubt or problem just comment and tell me, i will try to resolve that.

clustered vs non-clustered Index sql server

Question: difference between clustered and non-clustered Indexing,

following are some compiled differences list. May be useful for you.
if useful & more info to add please comment if anything wrong please criticize

1. Only one clustered and 249 nonclustered indexes.

2. Clustered index can be on primary key and other.

3. If you don’t want to create clustered index on primary specify it.

4. SQL Server determines whether to use an index by examining only the first column defined in the index. For example, if you defined an index on FirstName, LastName and a query is looking for LastName, this index would not be used to satisfy the query.

clustered vs non-clustered Index sql server

Question: difference between clustered and non-clustered Indexing,

following are some compiled differences list. May be useful for you.
if useful & more info to add please comment if anything wrong please criticize

1. Only one clustered and 249 nonclustered indexes.

2. Clustered index can be on primary key and other.

3. If you don’t want to create clustered index on primary specify it.

4. SQL Server determines whether to use an index by examining only the first column defined in the index. For example, if you defined an index on FirstName, LastName and a query is looking for LastName, this index would not be used to satisfy the query.