Oracle (3253)
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) In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
2 6046what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
3 8245how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
3 8762function can return value ,procedure also return value through out parameter then what is the difference?
3 8133create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
2 7679after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
2144
What do you understand by a stored procedure?
Please explain compound trigger in oracle?
What are programming functions?
What is full outer join in sql server joins?
What is offset in sql query?
What are different types of raid levels?
How to execute the cursor queries with "open" statements?
How do I change global variables in mysql?
Define views.
Explain the wait events in statspack report 'db sequential real'?
What is the maximum size of a database that can be opened in Microsoft Access?
What are the types of schema?
What is DB Development software?
What are the 4 objects in access?
If you have an example table, what is the best way to get sizing data for the production table implementation?