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

Discussion

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

  • A.COBOL.
  • B.VB.NET.
  • C.TRANSACT SQL.
  • D.Visual Basic.

Answer: C

Correct answer: TRANSACT SQL.

Transact-SQL adds procedural constructs - variables, parameters, conditionals, loops, error handling - to standard SQL, so that logic can be written and executed inside the database. It is what stored procedures, triggers and functions are written in, and it is the SQL Server counterpart of Oracle’s PL/SQL.

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

Post your comment

Please log in or register to post a comment.