by yanjiwuhao - Web开发 - 2011-12-20 09:48:48 阅读(584) 回复(0)
//存储过程代码 CREATE PROCEDURE [AddNewInvoiceInfo] (@sUserID int,@sClaimMethod varchar(50),@sInvoiceNum varchar(50),@sInvoiceDate datetime,@sBuyCity varchar(50))AS Insert Into SMB_InvoiceInfo (MemberID,ClaimMethod,InvoiceNum,InvoiceDate,InvoiceCity) Values (@sUserID,@sClaimMethod,@sInvoiceNum,@sInvoiceDate,@sBuyCity) return @@IDENTITY GO //调用存储过程代码 Dim CN As New SqlConne...
create procedure aaa @a varchar(9) as if EVAL(@A) drop table mybiao GO 我想要这样的结果,用 execute aaa \"字符串表达式\" 来调用该存储过程,输入一个表达式,如:\"1+1=2\",要是为“真”,就删除表“mybiao”。但上述存储过程不能创建,请教用哪个函数来代替EVAL可实现这种过程,谢谢!
1API调用 Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Type OPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long lpstrFilter As String lpstrCustomFilter As String nMaxCustFilter As Long nFilterIndex As Long lpstrFile As String nMaxFile As Long lpstrFileTitle As S...