Advantages and disadvantages of stored procedures.
Answers were Sorted based on User's Feedback
Explain the categories of stored procedure?
Please explain go command in sql server?
i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com
Explain what role entity and relationship play in an ER diagram.
Why we use functions in sql server?
What are the different methods available under sqlcommand class to access the data?
What are sql dirty pages?
How many levels of sp nesting is possible?
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
Explain what are commit and rollback in sql?
What are the different normalization forms?
Can two tables share the same primary key?
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)