SYCW_API/文档/Sql/sql_20190226...

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT *
  FROM [CallCenter_SanYuanCW].[dbo].[T_Cus_CustomerBaseNew]
  where F_WxOpenId='123456'
  
  SELECT *
  FROM [CallCenter_SanYuanCW].[dbo].T_Cus_CustomerFinance
  where F_CustomerId=(select  top 1 F_CustomerId FROM [CallCenter_SanYuanCW].[dbo].[T_Cus_CustomerBaseNew]
  where F_WxOpenId='123456')
  
  --insert into [CallCenter_SanYuanCW].[dbo].T_Cus_CustomerFinance(F_CustomerId,F_CustomerCode)
  --SELECT F_CustomerId,F_CustomerCode
  --FROM [CallCenter_SanYuanCW].[dbo].[T_Cus_CustomerBaseNew]
  
  --truncate table [CallCenter_SanYuanCW].[dbo].T_Cus_CustomerFinance