可以存储在表中存储过程（地名），但仍然可以正确执行

法鲁克・穆罕默德・沙希德
- SP创作
创建程序测试
@ param1的数据类型为varchar（10），
@ param2的数据类型为varchar（10）

BEGIN
COLUMN2选择Column1中，...从表1完

好
- 简单的SP执行
EXEC测试'1'，'2'


DECLARE @ SPwithParameter为varchar（1000）
设置_AT_ SPwithParameter ='测试'

- 从文本的SP执行
执行@ SPwithParameter '1'，'2':奥姆・普拉卡什・潘特

是codeprelang="sql" spanclass="code-comment"--/spanspanclass="code-comment"AssumingthatyouhavethefollowingSP:/spanspanclass="code-keyword"create/spanspanclass="code-keyword"procedure/spanCallTestspanclass="code-keyword"as/spanspanclass="code-keyword"begin/spanspanclass="code-keyword"select/spansellerName,spanclass="code-string"'/spanspanclass="code-string"US'/spanspanclass="code-keyword"as/spanspanclass="code-string"'/spanspanclass="code-string"Country'/spanspanclass="code-keyword"from/spansellersspanclass="code-keyword"end/spanspanclass="code-keyword"go/span spanclass="code-comment"--/spanspanclass="code-comment"TabletostoreSPname:/spanspanclass="code-keyword"Create/spanspanclass="code-keyword"table/spansp_data(iidspanclass="code-keyword"int/span,sp_namespanclass="code-keyword"varchar/span(spanclass="code-digit"50/span)); spanclass="code-comment"--/spanspanclass="code-comment"insertspname/spanspanclass="code-keyword"insert/spanspanclass="code-keyword"into/spansp_dataspanclass="code-keyword"values/span(spanclass="code-digit"1/span,spanclass="code-string"'/spanspanclass="code-string"CallTest'/span); spanclass="code-comment"--/spanspanclass="code-comment"getnamefromdb:/spanspanclass="code-keyword"declare/span@sp_namespanclass="code-keyword"varchar/span(spanclass="code-digit"50/span)spanclass="code-keyword"select/span@sp_name=sp_namespanclass="code-keyword"from/spansp_data spanclass="code-comment"--/spanspanclass="code-comment"ExecutetheSP/spanspanclass="code-keyword"exec/span(@sp_name);/pre/code