win10文件缺失无法开机:数据库存储过程(如何在Stored Procedures中实现添加,删除,修改等功能)

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/14 00:56:35
就是要在Stored Procedures写一段以后可以反复使用的存储起来的代码使它被调用后能够实现添加,删除,修改的功能.

As my experience, you need dynamic SQL to do so.
While it is not a good practice to use dynamic SQL in a SP.
Suggest to study SQL Server, SP_HELP and SP_HELPDB, Hopefully their structures can be of some help. (I can not post the code because over 200 characters limits).