摘要： 1.id从头开始truncate table 表名2.对一个字段取反吧update topic set {0}=abs({0}-1) where ArticleId={1}3，返回上次插入的ID值select @@Identity4.算出text字段的最大长度select datalength(contents) as suma,[ArticleId],title from topic order... 阅读全文