SQL Server

Dual database Operation tips://xxxxxxxxxxxxx first step, interconnect xxxxxxxxxxxxxxxexec master.dbo.sp_addlinkedserver @server = N ' linkedserver_211 ', @srvproduct =n ' sqlserver2008r2 ', @provider =n ' SQLNCLI10 ', @datasrc =n ' 211.xxxxxxx '

1. Get the number of nodes under a node in the XML typeDECLARE @xmlXMLSET @xml = ' ';SELECT @xml. Value ('count (/parameters/parameter)','int')2. Turn XML into tableDECLARE @xmlXMLSET @xml = ' ';SELECTT.c.query ('.'). Value ('(//@name)

1. Define Stored procedures-- =============================================--Defining stored procedures-- =============================================CREATE PROCEDURE [dbo]. [Updatet]-Define XML parameters@xml XMLAsBEGINSET NOCOUNT on;DECLARE

----------------------------Summary Data-----------------------------aggregation functions are used to summarize data. A variety of methods to return the desired results, efficient and quick to obtain results;--37. Returns the average price of all

The 1th Chapter Basic Management1.1 Security and Permissions1. Login nameLog on to the DB instance. Only the database instance can be logged on, but the login does not necessarily have access to the database.a valid login account only indicates

Grammar Sp_addextendedproperty [@name =] {' property_name '} [, [@value =] {' Value '} [, [@level0type =] {' L Evel0_object_type '} , [@level0name =] {' Level0_object_name '}

Bit: integer, value range [0,1,null], for accessing Boolean valuesTinyint: integer, value range [0~256]smallint: integer, value range [ -215~215]int: integral type, range of values [ -231~231]Decimal: Exact numeric type, example: Decimal (8,4);

2. Installing database Features2.1 in SQL01 Server Manager, follow the wizard to install the. NET Framework 3.5, after successful installation as follows:650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/2B/wKiom1X21RrgC0e3AAIYeU-PIr8832

4.  Create a cluster4.1 in SQL01 Server Manager, click "Tools"-"Failover Cluster Manager"650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/28/wKioL1X227rhPwg_AANfLq6I7CA617.jpg "title=" 1.png " alt= "Wkiol1x227rhpwg_aanflq6i7ca617.jpg"/>4

7.  New Database7.1 in SQL01 server open SQL Studio connect to SQL01, right-select "New Database"650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/73/2C/wKiom1X23peiNRjpAAFzCzfBM0k017.jpg "title=" 1. PNG "alt=" wkiom1x23peinrjpaafzczfbm0k017

DECLARE @xml XMLDECLARE @propertyName varchar (50)declare @str nvarchar (max)Set @propertyName = ' S_code 'Set @xml = ' testadmin 'SELECT @str[email protected](' (/root/row[@propertyName =sql:variable ("@propertyName")]) [1] ', ' nvarchar (max)

DBCC (Database base consistency Checker, consistency checker for databases) commands are used to verify database integrity, find errors, and analyze system usage. 1.DBCC checkallocUse the DBCC checkalloc command to detect the consistency of the

Recently in the activity, need to use the stored procedures, found on the internet to feel the use of triggers better, and share the hope for you to be useful.A trigger is a special type of stored procedure that differs from the stored procedure we

A custom stored procedure is called in a SQL Server custom function, and after executing this function, the following prompt is issued: "Only functions and extended stored procedures can be executed from within the function."Reason: The function can

--creating a stored procedure alter PROCEDURE DBO.ABCD @inp int, --input parameter @oup int output --output parameter as BEGIN declare @num int --Define variable declare @numer int --Define variable SELECT @num = count

Use SqlServer CTE to recursively query the processing tree, graph, and hierarchy, and sqlservercte CTE (Common Table Expressions) is available in Versions later than SQL Server 2005. The specified temporary naming result set, which is called CTE.

ASP and SQL Server: How to build Web firewall and aspsqlserver ASP is the middle layer of the Client/Server structure on the Web. Although it is written in a scripting language (Java Script, VB Script, etc.), the program code runs on the server,

Asynchronous SQL database Encapsulation Introduction I have been searching for a simple and effective library that provides an Asynchronous Method to prevent deadlocks while simplifying database-related programming. Most of the databases I found

Summarizes the methods for optimizing SQL Execution progress and SQL Execution progress. In this article, I will discuss with you how to optimize the SQL Execution progress. Clustered index Scan SELECT * FROM C_SY_Ownedstorm Clustered index scan is

Several methods of querying by SQL page and several methods of querying by SQL page There are many pages for SQL statements on the Internet. I will post some pages and summarize the pages I have known to facilitate future reference. 1. Create a test