GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database

 Print  |  
Question:  What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?



March 03, 2006 13:34:49 #1
 sreyaskvmce&it   Member Since: March 2006    Total Comments: 6 
RE: What is the diff b/w a stored procedure and a view...
 

A view is a virtual table.Which is given to the help of different users.

The view can be created at

Create view employee(name,no,salary,age) with encryption

As

select empname,empno,sal,empage from empmaster;
     

 

Back To Question