How to create a dynamic cursor with the dynamic option?
No Answer is Posted For this Question
Be the First to Post Answer
What stored by the tempdb ? : sql server database administration
What is sleeping status in sql server?
what are the Prerequisites for Replication?
Explain what is it unwise to create wide clustered index keys?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
What objects does the fn_my_permissions function reports on? : sql server security
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
Why are sql functions used?
What do you mean by collation recursive stored procedure?
how many joins we can write if at all we have n no of tables
5 Answers Tanla Solutions, TS,
explain databases and sql server databases architecture? : Sql server database administration
What are subqueries in sql server? Explain its properties.
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)