Update - delete - insert (1 Viewer)

[zezo2021]

is the stored procedure in the SQL server equal or replacement of the update - delete - append query in Access

I ask this question because views not support delete or update in SQL server

 

[June7]

Stored procedure can be coded for all those actions. However, passing parameters can get complicated. Review https://stackoverflow.com/questions...-passing-parameters-from-access-module-in-vba

 

[theDBguy]

I ask this question because views not support delete or update in SQL server

Sorry I'm a little confused by that statement. Are you trying to modify the data using SQL Server or Access?

Modify Data Through a View - SQL Server

Modify Data Through a View

learn.microsoft.com

 

[cheekybuddha]

Sorry I'm a little confused by that statement.

I was as well.

But I think the OP is trying to equate a stored query in Access with a View in SQL.

So, I think it's not possible to have an 'Action View' like you would have an 'Action Query' in Access.

Yes, a Stored Procedure can be used in T-SQL for the purpose.

Or just use a Pass-through query with the UPDATE/INSERT/DELETE SQL statement.

 

[Pat Hartman]

I ask this question because views not support delete or update in SQL server

They do. You just need to specify a PK when you link them in Access.

 

[zezo2021]

I was as well.

But I think the OP is trying to equate a stored query in Access with a View in SQL.

So, I think it's not possible to have an 'Action View' like you would have an 'Action Query' in Access.

Yes, a Stored Procedure can be used in T-SQL for the purpose.

Or just use a Pass-through query with the UPDATE/INSERT/DELETE SQL statement.

Thanks for your answer

 

[spaLOGICng]

is the stored procedure in the SQL server equal or replacement of the update - delete - append query in Access

I ask this question because views not support delete or update in SQL server

I use passthrough queries in Access to pass the execution statement with the parameters to SQL Server.

You can execute anything you want providing you have the requisite permissions.

Be sure to set Returns Records to False for Action Statements,