how to select a field with firstletter as capital and
remaining are small letters
Answers were Sorted based on User's Feedback
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Explain about Joins?
What types of replication are supported in sql server?
How to get the definition of a trigger back?
Can you please differentiate between a primary key and a unique key?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
What are a scheduled jobs?
Explain the creation and execution of a user-defined function in the sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What are wait types?
What are explicit and implicit transactions?
How to get nth highest salary from employee table.
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)