This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
do we have any alternative to store procedure while running merge statement where we can use exec or run like
exec sp_name
can we use view instead of any table to something else
Regards
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
While views are useful for simplifying data access, they cannot replace stored procedures for running complex data manipulation operations like MERGE. Stored procedures are the preferred method for encapsulating such logic in the database.
Alternative solution.. Or any other suggestions
Hi @Shambhu Rai
do we have any alternative to store procedure while running merge statement can we use view instead of any table to something else
No, you cannot.
View and Stored procedure are different things.
A view represents a virtual table definited with SELECT statement. You can join multiple tables in a view and use the view to present the data as if the data were coming from a single table.
Stored procedures are programs that can perform multiple operations, such as inserting, updating, deleting, or selecting data.
Best regards,
Cosmog Hong
do we have any alternative to store procedure
What for an alternative, in which way? A stored procedure is the one for business logic.
can we use view instead
In a view only SELECT statements are allowed, DML like MERGE are not possible/not allowed.
Can we use cte(common table expression) and then delete and select statement in view? Possible