If there is failure during updation of certain rows, what
will be the state?
Answers were Sorted based on User's Feedback
Answer / guest
No changes will occur. So the data will be in previous
state only.
| Is This Answer Correct ? | 18 Yes | 0 No |
how can you attach more than 20 ldf files in sql server
What are examples of triggers?
Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem
what is web server?
What is the dbcc command and why is it used?
What is log shipping?
What are pessimistic lock and optimistic lock?
What is service broker? : sql server database administration
Explain indexed views?
Differentiate between a having clause and a where clause.
What is user defined datatypes and when you should go for them?
Explain few examples of RDBMS?
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)