SQL Server 2000 stored procedures, checking the syntax is an interesting phenomenon.

A table named TQ has the following structure:
Tq1, varchar
Tq2, varchar
In the Enterprise Manager, create a stored procedure:
Create procedure inserttq
As
Insert into TQ
(Tq1, tq2, tq3)
Values
('A', 'B', 'C ')
Go
There are no errors in the syntax of Several SQL statements,
However, if you press "Check Syntax", it will report that the column name is invalid in tq3.
And the sameCodeYou get the query analyzer and check the syntax.
The check syntax in the Enterprise Manager is not just a simple check for syntax-level errors,
Check whether this field exists in the table to prevent mistakes and field names.