How to export data from database and import into another?

989

How to put more than 1000 values into an oracle in clause?

1104

Why and when do stored procedure recompile?

1052

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Where can you add custom error messages to sql server?

1197

Can we shrink data file in sql server?

1123

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

what is the difference between openrowset and openquery?

1186

How can we solve concurrency problems?

1116

How to convert numeric expression data types using the cast() function?

1142

Disadvantages of the indexes?

1217

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

What are the advantages of database?

1009

What is a coalesce function?

1275

Have you written applications to retrieve stored images in a table?

1083