SQLserver 语句

select top(10)* from xihu_PreOrders
select top(10)* from CustomerThresholdInfo

update CustomerThresholdInfo set Enable=0,FeatureEnable=0 where AddressID=‘R_Anbang’

select product_name_Chinese,product_description_Chinese from ProductData
where SKU_local_red=‘GF92443574-20EA’

select pd.sku_local_red ,list_price_posttax_red,brand from ProductVariance pv
INNER JOIN ProductData pd ON pv.sku_local_red=pd.sku_local_red
where Red_status =N’新增’
and GTS_control_class not like ‘%CNDPC%’
and GTS_control_class not like ‘%CNHAZ%’
and GTS_control_class not like ‘%CNTOX%’
and GTS_control_class not like ‘%CNXPL%’
and pd.sku_local_red !=‘’
and Sellable_red=‘Y’
and brand=‘Greiner’

-----------插入数据
USE [MerckB2B]
GO
insert into [dbo].[ProductData]
(
[SKU_local_red]
,[SKU_local_blue]
,[product_number]
,[list_price_pretax]
,[list_price_usd]
,[product_name_English]
,[product_synonyms_English]
,[product_name_Chinese]
,[product_synonyms_Chinese]
,[product_description_English]
,[product_description_Chinese]
,[base_unit]
,[size_dimension]
,[gross_weight]
,[net_weight]
,[weight_unit]
,[volume]
,[volume_unit]
,[storage_condition]
,[storage_condition_description]
,[temp_condition]
,[temp_condition_description]
,[empirical_formula]
,[linear_formula]
,[cas_no]
,[mdl_no]
,[molecular_weight]
,[assay]
,[boiling_point]
,[melting_point]
,[pack_size]
,[pack_unit]
,[hazardous_prod]
,[brand]
,[business_division]
,[SDV]
,[SDV_description]
,[SBU]
,[SBU_description]
,[GTS_status]
,[GTS_control_class]
,[MClarity_quality_level]
,[web_url]
,[image_url]
,[primary_product_category]
,[secondary_product_category]
,[tertiary_product_category]
,[updateDate]
,[BOR]
,[list_price_posttax_red]
,[list_price_posttax_blue]
,[Sellable_red]
,[Sellable_blue])
select

   [SKU_local_red]
  ,[SKU_local_blue]
  ,[product_number]
  ,[list_price_pretax]
  ,[list_price_usd]
  ,[product_name_English]
  ,[product_synonyms_English]
  ,[product_name_Chinese]
  ,[product_synonyms_Chinese]
  ,[product_description_English]
  ,[product_description_Chinese]
  ,[base_unit]
  ,[size_dimension]
  ,[gross_weight]
  ,[net_weight]
  ,[weight_unit]
  ,[volume]
  ,[volume_unit]
  ,[storage_condition]
  ,[storage_condition_description]
  ,[temp_condition]
  ,[temp_condition_description]
  ,[empirical_formula]
  ,[linear_formula]
  ,[cas_no]
  ,[mdl_no]
  ,[molecular_weight]
  ,[assay]
  ,[boiling_point]
  ,[melting_point]
  ,[pack_size]
  ,[pack_unit]
  ,[hazardous_prod]
  ,[brand]
  ,[business_division]
  ,[SDV]
  ,[SDV_description]
  ,[SBU]
  ,[SBU_description]
  ,[GTS_status]
  ,[GTS_control_class]
  ,[MClarity_quality_level]
  ,[web_url]
  ,[image_url]
  ,[primary_product_category]
  ,[secondary_product_category]
  ,[tertiary_product_category]
  ,[updateDate]
  ,[BOR]
  ,[list_price_posttax_red]
  ,[list_price_posttax_blue]
  ,[Sellable_red]
  ,[Sellable_blue]
  from ProductData_Backup
  where sku_local_red='N3877-1G'