Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5887 Views
- I also Faced
- E-Mail Answers
Answer Posted / anupom das
Use Table variable with a identity column. Then make a while
loop row by row
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sql or structured query language?
What is the difference between char, varchar and nvarchar?
In which format does an image save in SQL Server database ?
What is tempdb in sql server?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is query and its types?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How to list all schemas in a database?
What is the default value of an integer data type in sql server 2005?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Give me a SQL Query to find out the second largest company?
What is mean by dml?
Explain the various types of concurrency problem?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Can sql server be linked with other servers like oracle?
