sql server faq link
Related Posts:
TRY…CATCH and ERROR Handling-Sql Server 2005Syntax:BEGIN TRY{ sql_statement |statement_block }END TRYBEGIN CATCH{ sql_statement |statement_block }END CATCHThe TRY or CATCH block can contain a… Read More
What are difference between Cluster index and Non-Cluster index?Both of these indexes uses "B-tree" structure but in Cluster index the "Leaf Node" actually points the physical data, but in Non-Cluster index it poin… Read More
What is Cross Join and in which scenario do we use Cross Join?CROSS JOIN: Cross join is used to return all records where each row from first table is combined with each row in second table. Cross join is also c… Read More
Table VariablesQ1: Why were table variables introduced when temporary tables were already available?A1: Table variables have the following advantages over temporary … Read More
How does index makes search faster?For better understanding, let us consider a simple search example which shows differences between a table, declared with index and without index.Let's… Read More
0 comments:
Post a Comment