[font="Verdana"]

Some More Clarifications related to Varchar And NVarchar

VARCHAR supports variable length strings, up to 8,000 characters. Best used when data length is variable, e.g. last names or product SKU codes....

I totally agree to that. For more info see

The change in execution context remains in effect until one of the following occurs:

1.Another EXECUTE AS statement is run.

2.A REVERT statement is...