Machine-translated by Google. Questions are authored in English.
Top

Discussion

Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

  • A.#
  • B.%
  • C.&
  • D.

    @

Answer: D

Correct answer: @

A single at sign marks a local variable or a stored procedure parameter, and two mark a system global. The convention is part of the Transact-SQL syntax rather than a naming habit, so the sign is obligatory - a declaration without it will not compile.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.