SQL Server

Sometimes we use the bulk operation to split the string, but SQL Server does not have the Split function, so you have to implement it yourself. There's nothing to say, just take it with the friends you need.SETAnsi_nulls onGOSETQuoted_identifier

0 Feb 2006 4:26pm CONVERT (CHAR), Current_timestamp, 0) 1 02/22/06 CONVERT (CHAR (8), Current_timestamp, 1) 2 06.02.22 CONVERT (CHAR (8), Current_timestamp, 2) 3 22/02/06

-----------------T_sql--------------------------------1. Global variable-------------------------------------Print @ @identity --last-inserted identity valuePrint @ @language --language currently in usePrint @ @version --Version numberPrint @

5.  Configure Quorum5.1 Create a shared folder and make sure that the SQL Service account, administrator, cluster account, and SQL computer objects have full control over the shared folder ( Note that this shared folder is not allowed to be created

As needed, change SQL2008 single Windows authentication to mixed-mode authentication. Make a memo here.Steps:1. Enter SQL2008 with Windows authentication, and in Object Explorer, right-click the root directory:Select Properties in the right-click

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)

Getting Started with databases :　　　The development of database: The stage of-----file Management Stage-----Database system in the stage of human managementThe composition of the Data system:1. Database (data) DB2. Data management system (software)

--simple crud for a single tableSelect * fromQ_user--Querying all ColumnsSelectUid,uname,upwd fromQ_user--Query The specified column can specify conditions with whereSelectUid* fromQ_userDeleteQ_user--all data for this table will be deleted (with

This time using the os+sql mirror to restore the system after the installation of CRM 2015, the main process is to install IIS/AD,SSRS, CRM2015. SSRS is not fully installed in your own SQL and needs to be configured.It all went well, and finally,

The recent project boss asked for SQL Server, but the project's database was not complicated by the local demo, so decided to try VisualStudio2013 built-in SQL Server. The understanding of this thing is not much, and then the project to learn less

SELECTvarchar(Ten: 57AMSELECTvarchar(CONVERT(Ten0), GETDATE (), 2): 11.05.16SELECTvarchar(CONVERT(Ten0), GETDATE (), 4): 16.05.11SELECTvarchar(CONVERT(Ten0), GETDATE (), 6): 16 05 11SELECTvarchar(CONVERT(Ten0), GETDATE (), 8):CONVERT(Ten0), GETDATE (

Second, the Complete lock compatibility matrix (see)The right is the code description: see.Third, the following table lists the resources that the database engine can lock. Name Resources Abbreviation Coding How the

When we use SQL server databases , we often create primary keys and indexes , so what is the difference between a primary key and an index? In this paper, we mainly introduce the difference between primary key and index.The difference between a

SQL type C # types Bit bool tinyint Byte smallint Short Int Int bigint Long Real Float Float

SQL Server replication Error article highlightsTo make it easier for you to solve problems when errors occur during database replicationI collected an article about SQL Server related replication error resolutionThe process could not execute '

Method 1:Applies to SQL Server 2000/2005SELECT TOP Page Size *From table1WHERE ID not in ( SELECT TOP Page Size * (pages-1) ID from table1 ORDER by ID )ORDER by IDMethod 2:Applies to SQL Server 2000/2005SELECT TOP Page

Why are updatable subscriptions conflicting?Updatable subscriptions, when the upgrade adds a field, typically increases in the publisher's publication database, and after the table is added, the publication is automatically synchronized to the

In SQL Server, encryption is hierarchical, and each upper layer provides protection.650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat

The Publish subscription feature has been available since SQL 2005The configuration method can be consulted: http://blog.csdn.net/wanmdb/article/details/7515277Problems encountered:1.If the agent fails to start, perform the configuration2.SQL server2

I. Definition and assignment of variablesDECLARE @ variable name typeSET @ variable name = valueegCheck the car table with the name of the BMW two wordsDECLARE @name varchar (20)Set @name = ' BMW 'SELECT * from car where Name like '% ' [email