Why we use stored procedure instead of query?
No Answer is Posted For this Question
Be the First to Post Answer
How do you determine the current isolation level? : Transact sql
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
What is asqueryable?
Can a varchar be a primary key?
What is sql scripting?
take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
When should I use nosql database?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Are sql connections encrypted?
What is difference between cursor and ref cursor?
What is a loop in sql?
Why sql query is slow?
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)