Question { Wipro, 7091 }

About DTS usage ?

Answer

DTS Used for various data transformations.

Not only between databases, its also used to transfers
data's between office excel,CSV, text files, MDB also.
Extracting data's from databases to Excel, mdb, csv, text
files.

We can extract the data's using Queries also(if its from
database).

Question { HCL, 4977 }

when my application exe is running nad i don't want to
create another exe what should i do

Answer

In form load even we write the code to check the previous
instance running or not. If previous instance exists show
the message and exit the form.

Use System.Diagnostics namespace for find the running
previous instance.

Question { 4764 }

what is meant by deafult in sql server?

Answer

Default is the column value used in the sql.

if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.

For example varchar columns are defined as null value for
default value.

Question { CA, 24257 }

What are main difference between Stored Procedure and
Functions.

Answer

The Main difference between stored procedure and Function
is SP's can return the value or not, but Functions should
return the value.

And We can use the function within the Queries, but sp's we
won't able to use it in the queries.

We can implicitely execute the sp's. But function's we
can't.