是否对所有StoredProcedures都进行了编译? [英] Do all StoredProcedures are percompiled?

问题描述

I faced this question in an interview and i wanted to know that, is there any exception in which the stored procedure would be in non compiled state.

推荐答案

亲爱的朋友，请尽力而为.

在Google上搜索，它将为您提供大约157,000个结果(0.44秒)

是所有程序均已预编译.

但是您应该尝试一下:

Dear Friend Please try to do your efforts.

Search on google it will give you About 157,000 results (0.44 seconds)

Yes All procedures are Precompiled.

But you should Try This:

Your answer is here

是的....所有StoredProcedures都将被编译.

YES....all StoredProcedures are percompiled.

将精力放在基本问题上可能会提高您的技能.不要从找到一个简单的答案，而不是问别人.您可能已经尝试过 ^ ].

在此处查看前3个链接:
SQL Server存储过程概述 [ SQL Server中的存储过程 [ SQL存储过程 [此处 [

Putting your effort in the basic questions may increase your skills. Don''t run from finding a simple answer rather than asking to others. You could have tried google[^] for it.

Check top 3 links here:
Overview of SQL Server Stored Procedure[^]
Stored Procedure in sql server[^]
SQL Stored Procedures[^]

Check a basic pdf here[^].


All the best.
--Amit

这篇关于是否对所有StoredProcedures都进行了编译?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！