Droisys DOT NET Developer Interview Questions and Answers

Stored procedures are used to perform an action, while functions return a value.

• Stored procedures are precompiled and stored in the database, while functions are compiled at runtime.

• Functions can be used in SQL statements, while stored procedures cannot be used in SQL statements.

• Functions can be called from within stored procedures, but stored procedures cannot be called from within functions.

• Functions can have input p...read more

The == operator compares values, while the === operator compares values and types.

• The == operator performs type coercion, while the === operator does not.

• The == operator returns true if the values are equal after type coercion, while the === operator returns true only if the values and types are equal.

• For example, 1 == '1' returns true, but 1 === '1' returns false.