Why we use stored procedure instead of query?
No Answer is Posted For this Question
Be the First to Post Answer
what is a database? : Sql dba
How do I trace sql profiler?
i need department wise top 2 employees salary.which logic i will use
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
How can we optimize a sql query?
Can we rollback after truncate?
What is pivot query?
What are the different operators available in sql?
Which software is used for pl sql programming?
how to analyze tables with 'mysqlcheck'? : Sql dba
difference between pl/sql table and normal pl/sql table
How to write html code in pl sql?
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)