归纳一些常用的SQL Server数据库语句
查询
select
*
from
Table_1 tb1, Table_2 tb2
where
tb1.Table_1_ID=tb2.Table_1_ID
order by tb1.Table_Date DESC
删除
delete from table where ID='101'
增加
insert into table(字段名,字段名) value('值','值')
更新
update table1 set 字段='值' where ID='111'