Explain few examples of stored procedure over triggers?
No Answer is Posted For this Question
Be the First to Post Answer
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is a Join and explain its types?
Can group functions be mixed with non-group selection fields in ms sql server?
Explain the disadvantages of cursors?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is the purpose of self join?
What is a unique key constraint?
What is indexed view?
Which system table contains information on constraints on all the tables created?
What are the different types of subquery?
Explain fundamentals of Data ware housing & OLAP?
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)