INSERT INTO cnccontact
(id, name, department, officesite, phone, mobile)
VALUES ('requestid', 'requestname', 'requestdepartment', 'requestofficesite',
'requestphone', 'requestmobile')有些不是,我用了smallint, chat, 等
(id, name, department, officesite, phone, mobile)
VALUES ('requestid', 'requestname', 'requestdepartment', 'requestofficesite',
'requestphone', 'requestmobile')有些不是,我用了smallint, chat, 等
(id, name, department, officesite, phone, mobile)
VALUES ('+ @requestid +', '''+ @requestname +''', ''' + @requestdepartment
+''', ''' + @requestofficesite +''', ''' + @requestphone
+''', '''+ @requestmobile + ''')'
exec(@sql)
dim sql
sql="INSERT INTO cnccontact
(id, name, department, officesite, phone, mobile)
VALUES ("+ requestid +", '"+ requestname +"', '" + requestdepartment
+"', '" + requestofficesite +"', '" + requestphone
+"', '"+ requestmobile + "')"
conn.Execute sql