What is cte (common table expression)?
No Answer is Posted For this Question
Be the First to Post Answer
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
Why I have to use stored procedures?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
How you can get the list of largest tables in a database?
What is the difference between push and pull subscription? : sql server replication
Explain about link server in sql server?
What is the sql server 2000 version number?
How do we return a record set from a Stored Procedure in SQl server 2000?
What is a scheduled job or what is a scheduled task?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Determine when to use stored procedure to complete sql server tasks?
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)