How to create a view on an existing table in ms sql server?

Question Posted / sanjeev saxena

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

More SQL Server Interview Questions

How to get a list of columns in a view using the "sp_columns" stored procedure?

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

how to retrive only second row from table in sql server 2000?

Explain features of analysis services?

Why de-normalization required?

What is database replication?

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

What is an expression in ms sql server?

Write a sql query to get zero records from a table having n number of records?

Can we move Resource database from one path to another? If yes,How can we?

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Why use update_statistics command in sql server?

For more SQL Server Interview Questions Click Here