Please go thro' all replies and add this into that, delete keeps the log while truncate does not.
Type: Posts; User: CSOOR; Keyword(s):
Please go thro' all replies and add this into that, delete keeps the log while truncate does not.
Try this query in SQL server 2005
There are two ways :
1. CASE
2. Subquery
Please mention the server name.
Since the query has " Select * ", server will not able to understand which " id "column to select . So please specify all the common columns in the select statement. This will help you.
Check all...
Yes , u can
Use the content type HTML.
DBtest ,i understand, write the query and run it or create table index etc.
Question is not clear, but what i understood you want to copy into sqlserver. So just extract the data from oracle with some delimitor and BCP in into the sqlserver having tables with same layout.