What is the difference between a view and a stored procedure?


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

Post New Answer

More SQL Server Interview Questions

What is a derived table?

0 Answers  


What are cursors stored procedures and triggers?

0 Answers  


How reterive duplicate value in SQL?

6 Answers  


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  


Can you explain what is sql server english query?

0 Answers  






Can we use custom code in ssrs?

0 Answers  


How to use transact-sql statements to access the database engine?

0 Answers  


Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  


Does union all remove duplicates?

0 Answers  


Is it possible to create trigger on views?

0 Answers  


Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  


Can the query output be sorted by multiple columns in ms sql server?

0 Answers  


Categories