Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / visala
yes, we can have nested transactions. to know the nest
level use @@trancount
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to delete duplicate rows from table except one?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are the types of subscriptions in SQL Server replication?
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 entities and relationships?
Can two tables share the same primary key?
What are the advantages of log shipping?
How to use user defined functions in expressions?
Which tools are available to manage SQL Azure databases and servers?
How do I view views in sql server?
What do you understand by SQL*Net?
What is the difference between online clustering and Offline clustering?
Explain indexed views?
what are different types of raid configurations? : Sql server database administration
Explain indexes disadvantages?
