What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
- 0 Answers
- 726 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is @@error in sql?
How can you append an identity column to a temporary table?
is there a column to which a default can't be bound? : Sql server database administration
What are the new features in sql server 2016?
which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help
What is filestream?
How many types of the database links?
What is a rownum?
What is difference between rollback immediate and with no_wait during alter database?
Explain how to send email from sql database?
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
