Why should we go for stored procedures? Why not direct queries?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of lock modes in sql server 2000?
What is the difference between createstatement and preparedstatement?
Can you get second highest salary from the table?
If a stored procedure is taking a table data type, how it looks?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is update locks?
What are the steps you will take to improve performance of a poor performing query?
Explain the collation?
What is the maximum size of column in sql server?
where the connection string store in the database
Do comments need to go in a special place in sql server 2005?
Explain what is sql server english query?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)