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

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

What is a ddl statement?

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What is meant by dirty read?

0 Answers  

---

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

---

How to truncate a table first before running a package?

1 Answers  

---

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

Why we use functions in sql server?

0 Answers  

---

What is exporting and importing utility?

0 Answers  

---