sqlServer 一些常用的

1.插入数据

	INSERT INTO t_casename(name,plantid,factoryid,mouldclassid,casequery) 
	VALUES('旋转盖',1,1,297,'8')	

2.表中添加字段

ALTER TABLE table_name  ADD column_name datatype
例如：ALTER TABLE t_mouldclass ADD	pdfuuid  CHAR(22)  NULL	

3.删除表中的列

ALTER TABLE table_name  DROP COLUMN column_name

4.修改字段

ALTER TABLE table_name ALTER COLUMN column_name datatype

5.删除表数据truncate和delete的用法

DELETE VERSION  WHERE VERSION.FNAME='2017062602'; 

TRUNCATE TABLE t_workshop_dataCollection;	

6.修改表的数据

UPDATE t_auxiliary_tablerelationship 
SET t_auxiliary_tablerelationship.casefield = 'mouldtype' 
WHERE tablename = 't_repair_notice'

7. 给表t_repair_notice字段mouldtype赋值

   UPDATE  t_repair_notice  SET  t_repair_notice.mouldtype = Project.projecttype
   FROM    t_repair_notice ,Mould,Project
   WHERE   t_repair_notice.mouldinteriorid = Mould.mouldID
   AND Mould.projectID  =  Project.projectID	
   

8. 修改字段的数据类型

   IF COL_LENGTH('t_grading_rule','fieldscore') IS NOT NULL   
   	ALTER TABLE t_grading_rule ALTER COLUMN	fieldscore  DECIMAL (18,1)  NULL