sql server cross apply xml

The Code is as follows: The structure of the landundertake table is as follows: The structure of the table appraiser is as follows: Access code:Copy codeThe Code is as follows:TRANSFORM First (Landundertake. valuerId) AS valuerId FirstSELECT Appraiser. quarterId, Landundertake. landCodeFROM Landundertake inner join Appraiser ON (Landundertake. valuerId = Appraiser. valuerID) AND (Landundertake. quarterId = Appraiser. quarterId)Group by Appraiser. quarterId, Landundertake. landCodePIVOT Landund

--create a linked serverexecsp_addlinkedserver'JX3XXIEDNR3UCIDF',' ','SQLOLEDB','JX3XXIEDNR3UCIDF' execsp_addlinkedsrvlogin'JX3XXIEDNR3UCIDF','false',NULL,'SA','Aa12345' --IncreaseINSERT intoJx3xxiednr3ucid.yyg.dbo.T_Tabel_a ([Name])VALUES('Zhang Hui')--DeleteDELETEJx3xxiednr3ucid.yyg.dbo.T_Tabel_aWHERE [Name] = 'Zhang Hui' --ChangeUPDATEJx3xxiednr3ucid.yyg.dbo.T_Tabel_aSET [Name] = 'Chen Qiu Water' WHEREId= 4--CheckSELECT * fromjx3xxiednr3ucid.yyg.dbo.T_Tabel_a--remove a linked serverex

This article gives an SQL statement to display the query between different databases on the same server, noting that the current connected user has permission to two libraries The complete expression of an object in SQL Server SQL statement is: [Databaseserver]. [DatabaseNa

StatementSELECT * from database a.dbo. Table A, database b.dbo. Table b b WHERE A.field=b.field"DBO" can be omitted asSELECT * from Database A. Table A, database B.. Table b b WHERE A.field=b.fieldSQL Server database:--This is an IP or hostname that maps a remote database exec sp_addlinkedserver ' remote database ', N ' SQL Servers '--this is logged in to the remote database exec sp_ Addlinkedsrvlogin ' rem

Source: http://www.cnblogs.com/doosmile/archive/2012/03/16/2400646.html--Connect remote SQL or insert data with OPENROWSET--if it's just temporary access, you can use OPENROWSET directly--query ExampleSELECT * FROM OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password, database name. dbo. Table name)You need to enable AD HOC distributed for

Server|xml For project requirements, to export data from one server's SQL and then import it to another SQL Server, project requirements cannot be synchronized with simple data, so you want to use XML data format processing. On th

Label: Translated from: http://blog.csdn.net/hliq5399/article/details/8315373 Today the XML fields for SQL Server are used, first the XML fields in this project are stored in the ntext field, so the first operation ntext is converted to XML The following excerpt from Http:/

In the relational database management system, the relationship between data does not have to be determined when a table is created, and all information about an object is often stored in a table. When retrieving data, you can use the join operation to query information about different entities in multiple tables. Connection operations bring great flexibility to users. They can add new data types at any time. Create new tables for different entities and then query them through connections. The co

(1) Cross join is what we call the Cartesian product. Query the number of records that satisfy both tables, A (3 Records), B (9 Records), A*b (27 records).For example: An employee table (hr.employees) and a freight company (sales.shippers) table make a cross-connection.1 SELECT * FROM hr.employees;2 select * from Sales.shippers;After the cross-connect, 27 recor

Tags: class color SQL arch null sel cross font divData preparation:Create TableT1 (Avarchar(Ten) not NULL, Bvarchar(Ten) not NULL, Ctinyint not NULL);Create TableT2 (Bvarchar(Ten) not NULL, Etinyint not NULL);Insert intoT1Values('A1','B1',5),('A1','B2',6),('A2','B3',8),('A2','B4', A);Insert intoT2Values('B1',3),('B2',7),('B3',Ten),('B3',2),('b5',2);Select * fromT1;Select * fromT2;Results:1 A B C2 ----

Solution 5 use xml Parameters If you are not familiar with SQL server xml type parameters, you must first understand the XQuery concept. Here, an XQuery is a language used to search for and extract elements and attributes from XML documents, simply put, the language used to

Data operations between different server databases--Create a linked serverexec sp_addlinkedserver ' itsv ', ' ', ' SQLOLEDB ', ' Remote server name or IP address 'exec sp_addlinkedsrvlogin ' itsv ', ' false ', NULL, ' username ', ' password '--query ExampleSELECT * from ITSV. Database name. dbo. Table name--import ExampleSELECT * into table from ITSV. Database name. dbo. Table name--Remove linked

Tags: backing up sql across serversTask: Automatically back up the SQL database on server 1 to server 2, naming format = database name + Month Day + hour.DescriptionServer 2= "192.168.0.22Database name = "book"Shared Folder path: 192.168.0.22\bookSolve:Create a new job in server