Question { Wipro, 5082 }

diffrence between Cluster Index and non Cluster Index

Answer

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.

Question { 2575 }

what is package configuration variable?How to change file name
in folder dynamically?Plz help me

Answer

You can use File system task of SSIS to rename file and
folders dynamically.

Question { Wipro, 6402 }

How to Handle the exceptions in Sqlsrver 2005??

Answer

With SQL Server 2005, new error handling has been introduced
with the TRY...CATCH processing. Basically what happens is
when an error occurs the processing in the TRY block stops
and processing is then picked up in the CATCH block.

ERROR_NUMBER() Returns the number of the error
ERROR_SEVERITY() Returns the severity
ERROR_STATE() Returns the error state number
ERROR_PROCEDURE() Returns the name of the stored procedure
or trigger where the error occurred
ERROR_LINE() Returns the line number inside the routine
that caused the error
ERROR_MESSAGE() Returns the complete text of the error
message. The text includes the values supplied for any
substitutable parameters, such as lengths, object names, or
times

Question { 5108 }

how do u find least salary in a table

Answer

SELECT MIN(SALARY) from EMPSAL

OR

SELECT MAX(SALARY) FROM
(SELECT DISTINCT TOP 1 SALARY
FROM EMPSAL ORDER BY SALARY) AS A;