老顾请进---> XSL 中xsl:variable 等的用法
你以前回过的帖子
http://topic.csdn.net/u/20080121/17/ec79e414-296d-4937-b3b8-a860335d96b5.html
中
<xsl:for-each select="//company[count(.|key('company_group',./text())[1])=1]">
select 后面的跟我讲解下
谢谢
[最优解释]
你去查下xml sdk里 xsl:key的用法，一下就明白了。
[其他解释]
--Customer为目标表,CustomerStage为原表,当原表匹配目标表时更新，否则插入, 当目标表不匹配原表时删除
MERGE INTO Customer AS TGT
USING dbo.CustomerStage AS SRC
ON TGT.CUSID=SRC.CUSID
WHEN MATCHED THEN
UPDATE SET
TGT.CustomeName=SRC.CustomeName,
TGT.companyname=SRC.companyname
WHEN NOT MATCHED THEN
INSERT (CUSID,CustomeName,companyname)
VALUES (SRC.CUSID,SRC.CustomeName,SRC.companyname)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;
[其他解释]
--OUTPUT CLAUSE
--1 INSERT WITH OUTPUT
IF OBJECT_ID('Rows') IS NOT NULL DROP TABLE ROWS
CREATE TABLE [ROWS](COL INT IDENTITY(1,1),DATACOL VARCHAR(20))
INSERT INTO [ROWS]
OUTPUT inserted.COL,inserted.DATACOL
SELECT COMPANYNAME FROM Customer
--RESULTS
COL DATACOL
----------- --------------------
1 Microsoft
2 Intel
3 alibaba
4 siemens
5 Bank
6 GOOGLE
(6 row(s) affected)
-- DELETE WITH OUTPUT
DELETE FROM [ROWS]
OUTPUT deleted.COL,
deleted.DATACOL
WHERE COL<10
-- UPDATE WITH OUTPUT
UPDATE [ROWS]
SET DATACOLDATACOL=DATACOL+'--'
OUTPUT inserted.COL,
deleted.DATACOL AS OLDDATA,
inserted.DATACOL AS NEWDATA
WHERE COL<11
--RESULTS
COL OLDDATA NEWDATA
----------- -------------------- --------------------
7 Microsoft Microsoft--
8 Intel Intel--
9 alibaba alibaba--
10 siemens siemens--
(4 row(s) affected)
--MERGE WITH OUTPUT
MERGE INTO dbo.Customer AS TGT
USING dbo.CustomerStage AS SRC
ON TGT.CUSID=SRC.CUSID
WHEN MATCHED THEN
UPDATE
SET TGT.CustomeName=SRC.CustomeName,
TGT.companyname=SRC.companyname
WHEN NOT MATCHED THEN
INSERT (cusid,CustomeName,companyname)
VALUES (SRC.cusid,SRC.CustomeName,SRC.companyname)
OUTPUT $ACTION,
INSERTED.CUSID,
DELETED.CustomeName AS OLDCustomeName,
INSERTED.CustomeName AS NEWCustomeName,
DELETED.companyname AS OLDcompanyname,
INSERTED.companyname AS companyname;
$ACTION CUSID OLDCustomeName NEWCustomeName OLDcompanyname companyname
---------- ----------- -------------------- -------------------- -------------------- --------------------
UPDATE 1 guo hu guo hu wicresoft Microsoft
UPDATE 3 jun wen li jun wen li HP alibaba
UPDATE 4 jin hao liu jin hao liu IBM siemens
INSERT 5 NULL cheng fan NULL Bank
(4 row(s) affected)
--1Date and Time Types
--following the queryies that it shows different accuracy
select cast('02/07/2007' as datetime)
--The result:2007-02-07 00:00:00.000,Accuracy:millisecond
select cast('02/07/2007' as datetime2)
--The result:2007-02-07 00:00:00.0000000,Accuracy:100 naonesecond
select cast('02/07/2007' as date)
--The result:2007-02-07,Accuracy:1 day
select cast('02/07/2007' as smalldatetime)
--The result:2007-02-07 00:00:00,Accuracy:1 minute
set language british;
select cast('02/07/2007' as datetime)
set language us_english
select cast('02/07/2007' as datetime)
if OBJECT_ID('customer') is not null
drop table Customer
go
create table Customer
(
cusid int not null,
CustomeName varchar(20),
companyname varchar(20),
constraint PK_cusid primary key (cusid)
)
insert into Customer(cusid,CustomeName,companyname)
select 1,'guo hu','wicresoft'
union all
select 2,'lei hu','Intel'
union all
select 3,'jun wen li','HP'
union all
select 4,'jin hao liu','IBM'
go
if OBJECT_ID('CustomerStage') is not null
drop table CustomerStage
go
create table CustomerStage
(
cusid int not null,
CustomeName varchar(20),
companyname varchar(20),
constraint PK_cusstageid primary key (cusid)
)
insert into CustomerStage(cusid,CustomeName,companyname)
select 1,'guo hu','Microsoft'
union all
select 3,'jun wen li','alibaba'
union all
select 4,'jin hao liu','siemens'
union all
select 5,'cheng fan','Bank'
go
--Customer为目标表,CustomerStage为原表,当cusid匹配时,更新Customer中的信息,否则插入
MERGE INTO Customer AS TGT
USING CustomerStage AS SCR
ON TGT.cusid=SCR.cusid
WHEN MATCHED THEN
UPDATE
SET TGT.CustomeName=SCR.CustomeName,
TGT.companyname=SCR.companyname
WHEN NOT MATCHED THEN
INSERT (cusid,CustomeName,companyname)
VALUES(SCR.cusid,SCR.CustomeName,SCR.companyname);
--Customer为目标表,CustomerStage为原表,当原表匹配目标表时更新，否则插入, 当目标表不匹配原表时删除
MERGE INTO Customer AS TGT
USING dbo.CustomerStage AS SRC
ON TGT.CUSID=SRC.CUSID
WHEN MATCHED THEN
UPDATE SET
TGT.CustomeName=SRC.CustomeName,
TGT.companyname=SRC.companyname
WHEN NOT MATCHED THEN
INSERT (CUSID,CustomeName,companyname)
VALUES (SRC.CUSID,SRC.CustomeName,SRC.companyname)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;
