CnnStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=test;Data Source=SAITEK-DZKYPNPB"
Cn1.Open CnnStr
Set Cm1.ActiveConnection = Cn1BillMaster.Open "SELECT * FROM 过程名('参数')", Cn1, adOpenDynamic, adLockOptimistic
With BillMaster
.AddNew
.Fields(1) = 67
.Fields(2) = ith!TCOM
.Update
XZID = .Fields(0)
End With
Cn1.Open CnnStr
Set Cm1.ActiveConnection = Cn1BillMaster.Open "SELECT * FROM 过程名('参数')", Cn1, adOpenDynamic, adLockOptimistic
With BillMaster
.AddNew
.Fields(1) = 67
.Fields(2) = ith!TCOM
.Update
XZID = .Fields(0)
End With
returns table
as
return(select * from 你的表 where 你的列=@a)
go
你可以参考:
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=133244