在SQL中需要帮助 [英] need help in sql

问题描述

大家好

带示例的prepare语句和非prepared语句有什么区别?
它如何影响性能??


在此先感谢

Hi all

What is the difference between prepare statement and non-prepared statement with example?
how it is effecting to the performance???


Thanks in advance

推荐答案

请参阅:

http://objectmix.com/jdbc-java/41014-difference- between-statement-preparedstatement-sql-databases.html [ ^ ]

Refer this:

http://objectmix.com/jdbc-java/41014-difference-between-statement-preparedstatement-sql-databases.html[^]

看看:
http://msdn.microsoft.com/en-us/library/aa905910％28v = sql.80％29.aspx [ ^ ]

http://msdn.microsoft.com/en-us/library/ms175528.aspx [ ^ ]

http://stackoverflow.com/questions/3553120/what-are-prepared-statements-how-are-they-they-from-dynamic-sql [

have a look at :
http://msdn.microsoft.com/en-us/library/aa905910%28v=sql.80%29.aspx[^]

http://msdn.microsoft.com/en-us/library/ms175528.aspx[^]

http://stackoverflow.com/questions/3553120/what-are-prepared-statements-how-are-they-different-from-dynamic-sql[^]

hope this hepls.

这篇关于在SQL中需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！