Answer / saurabh

View are the image of table.
advantages:- 1> they hide the details of table from which
they get data.
2> they are working as table and, provide security from
unautherized acccess.
3> they are read only.
4> they update automatically when some changes occurs in
original table

Answer / reddy

1) we can use views in sp instead of joins to increase the
performance of SP.

Answer / dr.job418

A view provides several benefits.

1. Views can hide complexity

If you have a query that requires joining several tables, or has complex logic or calculations, you can code all that logic into a view, then select from the view just like you would a table.

2. Views can be used as a security mechanism

A view can select certain columns and/or rows from a table, and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.

3. Views can simplify supporting legacy code

If you need to refactor a table that would break a lot of code, you can replace the table with a view of the same name. The view provides the exact same schema as the original table, while the actual schema has changed. This keeps the legacy code that references the table from breaking, allowing you to change the legacy code at your leisure.

These are just some of the many examples of how views can be useful.

Answer / jk.garg25

Views can be update, delete or insert

How do I start and stop sql server?

0 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

Get Current System Date Time

2 Answers  

---

What is mapping schema?

0 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What command is used to create a database in the sql server and how?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

How to create an inline table-valued function?

0 Answers  

---