SQL Server

SQL Server Temp Table create query Delete CREATE TABLE Temptablename ( ID int identity (1,1) not NULL, A1 varchar (50), A2 varchar (50), A3 varchar (50), Primary key (ID)--defines a primary key with an ID of temporary table #tmp )

1) TRUNCATE TABLE partition instead of full tableCREATE TABLEdbo. Truncatepartitiontest (PrtcolINT, Col2NVARCHAR( -)) on [myPS1](Prtcol)GOINSERTdbo. TruncatepartitiontestVALUES(1,'AAA'), ( One,'AAA'), ( -,'AAA'), (101,'AAA')GO--TRUNCATE partitions 1

Installing FreeidsOfficial website: wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.18.tar.gz1.1, to download the directory decompression tar xvf freetds-1.00.18.tar.gz1.2, CD freetds-1.00.18 (i currently download the version is 1.00.18)1.

1. Check the database space usage to see which tables are consuming larger disk spaceExecute the following statement:SelectO.name, SUM (p.reserved_page_count) asReserved_page_count, SUM (p.used_page_count) asUsed_page_count, SUM ( CaseWhen

1. Create a new database and right click on "New Database ...."2, set the database name, the initial database size, if you want to configure database optimization, you can consider the initial size and log size, click Add installation Complete, that

Configuration SQL Server MirrorThe first step is to check the underlying environmentbecause in a non-domain environment, so the need to do a lot more checks, following the demo environment, test the following conditions:Windows account. whether the

OriginalThe concept of an indexPurpose of the IndexOur data query and processing speed has become a measure of the success of the application system standards, and the use of indexes to speed up data processing speed is often the most commonly used

For an overview of always on, here's not much to say, you need to see Microsoft's official website: https://technet.microsoft.com/zh-cn/library/ff877884 (v=sql.110). aspxLet's start by introducing the machines used in your environment.

How the database uses tables when storing data: Columns are called fields in the database Rows are called records in the database Data type: Character data type: char, varchar, etc. Date Time Data: datetime, etc. Numeric type:

As you can see, policy Management contains three nodes: policies, conditions, and aspects.Aspect is the object that the policy applies to, including: Server, table, trigger, view, stored procedure ... These aspects are all system-defined, and are

Let's take a look at the example below:Table tablesField 1 Field 2ID Name1 A2 b3 C4 C5 bThe library structure is probably like this, this is just a simple example, the actual situation will be much more complex.For example, if I want to use a single

https://www.microsoft.com/en-us/download/details.aspx?id=20098Download the last one, and then this tool can download the DLL extension, select a blank folder can be, phpstudy default is the extension of the link SQL Server.One of the most important

Article guideSQL implementation where in queryUsing CHARINDEX or like to implement where in parameterizationImplementing the Where in parameterization using exec dynamic execution of SQLGenerate a parameter for each parameter implement where in

SQL Server Reporting Service (SSRS) My first SSRS example uses table for simple data display by default, and sometimes we need to group the list by a field for more intuitive data display. For a clearer explanation, I made a new table (already

Early know SQL Server comes with the reporting tools SSRS, but has not been used, recently finally need to work in a show of skill, so I specifically in accordance with their own understanding to do the following summary:1. Install the SOFTWARE

The cursor is evil!In a relational database, our thinking about queries is set-oriented. The cursor breaks this rule, and the cursor makes us think in a progressive way. For developers of Class C, this way of thinking will be more comfortable.The

Sometimes, in order for the application to run faster, all that is done is to make minor adjustments here or there. But the key is to determine how to adjust! Sooner or later you'll encounter this scenario: the SQL query in your application doesn't

Objective Why would you want to back up? The reason is simple-to restore/restore. Of course, if you do not back up, you can also recover the lost files through disk recovery, but SQL Server is very angry, the consequences are serious. Then

SQLSERVER2012 installed after the necessary security reinforcement, or very much DBA information can be read after the ordinary account login.--use [Master]--go--deny View SERVER state to [public]--go--use] [Master]--go--deny View any DATABASE to

The DATEDIFF () function returns the number of days between two dates.SyntaxThe startdate AND enddate parameters of DATEDIFF (datepart, startdate, enddate) are valid date expressions.Use the following SELECT statement: The code is as follows:Copy