Click here to Skip to main content
15,032,024 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:
Hi,

How do i Delete spesific contents that were specified in a View, with a Stored Procedure?
Can anyone help me? I'm new with SQL.
Posted
Comments
Maciej Los 27-Mar-13 9:58am
   
What you mean "delete specific contents"?
Do you want to delete rows or columns?
Why?

Please, be more specific and provide more details...

1 solution

A view is treated in many ways just like a table. So you can do:

SQL
DELETE FROM MyView WHERE ID = @ID
   
Comments
Sergey Alexandrovich Kryukov 27-Mar-13 10:40am
   
Right, a 5.
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900