SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the command. Even though the SQL value is a string, SQL Server executes ...

I was under the impression that varchar2(1000) in Oracle would only allocate space for the 2 chararcters and was wondering if varchar in SQL Server is handled the same way.

I'm working with a <B>very</B> large DB in MS SQL 2000. All char fields are defined ... However, each and every reference I have seen insists that using varchar fields for Kanji could result ...