1、在sqlserver中查找某个字段存在于那个表中的语句是:
use test
go
select a.Name as tableName from sysobjects a inner join syscolumns b on a.ID=b.ID
where b.Name='列名'
例句:
use DigSmart70FL(此为数据库名)
go
select a.Name as tableName from sysobjects a inner join syscolumns b
on a.ID=b.ID where b.Name='DtReceived'
2、印射两个表的信息
insert into PN_Model_CommisionScheme(PK_Group_Model,intYear ,intMonth ,Product_No ,Model_No,Commission_Data ,EmployeeType,CategoryItemId,PK_CategoryItem)
select PK_Group_Model,intYear,7 as intMonth,Product_No,Model_No,0,1,23,9 from PN_Group_Model where intYear =2015 and intMonth =7 and Active_Flag=1
3、执行存储过程语句
exec Sale_TotalGroupBonusData_2014 2015,7,39,8
exec Sale_TotalProductBonusData_2014 2015,7,39
exec Total_BonusDetailsInfo_2014 2015,7,39
exec Salary_UpdateBonusDetail 2015,7,39
4、删除某表的信息
delete from PN_Model_CommisionScheme where intYear =2015 and intMonth =7
5、group by 的用法
select PR_Model_Name,COUNT(*) from PN_Employee_SN where PK_Employee=26 and SaleDate between '2015-07-01' and '2015-07-31' group by PR_Model_Name
将同名的销售量相加