代码拉取完成，页面将自动刷新
USE ATE;
GO
--
--未进过系统的客退品自动关联，批量操作时使用newid()
SELECT LEN('KT319-0F131A73-E7E5-4675-97B8-D8D659C3C17A');
SELECT 24 * 90;
SELECT 1.0 * (15120 - 11280) / 11280;
SELECT 6500 * 1.2 * 1.2 * 1.2 * 1.2 * 1.2;
SELECT 6500 * 1.10 * 1.10 * 1.10 * 1.10 * 1.10 * 1.10;
SELECT 9475 * 0.2;
/*
1.修改关联判断S代码的逻辑，PackageTest_IsvalidPID，中兴产品不判断
2.关联时，中兴产品增加腔体序列号编码格式判定
3.数据录入时，增加序列号合法性判定：要么符合腔体序列号格式，要么是关联过的成品序列号(两个判定分开，功能单一性)
4.数据录入时，写入数据库的数据，若是成品序列号，先转换成腔体序列号
5.数据检索时，先转换成腔体序列号
6.必须用成品序列号录入、存储的工序：包装、装箱、成品出库检验
*/
select 45000+300000+80000+10000+90000+10000+80000+250000+20000+10000+100000+5000+45000+30000+10000+45000+320000
+15000+30000+15000+30000+5000+5000+7000+50000+45000+5000+15000+10000+30000+25000+10000+10000+3000+5000+4000+50000
+8000+12000+4000+10000+30000+0.00+8000+15000+0.00+2000+6000+8000+30000+10000+90000+20000+4000+60000+0.00+6000+10000
+6000+3000+40000+60000+6000+60000+80000+0.00+10000+2000+4000+6000-239000-178800
select 45000+300000+80000+10000+90000+80000+250000+20000+10000+100000+5000+45000+30000+10000+45000+320000
+15000+30000+15000+30000+5000+5000+7000+50000+45000+2000+15000+10000+30000+25000+10000+10000+3000+5000+4000+50000
+8000+12000+4000+10000+30000+0.00+8000+15000+0.00+2000+6000+8000+30000+10000+90000+20000+4000+60000+0.00+6000+10000
+6000+3000+40000+60000+6000+60000+80000+0.00+10000+2000+4000+6000-417800
select 24134.4 +18100.8*2 +12067.2*3 +96537.6 +6033.6 +2011.2
select 12 +9*2 +6*3 +40 +3 +1
select 15+12+9*3+6+4+1+35
select 1998200.00*0.35
select 1000/1166.666500
select 1100+45*12
select top 100 * from PCBAssemble order by RecordTime desc
select top 100 * from Test order by TestTime desc
Go
select top 100 * from AssembleDetail order by RecordTime desc
select * from PackageTest where PackageProductSN='SG91825F5001'
select * from PackageTest where ProductSN in('MB3Jss110095i220152','MB3JSS110126i220038')
select * from SNUnion where PackageProductSN='SG91825F5001' or ProductSN in('MB3Jss110095i220152','MB3JSS110126i220038')
select top 100 * from StockOut order by RecordTime desc
select top 100 * from Test order by TestTime desc
select * from PackageTest where PackageProductSN='SG91825F5012'
EXEC SNUnion_selectbyPackageProductSN 'SG91825F5001'
select * from Package
select 18000*12
select 12800*12
select top 100 * from PackageTest order by PackageTime desc
select top 100 * from Test_Active order by TestTime desc
select * from PackageTest where PackageProductSN='13ZK02010024'
select top 100 * from PIMTest order by TestTime desc
select top 100 * from PowerTest order by RecordTime desc
select 1-0.7*0.7*0.8
select * from Customer
select * from ProductType where SN3BK<>'' order by CustomerID
--XA073JSS110038AI2000538 STR2200064 010307 10.53.20.121
select * from tb_Action_Record order by RecordTime desc
select top 100 * from PowerTest order by RecordTime desc
select top 100 * from PIMTest_temp where SignalSource1 like 'j%' order by TestTime desc
select top 100 * from PIMSecondTest where SignalSource1 like 'j%' order by TestTime desc
select * from PIMTest
where ProductTypeID='STR4400044' and TestTime > '2018-05-01 00:00:00.000'
order by TestTime
select pit.* from PIMTest p inner join PIMTestItem pit
on p.ProductSN=pit.ProductSN and p.TestTime=pit.TestTime
where ProductTypeID='STR4400044' and p.TestTime > '2018-05-01 00:00:00.000'
order by p.TestTime
select top 100 ProductSN,count(*) as q from DebugTest d
where DebugStep='微调' and not exists(select * from RepairItem where ProductSN=d.ProductSN and RepairStep='调试')
group by ProductSN
order by q desc
select top 10 * from RepairItem
select 700/3
select ProductSN,TestTime,TopoAlias,InterceptOrder,InputPower1,InputPower2,InputF1,InputF2,OutputF,TestValue,HighSpec,IsPass,1 as IsCurrent
from PIMSecondTestItem
where ProductSN='XA473JSS110023A10I1900055'
select CONVERT(bit,1)
-----------------------------------------------------------
--------查询有权限的远程账户工号、姓名-----------
-----------------------------------------------------------
select distinct m.Email,u.UserName from aspnet_Membership m
inner join aspnet_Users u on m.UserId=u.UserId
inner join aspnet_UsersInRoles ur on m.UserId=ur.UserId
order by UserName
select top 1000 PackageProductSN,len(PackageProductSN) from PackageTest pt
inner join ProductType p
on pt.ProductTypeID=p.ProductTypeID and p.CustomerID='001'
order by PackageTime desc
select top 100 * from Test order by TestTime desc
select top 100 * from PIMTest order by TestTime desc
select top 100 * from PowerTest order by RecordTime desc
select * from repair where ProductSN='AJ3JSS100221A50H200871'
select * from RepairItem where ProductSN='AJ3JSS100221A50H200871' and RecordTime='2018-05-02 16:20:11.507'
EXEC ProductType_Flow_HasValidPostStep 'XA473Jss110002a10i1700453','STR4400044','HFATEStep',0
select dbo.Fun_HasValidRecord_ActiveATEStep('XA473Jss110002a10i1700453','STR4400044')
SELECT @result=case when (select top 1 IsPass from View_Test_Active_Check where ProductSN='XA473Jss110002a10i1700453'
and ProductTypeID in ('STR4400044')
and TestTime>ISNULL((select top 1 RecordTime from RepairItem where ProductSN=@ProductSN
and RepairStep='有源电性能测试' order by RecordTime desc),'2011-01-01 00:00:00.000')
order by TestTime desc)='Pass'
then 1 else 0 end
select * from View_Test_Active_Check where ProductSN='XA473Jss110002a10i1700453'
and ProductTypeID in ('STR4400044')
select * from Test_Active where ProductSN='XA473Jss110002a10i1700453'
select * from ProductType where CustomerID='003'
select 121*135
select 181*160
select * from [dbo].[Package_Xian_Jian] where PackageProductSN='sg91820g0133'
select * from [dbo].[Union_Xian_JiAn] where PackageProductSN='sg91820g0133'
select * from PackageTest where ProductSN='A83JSS101065a40i1700631'
update PackageTest
set IsPackage=pxj.IsPackage,Packer=pxj.Packer,PackageTime=pxj.PackageTime
from Package_Xian_Jian pxj inner join PackageTest pt
on pxj.PackageProductSN=pt.PackageProductSN
where pxj.PackageProductSN in (
select p.PackageProductSN from Package_Xian_Jian p
where IsPackage='Yes'
and not Exists(select * from PackageTest where PackageProductSN=p.PackageProductSN and IsPackage='Yes')
)
select * from PackageTest where PackageProductSN='R01051000500309001703850292'
select * from PackageTest where ProductSN='XA393JSS101024A20I0300167'
select 90/0.8
select * from Aging where AgingID in('sfl010002520180330001XiAn','str110001920180330001XiAn')
select top 10 * from PackageTest order by PackageTime desc
select 100-25*0.85
select top 100 * from PowerTest order by RecordTime desc
select top 100 * from PowerTestItem order by ID desc
select top 100 * from Test order by TestTime desc
select top 1000 * from PackintoBox order by RecordTime desc
select top 100 * from PortTest order by RecordTime desc
select * from ProductType p inner join Customer c on p.CustomerID=c.CustomerID where p.ProductTypeID='STR2200019'
select * from ProductType where ProductTypeID='STR2200019'
select * from ProductType_MultiBand
select count(*) from RepairLock
select * from PackageTest where PackageProductSN='SG91809803A7'
select * from TestItem where ProductSN='XA073JSS100391A40I1100275' and TestTime='2018-03-17 08:57:35.000'
select * from TestItem where ProductSN='XA073JSS100391A40I1100275' and TestTime='2018-03-27 14:47:43.000'
select * from TestItem where ProductSN='XA073JSS100391A40I1100275' and TestTime='2018-03-24 17:11:19.000'
select Count(*) from TestItem_forMain where ProductSN='XA073JSS100391A40I1100275'
Group by ProductSN,TestTime
select top 10 * from tb_Test_Record order by RecordTime desc
select top 10 * from tb_TestItem_Record order by RecordTime desc
select 1.0*8015/36
select top 100 * from tb_Test_Record order by RecordTime desc
select top 100 * from tb_TestItem_Record order by RecordTime desc
select top 100 * from [dbo].[TemperatureCheck] order by RecordTime desc
select * from ProductType where ProductTypeID like 'E%'
select top 100 * from PIMTest order by TestTime desc
select top 100 * from PIMTestItem where IsCurrent=0 order by TestTime desc
select * from RepairLock where ProductSN='XA073JSS100746A20I1207586'
if((not Exists(select * from Test_forMain where ProductSN=@ProductSN and TestTime>@AirFaildt and IsPass='Pass'))
or ((select top 1 HFATEStep from ProductType_Flow where ProductTypeID=@ProductTypeID)=1
and not Exists(select * from HighFTest where ProductSN=@ProductSN and TestTime>@AirFaildt and IsPass='Pass'))))
select 1.0*12/(90*24)
select 210*90+545
select 5555+0.8*(70000-19445)/3.5+200
select top 10 * from PackintoBox order by RecordTime desc
select * from PackintoBoxItem where ID=22694
select * from Test where ProductSN='XA073JSS100391A40I1100275'
select top 1000 * from JointingCheck order by RecordTime desc
--S63JSS100411A40H490022 2018-01-29 15:39:15.683 010307 10307 52 010307 str4400013
select top 10 * from Repair order by RecordTime desc
select top 10 * from RepairItem order by RecordTime desc
delete from JointingCheck where ResponseUser in('010307')
select top 100 * from RepairRoute
select * from RepairConfig
select * from PowerTest where ProductSN='KT319201803171111151'
select * from ProductType_ZTE
select 24*4
select 16*6
select 5.499+18+20+20+9.5+10+14.25
select count(*) from Test_Active where TestTime between '2018-03-17 00:00:00.000' and '2018-03-19 00:00:00.000'
select count(*) from TestItem_Active where TestTime between '2018-03-17 00:00:00.000' and '2018-03-19 00:00:00.000'
select CONVERT(VARCHAR(30),GETDATE(),120)
select GETDATE()
waitfor delay '00:00:05'
select GETDATE()
select top 100 * from PIMTestItem where ProductSN='A83JSS100481A10I1100649' and TestTime='2018-03-23 09:23:48.140'
select top 20 * from PIMTest order by TestTime desc
select top 100 * from PIMTestItem order by TestTime desc
select top 100 * from PowerTest order by RecordTime desc
select top 1000 * from PackageTest order by UnionTime desc
select * from PortTest
select top 10 * from DebugTest order by DebugTime desc
select top 100 * from RepairItem order by RecordTime desc
select * from tb_Test_Record
select 1.0*25/69
select 1.0*555000/20112000
select count(*) from QCPackCheck order by RecordTime desc
select * from JointingFailure
select (97.28+91.46+101.34)/3
select top 10 * from VoltageCheck order by RecordTime desc
select top 10 * from PowerTest order by RecordTime desc
Go
sp_helptext RepairLock_selectLatestbyProductSN
Go
sp_helptext RepairLock_selectValidbyProductSN
Go
select * from RepairLock
select * from RepairCancel
insert into RepairLock(ProductSN,RecordTime,StepItem,IsValid)
Values('1111',GETDATE(),'PowerStep',1)
insert into RepairCancel(ProductSN,RecordTime,UserID,LockorRepairTime,LockSteporRemark,CancelType)
Values('1111',GETDATE(),'10307','2012-05-22 14:09:01.720','PowerStep',0)
select top 100 * from tb_result_DFL order by testtime desc
select top 10 * from tb_Param_DFL order by testtime desc
select top 10 * from tb_DFL_Info order by testtime desc
select top 1000 * from PowerTest order by RecordTime desc
select top 100 * from PackageTest
select top 100 * from Test where len(ProductTypeID)>10 order by TestTime desc
select * from DebugTest where ProductSN='xa463jss101048a30h5201033'
select top 10 * from tb_Test_Record order by RecordTime desc
EXEC ProductType_Flow_HasValidPostStep '1001169500309001006601810','S100906008','PackageStep',0
select top 10 * from VoltageCheck order by RecordTime desc
select top 10 * from tb_Test_Record order by RecordTime desc
select top 10 * from tb_TestItem_Record order by RecordTime desc
select * from [dbo].[PackintoBox_WithoutUpload]
select * from [dbo].[PackintoBoxItem_WithoutUpload]
select * from ProductType_Flow where ProductTypeID in ('S072468004','S072468004A','S072468004B')
select top 100 * from PowerTest order by RecordTime desc
select top 10 * from tb_Test_Record order by RecordTime desc
select * from ProductType_Flow where ProductTypeID='S072468004'
select * from ProductType_Flow
select * from Vendor
select 1.0*27/69
select * from Union_Xian_JiAn where PackageProductSN='R01130A00500309001712410393'
select * from Union_Xian_JiAn where ProductSN='A83JSS101106A10H4700546'
select * from RepairConfig_Changelog
select * from tb_Test_Record order by RecordTime desc
select top 10 * from DebugTest order by DebugTime desc
select top 100 * from TTest order by RecordTime desc
select top 100 * from TTestItem order by RecordTime desc
sp_helptext TTest_insert
select count(*) from ProductType_Flow_Changelog where RecordTime between '2017-07-28 10:56:18.407' and '2017-12-28 10:56:18.407'
select top 100 * from PackageTest
--where ProductTypeID='SFL0100017'
order by UnionTime desc
select * from Union_Xian_JiAn where PackageProductSN='r01620c02500309001712804025'
select * from Union_Xian_JiAn where ProductSN='xa143jss101048a30h4300969'
select top 100 * from PackageProductSNChangeLog order by RecordTime desc
select 24+22+10+9.9+19.6+10+5.5+5
select top 100 * from PackageProductSNChangeLog
select top 100 * from Package_Xian_Jian order by PackageTime desc
select top 100000 ProductSN,count(*) as q from House group by ProductSN order by q desc
select top 100 MOID,count(*) as q from MO group by MOID order by q desc
select * from House where ProductSN='XA143JSS101048A30H4201942'
select * from NFCheck
select * from NFCheckItem
select * from tb_Test_Record
select * from tb_TestItem_Record
select top 200 * from Test_Active order by TestTime desc
select top 20 * from TestItem_Active order by TestTime desc
select top 100 * from PackintoBoxItem
select top 100 PackageProductSN,count(*) as q from PackintoBoxItem group by PackageProductSN order by q desc
select top 10 * from Repair
select top 10 * from RepairItem
select 0.8457* 8588,0.8457* 5988,0.8457* 6888
select * from ProductType where CustomerID='001' and SN3BK<>''
select * from ProductType order by ProductTypeID
select 1.0/7
select * from ProductType where HouseAmount=2
select * from SNUnion
select 1.0*150/700
select * from ProductType where ProductTypeID='STR2400108'
select * from ProductType_Flow where ProductTypeID='STR2400108'
select * from ProductType order by CustomerID desc
select * from Customer
select top 10 * from PowerTest order by RecordTime desc
select top 10 * from PowerTestItem order by ID desc
select * from Test_forMain where ProductSN='aj3jss100221a50h200871' order by TestTime desc
select top 100 * from tb_Param_DFL order by testtime desc
select * from ProductType where ProductTypeID='S042108017'
--where ProductTypeName like '%RSU%'
--S102512016
--S102512018
select top 10 * from Test where ProductTypeID='S041308001' order by TestTime
select * from TestItemType
select * from Test where ProductSN='mb3jss101039h420017'
select * from ProductType where ProductTypeID='S352512020'
EXEC ProductType_Flow_HasValidPostStep 'XA033JSS100160A90H440535','STR2400121','AirtightnessStep',0
select * from PackageTest where ProductSN='XA073JSS100814A10H3800002'
select top 5 * from ProductType_Flow_Changelog where ProductTypeID='STR2400033' order by RecordTime desc
select * from PIMSecondTest order by TestTime desc
select top 10 * from PackageTest order by PackageTime desc
select top 1 * from JointingCheck where ProductSN=''
select top 1 * from QCFixedCheck where ProductSN='XA073JSS100814A10H3800002'
select top 10 * from PIMTest order by TestTime desc
select top 10 * from PIMTestItem order by TestTime desc
select top 10 * from Repair order by RecordTime desc
select top 100 * from RepairItem order by RecordTime desc
select top 10 * from PIMSecondTest
select top 10 * from PowerTest order by ID desc
select top 10 * from PowerTestItem order by ID desc
select top 1000 * from JointingCheck where FailureID>0 order by RecordTime desc
select * from ProductType_Flow
select top 100 * from Test order by TestTime desc
select top 100 * from TestItem order by TestTime desc
select * from ProductType where ProductTypeName like '%FRGY%'
select * from Customer
select * from PIMSecondTest
select * from PIMSecondTestItem
select * from TemperatureCheck
select * from VoltageCheck
select * from PIMTest where SignalSource1 in('US40053961','US40053206') or SignalSource2 in ('US40053961','US40053206')
order by TestTime desc
select top 100 * from Airtightness order by RecordTime desc
select top 100 * from Test order by TestTime desc
select * from House where MOID='MO-1709270001' and ProductSN='xa073jss101048a20h4201424'
select * from AssembleDetail where ProductSN='xa3jss803289a10h330188'
select * from AssembleDetailItem where ProductSN='xa073jss101048a20h4201424' and BatchID='xa3jss803289a10h330188'
--91V3JSS803289A10H45001
select * from AssembleDetailItem where BatchID='xa3jss803289a10h330188'
select top 100 * from PIMTest where PCIP like '10.53.8%' order by TestTime desc
select top 100 * from tb_DFL_Info order by resultid desc
select * from PackageTest where PackageProductSN='R01620C02500309001710410825'
select * from PackageTest where ProductSN='R01620C02500309001710410825'
select top 100 * from VSWRCheckItem where TestItemName like '%温度%' order by RecordTime desc
select top 100 * from EPROMCheck order by RecordTime desc
select top 100 * from FinalCheckItem order by RecordTime desc
select top 10 * from Test order by TestTime desc
select top 10 * from HighFTest order by TestTime desc
select top 10 * from PowerTestItem order by ID desc
select top 10 * from PIMTest order by TestTime desc
--修改交调数据库表结构，详细表增加测试时间取各项具体时间，增加各项测试时长，增加主次表关联ID，过渡后可删除多余项
select * from TestItem where TestTime='2017-10-13 08:52:03.000' and ProductSN='S63190500886V22H260840' and TestTypeName like '%群时延%'
select 16.6+16.6+13.95+13.65+8+17.6
select 83*0.2
select top 100 * from EPROMCheck order by RecordTime desc
select top 100 * from VSWRCheckItem order by RecordTime desc
select top 100 * from FinalCheckItem order by RecordTime desc
select top 100 * from TestItem order by TestTime desc
select * from VoltageCheck
select top 10 * from tb_result_DFL order by testtime desc
select top 10 * from tb_Param_DFL order by testtime desc
select top 10 * from tb_DFL_Info order by testtime desc
select top 10 * from Test order by testtime desc
select top 10 * from TestItem order by testtime desc
select top 10 * from PIMTest order by testtime desc
select top 10 * from PIMTestItem order by testtime desc
select * from Test_forMain
where ProductTypeID='STR2200089' and TestTime between '2017-10-09 08:00:00.000' and '2017-10-10 08:00:00.000'
select * from Test_forMain t inner join TestItem_forMain ti
on t.ProductSN=ti.ProductSN and t.TestTime=ti.TestTime
where ProductTypeID='STR2200089' and t.TestTime between '2017-10-09 08:00:00.000' and '2017-10-10 08:00:00.000'
order by t.TestTime desc
--83531 267184 >3G
--54633 192664 >8.5G
--159 >14G
select count(distinct t.ProductSN) from HighFTestItem ti inner join HighFTest t
on t.ProductSN=ti.ProductSN and t.TestTime=ti.TestTime
where StopF>3000000000.0000 and ti.TestTime>'2017-01-01 08:24:48.000'
select top 100 * from HighFTestItem
where --StopF>8500000000.0000 and
TestTime>'2017-01-01 08:24:48.000'
select count(*) from HighFTestItem where stopF>8500000000.0000 and TestTime>'2017-01-01 08:24:48.000'
select count(*) from HighFTestItem where stopF<=8500000000.0000 and TestTime>'2017-01-01 08:24:48.000'
--985673
--3040684
SELECT * from TestItemType
select top 100 * from Test order by testtime desc
select top 100 * from FinalCheck order by RecordTime desc
select top 100 * from FinalCheckItem order by RecordTime desc
select top 100 * from EPROMCheck order by RecordTime desc
select top 100 * from VSWRCheck order by RecordTime desc
select top 100 * from VSWRCheckItem order by RecordTime desc
select * from ProductType where ProductTypeName like '%RF1606R02%'
select * from Pack_Label_Print order by RecordTime desc
select top 10 * from Aging
where DeviceName='时效箱016' order by InBoxManuTime desc
select * from Pack_Label_Print plp inner join PackageTest pt on plp.PackageProductSN=pt.PackageProductSN order by RecordTime desc
select top 100 * from PackageTest where UserID='013170' and ProductTypeID in('STR3600018','STR2200096') order by PackageTime desc
`
select top 100 * from TestItem order by TestTime desc
select ProductTypeID,convert(varchar(30),TestTime,112) as DayTime,count(*) as q from PIMTest
where SignalSource1='Jointcom' and TestTime>'2017-06-05 16:13:44.593'
Group by ProductTypeID,convert(varchar(30),TestTime,112)
order by ProductTypeID,convert(varchar(30),TestTime,112)
select top 10 * from PIMTest where SignalSource1='Jointcom' order by TestTime
select 30*0.98
select top 100 * from FinalCheck order by RecordTime desc
select top 100 * from FinalCheckItem where TestItem like 'temp%' order by RecordTime desc
select * from ProductType where ProductTypeName like '%FRGY%'
select top 10000 * from StockOut order by RecordTime desc
select * from StockOut_DeleteLog order by RecordTime desc
select * from StockOut_DeleteItem
select * from ProductType where ProductTypeID='STR1100026'
select * from PackageTest where ProductTypeID in ('STR2200090','STR2200107') and PackageTime>'2017-01-01 00:17:57.000'
order by ProductTypeID,PackageTime
select top 10 * from StockOut
select top 10 * from PackageTest order by PackageTime desc
select * from Pack_Label_Print
select * from PackageTest where PackageProductSN='T0004144 A 1734M0001'
select * from PackageTest where PackageProductSN='1734M0001'
select * from PackageTest where ProductSN='XA263JSS100944A10H3100045'
select * from ProductType where ProductTypeID='STR1100019'
select 2*728-710
select * from PackageTest where PackageProductSN in('G9170867140','G9171067028')
select 9.4+18.8+9.5+9.6
select 360000/160
select 280000/120
select TestStep,count(*) as q from PIMTest
where TestTime>'2017-06-30 00:00:52.000'
group by TestStep
order by q desc,TestStep
select * from PIMTest
where TestTime>'2017-06-30 00:00:52.000' and TestStep='返修测试三'
select * from ProductType_ZTE where ProductTypeID='STR2200066'
select * from tb_DFL_Info where Itemcode='056302200472' and testtime>'2017-06-11 10:17:57.000' order by testtime desc
select * from PIMTest where ProductSN='A83JSS100924A20H210572'
select * from PIMTestItem where ProductSN='A83JSS100924A20H210572'
select * from tb_result_DFL where partcode='XA3JSS100897A20H131741'
select * from tb_Param_DFL where ParamName is null
select * from ProductType where ProductTypeID='SFL0200053'
select top 10 * from PackageTest order by UnionTime desc
select top 10 * from DebugTest order by DebugTime desc
select * from ProductType_Flow where ProductTypeID=''
select * from Aging where AgingID like 'STR240010820170423011_iAn'
declare @A table(ID char,Quantity int)
insert into @A
select 'A',1
union all
select 'B',2
union all
select 'C',3
select STDEVP(Quantity) from @A
Go
declare @A table(ID char,Quantity int)
insert into @A
select 'A',1
union all
select 'B',2
union all
select 'C',3
select STDEV(Quantity) from @A
select top 10 * from Airtightness order by TestValue desc
--1.交调大功率测试软件使用界面，2.测试数据查询界面，3.自动上传中兴任务作业历史
select top 10 * from tb_result_DFL order by resultid desc
select top 10 * from tb_Param_DFL order by resultid desc
select top 10 * from tb_DFL_Info order by resultid desc
select count(*)
from Test
where ProductTypeID='STR4400032' and IsPass='Pass' and IsFullTest=1 and IsDebugTest=0
select count(*)
from Test
where ProductTypeID='STR4400032' and IsPass='Pass' and IsFullTest=1 and IsDebugTest=0
select top 10 * from tb_result_DFL trd
inner join tb_DFL_Info tdi on trd.resultid=tdi.resultid and trd.partcode=tdi.partcode
inner join ProductType_ZTE pz on tdi.Itemcode=pz.Itemcode
where IsPIM=1 and pz.ProductTypeID='SFL0200033'
select * from ProductType_ZTE where ProductTypeID='SFL0200033'
select * from TestItem_forMain
where ProductSN='A83JSS100694A20G431001' and TestTime='2016-10-29 00:27:43.000'
order by TestItemName
select * from TestItem_forMain
where ProductSN='A83JSS100694A20G430277' and TestTime='2016-10-29 04:46:28.000'
and TestItemName like 'VSWR_TXA1_@6'
select * from PackageProductSNChangeLog where oldPackageProductSN='R01270A00500309001612105104'
select * from PackageTest where PackageProductSN='a83jss100653a40g360127'
select * from Test where ProductSN='a83jss100653a40g360127'
select * from ProductType_Flow where ProductTypeID='STR2400108'
select * from ProductType_Flow where ProductTypeID='STR2400111'
select top 10 * from Airtightness order by RecordTime desc
select top 10 * from PIMTest order by TestTime desc
select top 10 * from PIMTestItem order by TestTime desc
--查询一个表中的列名
select name from syscolumns where id=(select id from sysobjects where xtype='u' and name='PIMTest')
select * from ProductType_Flow where ProductTypeID='STR2400030'
select * from Aging where TempEndQualTime>Dateadd(d,-10,Getdate()) and AgingID like '%iAn'
--这就是sql注入
--select * from user where username='123' or username like '%' and password='123' or password like '%'
select * from Customer
select p.CustomerID, MonthTime,count(*) from PIMTestwithTimeAxis pim
inner join ProductType p on p.ProductTypeID=pim.ProductTypeID
where MonthTime='201601'
--and TestStep in('预测')
--and IsPass='Pass'
and CustomerID between '002' and '003'
group by CustomerID,MonthTime
order by CustomerID,MonthTime
select distinct TestStep from PIMTestwithTimeAxis where MonthTime between '201501' and '201506'
select pt.PackageProductSN,
max(case pti.TopoAlias when 'A面' then TestValue end) as A面,
max(case pti.TopoAlias when 'B面' then TestValue end) as B面
--pti.TopoAlias,pti.TestValue
from PIMTestItem pti inner join
(select ProductSN,max(TestTime) as TestTime from PIMTest Group by ProductSN) as A
on pti.ProductSN=A.ProductSN and pti.TestTime=A.TestTime
inner join PackageTest pt
on pti.ProductSN=pt.ProductSN
where TopoAlias in('A面','B面') and pt.PackageProductSN --='SG9162569395'
in('SG9162569395')
Group by pt.PackageProductSN
--Sex-Enterprise-Money-Love-Family
--------------------------------------------------------------------------
-----检查导致数据上传中兴失败，的配置文件编写错误-------------------------
--------------------------------------------------------------------------
declare @temp table(PackageProductSN nvarchar(50),resultid int);
insert into @temp(PackageProductSN,resultid)
select pt.PackageProductSN,max(trd.resultid) as resultid
from PackageTest pt inner join tb_result_DFL trd
on pt.ProductSN=trd.partcode
where PackageTime between DATEADD(dd, DATEDIFF(dd,1,getdate()), 0) and DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
and IsPackage='Yes' and trd.totalresult='0' and Exists(select * from tb_DFL_Info where resultid=trd.resultid)
and Exists(select * from ProductType_ZTE pz where pz.ProductTypeID=pt.ProductTypeID)
Group by PackageProductSN;
select tpd.resultid,t.PackageProductSN,tpd.Testequipid,tpd.ProcessNum,tpd.UnitName,tpd.testtime,tpd.ParamName
,tpd.Res,tpd.ResValue,tpd.ResDesc
from tb_Param_DFL tpd inner join @temp t on tpd.resultid=t.resultid;
select * from tb_Param_DFL where resultid=40674 and ParamName is null
select * from Test where ProductSN='S63190500413F200145' and TestTime='2015-07-09 20:59:46.000'
select * from TestItem where ProductSN='S63190500413F200145' and TestTime='2015-07-09 20:59:46.000' and (LowSpec=-40.9 or HighSpec=-39.1)
select * from aspnet_Users where UserName in('006936','012801')
select * from aspnet_Membership where UserId in('47DD8248-0760-4D4A-B1CE-A47FDADED838','9F971DED-3A38-4897-9B38-F32D2D5BF024')
--*/
use ATE
select * from [10.53.20.141].[hrmis].[dbo].[View_a01] where
--A0190 in('003290','012801') order by A0190
a0101 in('彭丽够','杨昌浦','蔡智旺','陈兆军') --and A0191='在职人员' and A019U='职员'
--A01B5='人事行政系统' and A01B4='人事行政' and A0191='在职人员' and A019U='职员' and CONTENT in('行政管理部') --and A019A in ('经理','经理级')
order by A0190
--/*
select top 10 * from PackageTest order by PackageTime desc
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。