How to update multiple rows with one update statement in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What are database states in ms sql server?
What is cursor in ms sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
If we use where clause in the left outer join then how the query would behave/act?
What is the command used to recompile the stored procedure at run time?
Explain isolation levels that sql server supports?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
Explain transaction isolation levels in sql server?
How to list all schemas in a database?
How to use “drop” keyword in sql server and give an example?
Explain ranking functions?
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)