ส่วนตัวผมเวลา insert data ก็เขียน store procedure

ตัวอย่าง ส่วนของ sql2005
ALTER PROCEDURE [dbo].[Add_ChequeCustomer]
@varCqId int,     
@varCqNo varchar(12),
@varCqDate smallDatetime,
@varCqCustId smallint,
@varCqAmount money,
@varCqBankCode tinyint,
@varCqBranch varchar(30),
@varCqAllInvNo varchar(255)
AS

if @varCqBankCode = 37
begin
INSERT INTO dbo.ChequeCustomer
                      (CqId, CqNo, CqDate, CqCustId, CqAmount, CqBankCode, CqBranch, CqAllInvNo, IsBillPrint, BankInDate)
SELECT     @varCqId, @varCqNo, @varCqDate, @varCqCustId, @varCqAmount, @varCqBankCode, @varCqBranch, @varCqAllInvNo, 1, @varCqDate
Goto MyEnd
end

INSERT INTO dbo.ChequeCustomer
                      (CqId, CqNo, CqDate, CqCustId, CqAmount, CqBankCode, CqBranch, CqAllInvNo)
SELECT     @varCqId, @varCqNo, @varCqDate, @varCqCustId, @varCqAmount, @varCqBankCode, @varCqBranch, @varCqAllInvNo
MyEnd



ส่วนของ access
Public Const TheProvider = "Provider=SQLOLEDB;Data Source=SERVERSATTEL;Persist Security Info=True;Password=31006;User ID=sa;Initial Catalog=Red"


Set cnn = New ADODB.Connection
cnn.Open TheProvider
        cnn.BeginTrans
str = Me.TextMinuteSum & Chr(44) & Me.FramePeriod & Chr(44) & Chr(39) & Me.TextStart & Chr(39) & Chr(44)
str = str & Chr(39) & Me.TextEnd & Chr(39) & Chr(44) & Chr(39) & Trim(Me.LblPeriod.Caption) & Chr(39) & Chr(44)
str = str & Chr(39) & Me.Textwhy & Chr(39) & Chr(44) & EmpId_B & Chr(44) & Me.TextKey & Chr(44) & Me.TextRate
    cnn.Execute "EXEC Add_OtAbsence " & str
    cnn.CommitTrans
cnn.Close

จะลองดูครับ
ลืมบอกไปว่า เป็น sql server 2005 express