A stored procedure is a set of Structured Query Language (SQL) statements that you assign a name to and store in a database in compiled form so that you can share it between a number of programs.
• They allow modular programming.
• They allow faster execution.
• They can reduce network traffic.
• They can be used as a security mechanism.

Yes, Let us consider there is employ Table ( empid, empName, empManagerid). In this table manager is also be an employ.

Only one value can be returned from method, however you can use ref or out variable to change more than one value in called method.

A try statement have zero or more catch statement, There is no limit to the number of catch statement.

The primary difference is that a structure is value data type and class is the reference data type.

Structure don't have default constructur or destructors.

In Structure all variable and method is public where as in class it is private by default.

Structure does not have inherit

It define a set of feature that all .net compatible languages should support.

Single line, multiple line and document line.

Single line start form anywhere on a line with two forward slashs (//).

Multiple comment start with forward slash followed by an asterisk (/*) and end with asterisk followed by slash .

Document comment start with three forward slashes(///).

Difference Between DELETE & TRUNCATE Are

1. DELETE  is a DML Command & TRUNCATE is a DDL Command

2. After DELETE  can rollback the Records & After TRUNATE cannot rollback the records

3. In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions

4. After using DELETE Command The memory will be occupied till the user does not give ROLLBACK or COMMIT & After using TRUNCATE Command The memory realeased immediately

foreach ( objectcontrol in form1)
{ 
   if ( typeof Objectcontrol is TextBox)
   {

      Objectcontrol.text = "";

   }
   elseif ( typeof objectcontrol is checkbox)
   {

      objectcontorl.checked = false;
   }

}

LEFT OUTER JOIN - This returns all the matching rows and the unmatched rows of the left table of the SQL code.

RIGHT OUTER JOIN - This returns all the matching rows and the unmatched rows of the right table of the SQL.

FULL OUTER JOIN - This returns all the matching and unmatched rows from both the tables.