SQL Server

The enterprise performs brush data work on the database, and a long statement is expected to succeed or fail at the same time.1. Setting up a test environment/************************************************************ * Code formatted by Softtree

SELECT * from Information_schema.columns WHERE table_name= ' account ' SELECT if A.colorder=1 then d.name Else ' E nd) as table name,--if the table name is the same, return the empty a.colorder as field ordinal, a.name as field name, (case when

To be honest, I've never used an index in a real project, just know that the index is a fairly important technical point, so I've seen a lot of articles about the differences, classifications, pros and cons of indexes, and how to use indexes. But

Reference documentsHttp://database.51cto.com/art/201009/224075.htmBodyTo successfully access data in a SQL Server database, we need two aspects of authorization: Get permission to connect to the SQL Server server; The right to access

SELECTTable name= Case whenA.colorder=1 ThenD.nameElse "' End, table describes= Case whenA.colorder=1 Then IsNull(F.value,"')Else "' End, Field ordinal=a.colorder, field name=a.name, Logo= Case when ColumnProperty(A.id,a.name,'isidentity')=1

First, GROUP byRule 1: Single-value rules, followed by the list after select, must be returned and only one value returned for each grouping.The field specified in select is either to be included in the group by statement, as a basis for grouping,

In the normal development process, in the design of data, often encountered the problem of data type selection, in order to faster, more appropriate to choose the correct data type, so here is a summary. Classification SQL

First, Nested loops-- ------------------Nested Loops-------------------- /* the icon for looping nested connections is also very image, in the above external input (Outer input), here is the clustered index scan. And in the following internal input (

RPM: http://blog.csdn.net/qiaqia609/article/details/41445233 SQL Server Database paging query has been a short board for SQL Server,The first scenario, the simplest and the most common method:The code is as follows: Select Top article WHERE

　　In a lot of data analysis and integration scenarios, we need to understand the database of key scripts or job execution. This time email alert is a good way to notice. This article starts with a zero, step-by-step description of how to use SQL

One, SA permission to execute the command, how to get the results more quickly?There are display bitsDisplay bitIn fact, the key here is not there is no display bit. EXEC master. xp_cmdshell ' systeminfo ' generates a number of rows when the data is

29. Right-click the "Services and Applications" option and select "Configure Service or application" to enter the "High Availability Wizard" interface;650) this.width=650; "src="

Version 655 refers to SQL2008, version 611 refers to the SQL2005, (there is also a version 539 refers to the SQL2000) the landlord's situation is typical from a high version to lower version of the use of the scenario. According to Microsoft's

For example, all of the following are examples of studnet tables:Calculating string LengthsLen () is used to calculate the length of a stringSelect Sname, Len (sname) from studentConvert string to large, lowercaseLower () is used to convert a string

Use the SDE to connect the Postgre database or SQL Server to publish the feature service in two ways:1. Create a geographic database,gdb build a layer and attribute table, and then open the created postgre or SQL Server database in the Arccatalog

Many times, deadlocks are requested by two or more sessions to hold the other session of the lock while holding other session, but there are some special deadlock only by a single session lock triggered, today saw a related article, transported to

1. Enter the database Manager in Windows Authentication mode.2. Right-click the SA and select Properties:In the General tab, re-fill in the Password and confirm the password (changed to a good note). Remove the mandatory password policy.3. Click

CREATE DATABASE TestUse Test--Create User Type tableCREATE TABLE usertype (ID INT not NULL identity (primary key),TypeName VARCHAR (+) DEFAULT NULL,Typedescription VARCHAR (+) DEFAULT NULL,)exec sys.sp_addextendedproperty @name = ' ms_description ',

I've summarized this once. SQL Server deletes the distribution database, which describes how to delete the distribution database. Today, we introduce a special case of deleting distribution,Before that, I didn't know how the replication on this

First, new login name1. Enter the new administrator account name in the text box to the right of the login name;2. In a pair of radio button groups, select SQL Server authentication and enter the login password;3. Tick the Enforce Password policy