adspace


What are Magic Table?

Answer Posted / sandeep

magic table two part
1)Inserted
a)Insert
b)update
2)Deleted

Is This Answer Correct ?    24 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I check that whether automatic statistic update is enabled or not?

1120


What are the different SQL Server Versions you have worked on?

1084


What is the difference between upgrade and migration in sql server?

1193


List out the different types of locks available in sql server?

1058


How to rebuild the master database?

1175


what is the difference between openrowset and openquery?

1208


Can you index views?

958


How efficient you are in oracle and SQL server?

1269


What is subquery? Explain the properties of a subquery?

1070


Why and when do stored procedure recompile?

1077


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2300


What are different types of constraints?

1007


What is standby servers? Explain types of standby servers.

1089


How to convert character strings into numeric values?

1196