MSSQL语法
DELETE FROM d_card_fill WHERE (card = '值1') 1.在该语句中,如果有多个值是要删除该怎么写?不会只有AND吧; 2.如果要删除一段连续值该怎么表达?如“值1-值9”
DELETE FROM d_card_fill WHERE (card = '值1') 1.在该语句中,如果有多个值是要删除该怎么写?不会只有AND吧; 2.如果要删除一段连续值该怎么表达?如“值1-值9”
答案:1。DELETE FROM d_card_fill WHERE (card = '值1') or 字段名称 = ‘值’
2.DELETE FROM d_card_fill WHERE card in('1','2','3','4','5','6','7','8','9')
如果是数字型可以这样
DELETE FROM d_card_fill WHERE (card 〉0 and card<10)
上一个:谁有免费的mssql数据库啊,
下一个:建立好空间sql网站后。提示。没有开启 MSSQL 扩展库!请问如何开启?