What are the advantages of using a stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Explain about the command-line tool SQLCMD?
Why do we backup Active Directory ?
Scalability, Availability, Integration with internet, etc.)?
How many types of triggers in sql server?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
What is table level trigger?
Explain the rules for designing files and file groups in sql server?
What is the use of CASCADE CONSTRAINTS?
About DTS usage ?
What is the difference between a "where" clause and a "having" clause?
What do you think of this implementation? Can this be implemented better?
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)