adspace


What is difference between createstatement and preparedstatement?

Answer Posted / Jyoti Shukla

CreateStatement is a method used to compile SQL statements into PreparedStatements. PreparedStatements are precompiled and optimized, while CreateStatement generates a new Statement object each time it's called.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Equi join and non equi join is possible with sql server?

1134


How to provide default values to function parameters?

1261


What is in place upgrade in sql server?

1127


what is spatial nonclustered index

1060


Explain “row_number()” in sql server with an example?

1080


When should you use an instead of trigger?

1054


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1134


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1300


What is an indexed view?

1023


Can sql servers link to other servers like oracle?

919


What is the difference between for xml raw and for xml auto?

1119


Does view occupy space?

1022


What is temporary table in sql server? Why we use temp table?

1023


How can you append an identity column to a temporary table?

1071


How do I find query history in sql server?

1026