单个存储过程中插入和更新在烧毛表

kannan.gandhi:嗨，下面的示例程序，在烧毛表插入和更新单个存储过程codeprelang="SQL"spanclass="code-keyword"CREATE/spanspanclass="code-keyword"PROCEDURE/span[dbo].[emp]@emp_idspanclass="code-keyword"varchar/span(max),@categoryspanclass="code-keyword"varchar/span(max),@emp_catspanclass="code-keyword"varchar/span(max)spanclass="code-keyword"AS/spanspanclass="code-keyword"BEGIN/spanspanclass="code-keyword"SET/spanNOCOUNTON; spanclass="code-keyword"if/spanspanclass="code-keyword"exists/span(spanclass="code-keyword"select/span*spanclass="code-keyword"from/spanemp_dataspanclass="code-keyword"where/spanemp_id=spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"+@emp_id+'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-keyword"and/spancategory=spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"+@category+'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-keyword"and/spanemp_cat=spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"+@emp_cat+'/spanspanclass="code-string"'/spanspanclass="code-string"'/span)spanclass="code-keyword"exec/span(spanclass="code-string"'/spanspanclass="code-string"UPDATEemp_datasetemp_cat='/spanspanclass="code-string"'/spanspanclass="code-string"1231'/spanspanclass="code-string"'/spanspanclass="code-string"'/span)spanclass="code-keyword"else/spanspanclass="code-keyword"exec/span(spanclass="code-string"'/spanspanclass="code-string"Insertintoemp_data(emp_id,category,emp_cat)Values('/spanspanclass="code-string"'/spanspanclass="code-string"'/span+@emp_id+spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string",'/spanspanclass="code-string"'/spanspanclass="code-string"'/span+@category+spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string",'/spanspanclass="code-string"'/spanspanclass="code-string"'/span+@emp_cat+spanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/spanspanclass="code-string"'/span)spanclass="code-keyword"END/spanspanclass="code-keyword"GO/span/pre/code感谢卡纳安www.steadfastglobal.com
Vishal.Waman

First写INSERT查询比更新查询{C}
查看
或尝试{A1}]