Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
No Answer is Posted For this Question
Be the First to Post Answer
What is normalization 1nf 2nf 3nf?
Can primary key be a foreign key?
What are the character string functions supported by sql server 2005?
What is the command dbcc checkdb used for?
Is truncate autocommit?
What is the difference between deallocate cursor and close cursor?
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
Explain the first normal form(1nf)?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Can we hide the definition of a stored procedure from a use?
To find second largest salary in Employee table
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
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)