sino的意思

SINO词义解析

百度的时候发现很多网友都在搜索“SINO是什么意思?”,这个SINOBLOG就比较感兴趣了,因为SINOBLOG也是众多SINO组合词中的一员,呵呵。

第一次知道SINO这么一个词是因为SINOPEC(中国石化),后来又知道SINOTRUCK(中国重 汽),然后又有SINOSTEEL(中钢),最后还有一个大家特别需要注意的SINOBLOG(中国博客,哈哈),今天特意在网上查了一下SINO这个 词,发现在维基百科和百度百科里面都没有收录这条词目,我将搜索到的关于SINO的释义整理了一下,如下:


SINO就是中国,多用于组合词的前缀,如表达中美,中日等场合:sino-US,sino-japan,中欧关系:Sino-Euro。

SINO是一个前缀,威词典的解释:1986年出版的《新英汉词典)中,对sino一词的 解释为”构词成分可表示中国的”。相当多的西方语言称中国为China(英语)、Chine(法语)、Sina或其变体,据认为是来自「秦」的音译。 Sino 和Chinese 都表示「中国的」的意思。

SINO的含义是“东方”、“东方的”,是和”CHINA“类似的含义,并发展出“SINOLOGY”,即“东方学”。

SINO是希腊语中表示中国的称谓,法语里Chine和德语里China前头都发类似于“西”的音,它们的共同语源应当是梵语中的cinah,后者来自Qin(秦)。

还有一个希腊语过来的表示中国的形容词,就是Sinaean,这是一个非常褒义的词,词根除表中国外,尚 有“神居住的地方”之意,但是肯定和Sinai西奈山或西奈半岛没有联系。以英语为例(其他西文情况类似),目前所得到一般认可的考证为:古印度语梵文 cina和chinas-希腊语Sinai/Serica-古拉丁语Sinae-后期拉丁语Sinology,但古印度人为何使用cina目前没有定论。 疑为古印度人对东方国家的称呼,目前有多数学者认为指西周的秦国,(1655,Martini.Martin),但也有学者认为指古蒙古部落戎 狄,sino为赤那之地的音译,意思是狼。 古印度典籍最早提到cina是公元前10世纪(有的学者提出是公元前5世纪和公元前15世纪)的印度史诗《摩诃婆罗多》和《罗摩衍那》。


SINO在美传统词典词源释义如下:

源自后期拉丁语[ 中国人 ]
源自希腊语 Sinai
源自阿拉伯语[ 中国 ]
可能源自汉语 秦[ 统一中国的第一个封建王朝( ] 公元前221-206年)


我收集的其他有关于SINO的词目: 甲午战争:Sino-Japanese war
汉藏语言学:Sino-Tibetan Linguistics
中英联合声明:Sino-British Joint Declaration
中美共同防务条约:Sino-American Mutual Defense Treaty

WITH PDN_CTE AS ( SELECT n1.ItemCode, n1.Quantity, n1.Baseatcard, n1.DocEntry, n1.LineNum, n1.objtype, n1.baseEntry, n1.baseLine, n1.basetype, n.NumAtCard FROM SINO_SAP.dbo.OPDN n JOIN SINO_SAP.dbo.PDN1 n1 ON n.DocEntry = n1.DocEntry JOIN SINO_SAP.dbo.OUDP p ON n1.U_Department = p.Name WHERE n.CANCELED = 'n' AND p.Remarks = '经销体系' AND n1.U_SaleContNo = '备货' AND COALESCE ( n.NumAtCard, n1.U_PurContNo ) IS NOT NULL AND n.NumAtCard NOT LIKE '%CFBZ%' AND n.U_UpTransNo IS NULL ), POR_CTE AS ( SELECT n1.ItemCode, n1.Quantity, n1.Baseatcard, n1.DocEntry, n1.LineNum, n1.objtype, n1.baseEntry, n1.baseLine, n1.basetype, n.NumAtCard FROM SINO_SAP.dbo.OPOR n JOIN SINO_SAP.dbo.POR1 n1 ON n.DocEntry = n1.DocEntry JOIN SINO_SAP.dbo.OUDP p ON n1.U_Department = p.Name WHERE n.CANCELED = 'n' AND p.Remarks = '经销体系' AND n1.U_SaleContNo = '备货' AND COALESCE ( n.NumAtCard, n1.U_PurContNo ) IS NOT NULL AND n.NumAtCard NOT LIKE '%CFBZ%' AND n.U_UpTransNo IS NULL ), PQT_CTE AS ( SELECT n1.ItemCode, n1.Quantity, n1.Baseatcard, n1.DocEntry, n1.LineNum, n1.objtype, n1.baseEntry, n1.baseLine, n1.basetype, n.NumAtCard FROM SINO_SAP.dbo.OPQT n JOIN SINO_SAP.dbo.PQT1 n1 ON n.DocEntry = n1.DocEntry JOIN SINO_SAP.dbo.OUDP p ON n1.U_Department = p.Name WHERE n.CANCELED = 'n' AND p.Remarks = '经销体系' AND n1.U_SaleContNo = '备货' AND COALESCE ( n.NumAtCard, n1.U_PurContNo ) IS NOT NULL AND n.NumAtCard NOT LIKE '%CFBZ%' AND n.U_UpTransNo IS NULL ), RPD_CTE AS ( SELECT n1.ItemCode, n1.Quantity, n1.Baseatcard, n1.DocEntry, n1.LineNum, n1.objtype, n1.baseEntry, n1.baseLine, n1.basetype FROM SINO_SAP.dbo.ORPD n JOIN SINO_SAP.dbo.RPD1 n1 ON n.DocEntry = n1.DocEntry JOIN SINO_SAP.dbo.OUDP p ON n1.U_Department = p.Name WHERE n.CANCELED = 'n' AND p.Remarks = '经销体系' AND n1.U_SaleContNo = '备货' AND COALESCE ( n.NumAtCard, n1.U_PurContNo ) IS NOT NULL AND n.NumAtCard NOT LIKE '%CFBZ%' AND n.U_UpTransNo IS NULL ), RPC_CTE AS ( SELECT n1.ItemCode, n1.Quantity, n1.Baseatcard, n1.DocEntry, n1.LineNum, n1.objtype, n1.baseEntry, n1.baseLine, n1.basetype FROM SINO_SAP.dbo.ORPC n JOIN SINO_SAP.dbo.RPC1 n1 ON n.DocEntry = n1.DocEntry JOIN SINO_SAP.dbo.OUDP p ON n1.U_Department = p.Name WHERE n.CANCELED = 'n' AND p.Remarks = '经销体系' AND n1.U_SaleContNo = '备货' AND COALESCE ( n.NumAtCard, n1.U_PurContNo ) IS NOT NULL AND n.NumAtCard NOT LIKE '%CFBZ%' AND n.U_UpTransNo IS NULL ), js as ( SELECT c.DocEntry, c.NumAtCard,c.ItemCode,c.LineNum, c.Quantity 报价单数量, b.Quantity 订单数量,a.Quantity 收货单数量,d.Quantity 退货数量,e.Quantity 贷项数量 FROM PDN_CTE a left JOIN POR_CTE b ON a.baseEntry = b.DocEntry AND a.baseLine = b.LineNum AND a.basetype = b.objtype left JOIN PQT_CTE c ON b.baseEntry = c.DocEntry AND b.baseLine = c.LineNum AND b.basetype = c.objtype left JOIN RPD_CTE d ON d.baseEntry = a.DocEntry AND d.baseLine = a.LineNum AND d.basetype = a.objtype left JOIN RPC_CTE e ON e.baseEntry = d.DocEntry AND e.baseLine = d.LineNum AND e.basetype = d.objtype WHERE c.DocEntry IS NOT NULL ) SELECT *,COALESCE(报价单数量, 0)-COALESCE(收货单数量, 0)+COALESCE(退货数量, 0)+COALESCE(贷项数量, 0) 在途数量 from js 依据上述代码写一个存储过程,完成数据的更新,将到货数量更新到 PQT1 的U_ArrQty字段,在途数量写在 U_QadQty 字段,要注意行号 js的linenum是多少 就要写在pqt1的多少行,代码的意思就是 SELECT U_QadQty,U_ArrQty from PQT1 where docentry = js.DocEntry and linenum = js.LineNum
08-14
– Active: 1743054312921@@192.168.0.229@1433@SINO_SAP – Active: 1753929430775@@192.168.3.1@3306@mysql CREATE PROCEDURE ZY_P_CustomerPhone AS BEGIN SET NOCOUNT ON; IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ZY_TB_CustomerPhone]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ZY_TB_CustomerPhone]( [CardCode] nvarchar(50) NOT NULL, [CardName] nvarchar(255) NULL, [Name] nvarchar(255) NULL, [Telephone] nvarchar(20) NOT NULL PRIMARY KEY ); END ELSE BEGIN TRUNCATE TABLE [dbo].[ZY_TB_CustomerPhone]; END; -- 组合所有客户电话数据 WITH CombinedResults AS ( -- OCPR SELECT o.cardcode AS CardCode, o.cardname AS CardName, a.Name, a.Telephone FROM OCRD o LEFT JOIN ( SELECT CardCode, Name, TRIM(tel1) AS Telephone FROM OCPR WHERE NULLIF(TRIM(tel1), '') IS NOT NULL UNION SELECT CardCode, Name, TRIM(tel2) AS Telephone FROM OCPR WHERE NULLIF(TRIM(tel2), '') IS NOT NULL ) a ON o.cardcode = a.cardcode UNION ALL -- ORDR SELECT o."CardCode" AS CardCode, o."CardName" AS CardName, o."U_consignee" AS Name, o."U_shtel" AS Telephone FROM SINO_SAP.dbo."ORDR" o LEFT JOIN SINO_SAP.dbo."RDR1" r ON o."DocEntry" = r."DocEntry" AND r."LineStatus" = 'o' WHERE o."CANCELED" = 'n' AND o."U_shtel" IS NOT NULL UNION ALL -- ODLN SELECT o."CardCode" AS CardCode, o."CardName" AS CardName, o."U_consignee" AS Name, o."U_shtel" AS Telephone FROM SINO_SAP.dbo."ODLN" o LEFT JOIN SINO_SAP.dbo."RDR1" r ON o."DocEntry" = r."DocEntry" AND r."LineStatus" = 'o' WHERE o."CANCELED" = 'n' AND o."U_shtel" IS NOT NULL ), SplitPhones AS ( SELECT CardCode, CardName, Name, CleanedPhone = CASE WHEN ProcessedPhone LIKE '1%' THEN LEFT(ProcessedPhone, 11) WHEN ProcessedPhone LIKE '01%' OR ProcessedPhone LIKE '02%' THEN LEFT(ProcessedPhone, 11) WHEN ProcessedPhone LIKE '03%' OR ProcessedPhone LIKE '04%' OR ProcessedPhone LIKE '05%' OR ProcessedPhone LIKE '06%' OR ProcessedPhone LIKE '07%' OR ProcessedPhone LIKE '08%' OR ProcessedPhone LIKE '09%' THEN LEFT(ProcessedPhone, 12) ELSE ProcessedPhone END FROM ( SELECT CardCode, CardName, Name, ProcessedPhone = CASE WHEN Cleansed LIKE '86%' THEN STUFF(Cleansed, 1, 2, '') WHEN Cleansed LIKE '00%' THEN '' ELSE Cleansed END FROM ( SELECT CardCode, CardName, Name, Cleansed = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( LTRIM(RTRIM(value)), ' ', ''), '-', ''), '(', ''), ')', ''), '.', ''), ',', ''), ';', ''), ':', ''), '+', '') FROM CombinedResults CROSS APPLY ( SELECT value FROM STRING_SPLIT( REPLACE(REPLACE(REPLACE(REPLACE( Telephone, ',', ';'), -- 处理逗号 ' ', ';'), -- 处理空格 '/', ';'), -- 处理斜杠 '、', ';'), -- 处理顿号 ';' ) WHERE LTRIM(RTRIM(value)) <> '' ) AS SplitValues WHERE Telephone IS NOT NULL AND Name IS NOT NULL -- 优化汉字检测逻辑 AND LTRIM(RTRIM(value)) NOT LIKE N'%[吖-座]%' AND LTRIM(RTRIM(value)) NOT LIKE N'%[一-鿕㐀-䶿豈-﫿]%' ) AS FirstPass ) AS SecondPass WHERE ProcessedPhone <> '' ), ValidPhones AS ( SELECT CardCode, CardName, Name, CleanedPhone = CASE WHEN CleanedPhone LIKE '00%' AND LEN(CleanedPhone) > 4 THEN CleanedPhone WHEN CleanedPhone LIKE '0%' AND LEN(CleanedPhone) > 8 THEN CleanedPhone ELSE CleanedPhone END FROM SplitPhones WHERE LEN(CleanedPhone) BETWEEN 8 AND 20 AND CleanedPhone NOT LIKE '%[^0-9]%' AND TRY_CAST(CleanedPhone AS BIGINT) IS NOT NULL -- 防止整数溢出 ), RankedResults AS ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY Name, CleanedPhone ORDER BY CardCode, CardName ) AS rn FROM ValidPhones ) INSERT INTO [dbo].[ZY_TB_CustomerPhone] ( CardCode, CardName, Name, Telephone ) SELECT FinalRanked.CardCode, FinalRanked.CardName, Name, CleanedPhone AS Telephone FROM ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY CleanedPhone ORDER BY CardCode, Name ) AS PhoneRank FROM RankedResults WHERE rn = 1 ) AS FinalRanked LEFT JOIN OCRD on FinalRanked.CardCode = OCRD.CardCode WHERE PhoneRank = 1 and OCRD.[frozenFor] ='N'; PRINT '成功更新'; END 修改代码 以 1 开头 → 截取前11位 满足正常手机号的格式 固话:以 01/ 02 开头 → 去除前3位以后,截取后续的8位 特殊号码:以 03- 09 开头 → 去除前4位以后,截取后续的8位
08-15
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值