sql常用语句

1.将一张表的结构和数据复制给另外一张新表 SELECT * INTO Z_CustomerExtendedData1 FROM Z_CustomerExtendedData

2.将一张表的结构复制给另外一张新表 SELECT * INTO Z_CustomerExtendedData1 FROM Z_CustomerExtendedData WHERE 1=2

3.update from update Z_CustomerExtendedData  set   FinanceContactPerson=AllCustomerFinanceContact.FinanceContactPerson, FinanceContactPhoneNumber=AllCustomerFinanceContact.FinanceContactPhoneNumber,  FinanceEmailAddress1=AllCustomerFinanceContact.FinanceEmailAddress1,  FinanceEmailAddress2=AllCustomerFinanceContact.FinanceEmailAddress2  from   Z_CustomerExtendedData,AllCustomerFinanceContact   where   Z_CustomerExtendedData.CustomerID   =   AllCustomerFinanceContact.CustomerID collate Latin1_General_BIN

sql常用语句

原文：http://www.cnblogs.com/fqdt/p/6846896.html