Important Question

differenct b/w the subquery and join

why we use stored proc

filter index

staging server

Bcp-Bulk copy program (
links

http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
http://msdn.microsoft.com/en-us/library/aa196743(v=sql.80).aspx
http://www.dotnetcurry.com/ShowArticle.aspx?ID=323
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
)




**************************


Inside the function we can't handle the
exception and can't use the transactions.

by using the select statement we can use the function.

Inside the function we can't write the insert or update command.

Inside the function we can't call the stored Procedure.

Inside the Procedure the exception handling and transaction .
Procedure.