___________________repeatedly sent from the client are compiled and optimized every time they are executed by SQL Server.

Options
- Transact-SQL statements
- Stored Procedures


CORRECT ANSWER : Transact-SQL statements

Discussion Board
Transact-SQL statements

Transact-SQL statements repeatedly sent from the client each time they run are compiled and optimized every time they are executed by SQL Server. They can reduce network traffic. An operation requiring hundreds of lines of Transact-SQL code can be performed through a single statement that executes the code in a procedure, rather than by sending hundreds of lines of code over the network. They can be used as a security mechanism. Users can be granted permission to execute a stored procedure even if they do not have permission to execute the procedure's statements directly.

Prajakta Pandit 03-8-2017 05:25 AM

.NET, UI-Design ,Frontend Technologies

I want develop new website for education purpose.

Attuluri Chandrasekhar 06-24-2016 10:56 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement