sql数据库常用语句
添加:INSERT INTO [dbo].[Table]([ClsNo],[ClsName])VALUES('01','分类编号01')
删除:DELETE FROM [dbo].[Table] WHERE id=1
修改:UPDATE [dbo].[Table] set [ClsNo] ='02' WHERE id=1
查询:SELECT * FROM [dbo].[Classifications]
批量添加:insert into [dbo].Table(ID,tmStr) select ID,tmStr from Table2 where Table2.tmStr ='测试'