What is the beast way to write CTE in SQL Server ?
No Answer is Posted For this Question
Be the First to Post Answer
How is foreign key related to primary key?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
What is the usage of sign function?
What is mean by candidate key?
What is key attribute?
What are audit control procedures?
0 Answers Ernst Young, Thomson Reuters,
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What is history table in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain some stored procedure creating best practices or guidelines?
How to add code to the existing article (using improve article)?
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)