以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  [求助]求助老师，这个语句怎么写  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=135069)
--  作者：YOU
--  发布时间：2019/5/16 10:58:00
--  [求助]求助老师，这个语句怎么写

cm d.Com mandText = "ins ert in to 回答明细(openid,题目序号,题目id,题目类型,题目分数,题目内容,选项A,选项B,选项C,选项D) Sel ect \'" & OpenidA & "\',100+Row_Number() Over(Order by uid) As RowNum,Row_Number() Over(Order by uid) As RowNuma,DisplayValue,branch,subject,AnswerA,AnswerB,AnswerC,AnswerD fro m 练习题 WH ERE id=\'" & pageA & "\'"
Dim oip As String = cmd.ExecuteNonQuery()

这种SqlServer语句如何向项目这种方式写

Dim cmd As new SQLCommand
cmd.ConnectionName = "orders"
cmd.CommandText = "Insert Into 员工  (姓名, 年龄, 学历, 照片) Values(?,?,?,?)"
cmd.Parameters.Add("@姓名",Name)
cmd.Parameters.Add("@年龄",Age)
cmd.Parameters.Add("@学历",XueLi)
cmd.Parameters.Add("@照片",Files)
cmd.ExecuteNonQuery()
--  作者：有点甜
--  发布时间：2019/5/16 11:57:00
--  

比如

 

"insert in to 回答明细(openid,题目序号,题目id,题目类型,题目分数,题目内容,选项A,选项B,选项C,选项D) Select ?,100+Row_Number() Over(Order by uid) As RowNum,Row_Number() Over(Order by uid) As RowNuma,DisplayValue,branch,subject,AnswerA,AnswerB,AnswerC,AnswerD from 练习题 WHERE id=?"