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
- 6046 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you edit the .rdl code associated with a linked report?
How do you improve the performance of a SQL Azure Database?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Can we linked SharePoint to a SQL database?
What is openrowset sql server?
How to find Duplicate Records In table?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is the use of =,==,=== operators?
Explain indexing and what are the advantages of it?
What are the advantages of using a stored procedure?
What is the use of builtinadministrators group in sql server? : sql server security
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What do you mean by cardinality?
How to use group functions in the select clause in ms sql server?
How to create an inline table-valued function?
