Loading

How to write a stored procedure to create view?

How to write a stored procedure to create view?

Talha Majeed

7y1.4k

How to write a stored procedure to create view in the database?

Stored Procedure needs to be dynamic if any record update any of the above tables it should update the views.

Table Name : Member

Database Name: DataMart

Thanks,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this Query:
create procedure sp_text
as
begin
exec ('create view myview as select name,lname from Json_detail where EnrolID=1 ' )
end

exec sp_text
0
Nirav Gandhi7y ago
Please understand database concepts. Table and view both have different concepts.

Table: is used for Inset, update and delete data.

View: is a virtual table(logical) based on the result-set of an SQL statement. so if you insert any data on a table it will automatically reflect on view.
Create View VwTableName

as

SELECT ID,COl1,COL2

FROM Table1
0
Gajendra Jangid7y ago
hello dear,

you can create simple view you don't need to create dynamically view using stored procedure... when you will any change in table they auto refelect in view because view is a virtual table....ok..

so create simple view like:
create view vw_name
as
select a,b from table
0
Jignesh Kumar7y ago
HI Talha,

Please find sample view, When Any data changes happen SQL will take care of that View is virtual table so what ever datachange happens that will applicable to View as well
Create View VwMemberDetails
As
Select MemberId,MemberFirstName,MemberLastName,Email  from Member
Please find below link,
https://www.tutorialrepublic.com/sql-tutorial/sql-create-view-statement.php
0