With SQL Server, parameters and variables in T-SQL start with the "%" sign.

More Questions from SQL Server 2000

• SQL Server AFTER Triggers may be assigned views.
• SERIALIZABLE is the strictest isolation level.
• SQL Server automatically creates an index on all primary and foreign keys.
• SQL Server supports three recovery modes: simple, full and Bulk.
• Nonclustered indexes are faster than clustered indexes for retrieval.
• SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
• SQL Server supports a language called Transact-SQL (also called T-SQL).
• With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
• Better security occurs if Windows-only authentication is selected.
• SQL Server indexes are special data structures used to improve performance.

Discussion & Comments