What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
Answer Posted / jagadeesh
transation can be rollback in temptable
but in tablevaribale we cannot do this
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State the difference between union and union all?
How to get nth highest salary from employee table.
What do you understand by hotfixes and patches in sql server?
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 are the basic functions for master, msdb, model, tempdb databases?
What do you know about normalization and de- normalization?
How do you test your database? : sql server database administration
Different types of keys in SQL?
What languages bi uses to achieve the goal?
What is de-normalization and what are some of the examples of it?
How to concatenate two strings in SQL Server.
What are the new features of sql server 2012 reporting service?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to view existing indexes on an given table using sys.indexes?
How do you identify a foreign key?