事例结构化查询语言语句如下：
@(100)
@(1024)
@(500)
SET@=，Base_Employee .地址，OEV .电话，OEV .手机，OEV .电子邮件，OEV .RealDepID
from base _ OrganizeEmployeeViewASOEV
JOINBase_Employee
ONBase _员工.OEV .员工标识
哪里(OEV .帐户例如% @searchFilter %OROEV .与% @searchFilter %OROEV同名PositionLIKE% @searchFilter %)和状态=1
SET @ parm definition=N @ searchFiltervarchar(100)
SET@variable=Nk
EXECUTEsp_executesql@SQLString，@ParmDefinition，@searchFilter=@variable
本文链接：http://www.slxf119.com/16622.html 转载需授权！
网友评论