I am not sure about Oracle,
In sql server, you can set some properties common to the database by setting the 'language' options, the fearures by changing the language will include
1. currency
2. date format
etc
aneeshattingal
Last Activity: Oct 18 '06, 05:15 AM
Joined: Jul 3 '06
Location: Bangalore
-
You can use the SQL server's Upgrade wizard to upgrade your current SQL server 2000 DB to 2005.
You should notice the new features of SQL server 2005, the 'text' columns can be moved to 'varchar(Max)' , also you should go thru the new error handling features of sql server 2005.
the system tables in 2005 and 2000 are different , so you need to modify your queries in 2000 which refers the system tablesLeave a comment:
-
can you post the sample query
Roll back can happen
1. if you put your statements inside a 'BEGIN TRAN ...ROLLBACK TRAN ' statements
2. if you stop the running Query before it completesLeave a comment:
-
You can set a case sensitive Collation during the installation
The Cse sensitive collations will have an '_CS_' structureLeave a comment:
-
Replace
( left(intEncashm entID,2) like 'TR%' with
LEFT(intEncashm entID,2) = 'TR'
also make sure that there is an index on that columnLeave a comment:
-
If you are looking for a free version of sql server, then you can downnload the MSDE and try it..Leave a comment:
-
read the following article
http://www.sqlserverce ntral.com/columnists/awarren/copyingdtspacka gestoadifferent server.aspLeave a comment:
-
Not at allLeave a comment:
No activity results to display
Leave a comment: