Easy Interview

1. Anatomy of HTML 5 document?        <!DOCTYPE html>        <html>        <head>        <meta charset= "UTF-8">        <title> title of page</title>        </head>        <body>                <! -- body of the page(List of elements we can use for our document) -->         </body>        </html> 2. Anatomy of HTML 5 Element?      An HTML 5 element contains three important parts            1. Opening Tag            2. Content            3. Closing Tag  For understand, for example,                  ...

1. What is the use of SET NOCOUNT ON ?          SET NOCOUNT ON is used to stops the message that shows the count of the number of rows affected by a Transact-SQL Statement or Stored Procedure from being returned as part of the result set. When SET NOCOUNT is ON, the count is not returned.  When SET NOCOUNT is OFF, the count is returned. setting SET NOCOUNT to ON can provide a significant performance boost because network traffic is greatly reduced. 2. What is RAISEERROR?  And Uses of RAISEERROR?           It is used to return messages back to the application using the same format as a system error or warning message generated by the SQL Server Database Engine. Uses of RAISEERROR Check the values of data Return messages that contain variable text Cause exception to jump from a TRY block to the associated CATCH block Return error information from the CATCH block to the calling batch or...