Can you explain what is indexed view? How to create it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  


You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  


What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,


What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,


Define constraints and give an example of their use?

0 Answers  






What is nolock?

0 Answers  


What is log cache in sql server?

0 Answers  


i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  


how to overcome kernel isssues

0 Answers   Fortune,


Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  


What are acid properties of transaction?

0 Answers  


Categories