请问如何删除SQL数据库表中的指定行???
------解决思路----------------------
DELETE FROM dbo.MailSendLog
WHERE sn IN (
SELECT sn
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY SN ) AS RowNumber ,
SN
FROM dbo.MailSendLog
) t
WHERE RowNumber = 5 )
------解决思路----------------------
全部敲出来的
’连接到数据库
Dim strCon As String = "Data Source=.;Initial Catalog=数据库名;Persist Security Info=True;User ID=登录名;Password=密码"
Dim Conn As New SqlClient.SqlConnection(strCon)
Conn.Open()
Dim strDele As String = "delete from 表 where id ="+id变量
Dim cmd As New SqlClient.SqlCommand(strDele,Conn)
'执行删除
cmd.ExecuteNonQuery()
Conn.Close()
------解决思路----------------------
可以根据表的主键条件进行删除
------解决思路----------------------
delete。。。