SQL Server

Title, as follows:This error has occurred, I directly click OK, continue to install, the final installation failed.The error is that the. NET Framework 3.5 is not installed and has to download the. NET Framework 3.5 installation, but it can also be

Approximate steps:A. Create an auditB. to create a database-level audit specification - creation, deletion and modification of monitoring database objectsC. Test Auditing features - Create, modify, and delete database objectsD. Use the log file

One: Understanding CursorsCursor It enables the user to access the result set returned by SQL Server on a row-by-line basis.One of the main reasons for using cursors is to convert the set operation to a single record processing mode.When data is

Execute in Query Analyzer: Select rand (), you can see that the result is similar to a random decimal: 0.36361513486289558, a decimal like this is used in the actual application is not much, generally to take random numbers will take random integers.

Date-time functions　　1. Get the current date getdateThe GETDATE () function returns the date and time of the computer on which the current SQL Server servers are located, in the format of the datetime data type. Its syntax format is GETDATE (). The

One, Time functionWhen you use stored procedures, SQL functions, you encounter some processing of time. such as the acquisition of time and the addition and subtraction. In this case, the SQL comes with the time function. Below I list these

Pivot is used to rotate column values to column names (row to column), and SQL Server 2000 can be implemented with an aggregate function with a case statementThe general syntax for pivot is: Pivot (aggregate function (column) for column in (...)) As

If you set a column to identity when you create a new table, you can not display the specified value when inserting the data, and SQL Server automatically populates the value of that column.Create Table TblPerson1 ( IntIdentity(1,1Primarykey not

Source: Microsoft SQL Server Analysis Service Data mining technologyThe latest data mining capabilities in Microsoft SSAs are required in a project, although the data mining capabilities in SSAS have never been understood in the past when projects

1. Deadlock PrincipleAccording to the definition in the operating system: A deadlock is a permanent wait state in which each process in a set of processes occupies a resource that is not freed, but is placed in a form that is not freed by other

SQL Server Enterprise Edition is supported for online index rebuilds. So how does an online index rebuild work and how does it affect our queries?Since it is online, SQL Server keeps the existing index available to the user, which means that it does

This article was reproduced from the blog http://www.cnblogs.com/lyhabc/archive/2013/06/10/3130856.html of the BirchQueries on SQL Server database transaction logsI can't touch SQL Server.Experimental environment: SQLSERVER2005 SP4,WINDOWS7I was not

SQL Server to the current version 2014 has three functions that are used to convert the data format. Although both the cast and convert functions are already in the previous version to do this thing. The problem is that once the conversion to the

The time format normally deposited in the database is yyyy-mm-ddhh:mm:ss if you want to convert to yyyy-mm-dd Short date format. You can use the CONVERT function. The following is a declaration of the CONVERT function in SQL Server Help:Using

SQL Server Basics(1) Create a databaseThere are two ways to create a database, manually create and write SQL script creation, where I use a script to create a database called TSQLFundamentals2008. The script is as follows:View CodeWhile inserting

SQL Server Connection Problem case resolution (1) reprinted from: Http://blogs.msdn.com/b/apgcdsd/archive/2015/04/27/sql.aspx?CommentPosted=true#commentmessageMicrosoft Network Monitor (Netmon) is a Web protocol data analysis tool released by

This article turns from http://543925535.blog.51cto.com/639838/1427529In the daily SQL maintenance, there are many tasks that need to be repeated periodically, we are not likely to do manual operations, such as backup jobs, rebuild maintenance index,

In order to help users solve the "SQL Server Setup cannot verify the service" related issues, China Learning network through the internet on the "SQL Server Setup can not verify the service" related to the solution is organized, user detailed

Are basic examples, more reference official documentation:1. Transact-SQL functions2. Database key3. Certificates4. Asymmetric key5. Symmetric key--drop Table Enrypttestcreate table enrypttest (ID int not null primary key,enryptdata nvarchar (a),)

Because of XX reason, SQL Server to downgrade, so with the following ....A script can be generated directly from SQL Server's own tools, as follows:1. Open Microsoft SQL Server managenment Studio2. Right-click the database >> tasks >> Generate