fbhunt
asked on
MS SQL creatin a view
I am creating a view that must be updated several times during the month. Right now I have 3 SQL queries to accomplish this.
1st Query DROP VIEW {view name}
2nd CREATE VIEW (view name) as
SELECT (Several Columns)
3rd Exec {database name}_grant_permissions
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------
How would I combine into 1 SQL Query to run
1st Query DROP VIEW {view name}
2nd CREATE VIEW (view name) as
SELECT (Several Columns)
3rd Exec {database name}_grant_permissions
--------------------------
How would I combine into 1 SQL Query to run
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.