SQL Server

Database administrators familiar with SQL SERVER 2000 know that their DTS can import exports of data, but we can also use Transact-SQL statements for import and export operations. In Transact-SQL statements, we mainly use the OPENDATASOURCE function,

The concept of stored procedures Stored procedure procedure is a set of SQL statements that are compiled and stored in a database to complete a specific function, and are executed by specifying the name of the stored procedure and giving the

When SQL Server 2008 was not logged in before, it was always changed by "Computer Management" → "SQL Server service", "SQL Server (MSSQLSERVER)." But now the problem has become the SQL Server service can not open the situation, is very depressing.

After installing SQL Server 2005, the sample database for MS was not found. Northwind later view the installation CD found SQL Server 2005 species only Adventurework and adventureworkdw these two sample databases To Ms Official station to find a

The simplest definition of what is a user right may be, "What users can do and what they can't do." "Here, the simple definition is pretty good. user permissions are grouped into 3 categories： L login Permission; • access to specific databases; L

Today's use of the era of interconnected overseas space, SQL 2008 Unlimited space size, opened the account, the use of SQL Server Management Studio 2008 to connect the database, you can link, but cannot view their own database, click the database,

Certificates and asymmetric keys encrypt data using the internal public key at the database level, and data is decrypted using a database-level internal private key. Symmetric keys are relatively simple, and they contain a key for both encryption

Accidentally saw a friend wrote an article "The Table data batch generation INSERT statement implementation of the stored procedure." I look at the text of the two storage code, I feel that two are not satisfied, are generated by the single mode of

FileStream is a new feature in SQL Server 2008 that allows large object data to be stored as separate files, rather than saving all data to a data file as usual. In the past, there were two ways to manage the files of a business system, one of which

I tried some of the methods offered online, and finally I solved some problems with SQL. 1 Select the problematic database in the Query Analyzer and enter:Exec sp_configure ' allow updates ', 1--Allows the system tables to be updated. Reconfigure

Then let some non-Windows necessary services such as SQL Server boot up, and then use the batch process to start up: First, set the SQL Server-related service startup type in the Control Panel-> Administration Tools-> Service to manual (services at

Get Server name: Select SERVERPROPERTY (' machinename ') SELECT @ @SERVERNAME Select HOST_NAME () To obtain an IP address, you can use xp_cmdshell to execute the ipconfig command: However, in many cases, because the

The above article mentioned win Performance Monitor is a necessary tool for monitoring database performance, Next I will give you some common monitoring indicators, in fact, is nothing more than disk, CPU, memory and other hardware operating

A stored procedure is one or more SQL commands that are stored as executable objects in the database.Definitions are always abstract. A stored procedure is actually a set of SQL statements that can do something, except that the set of statements is

What is a trace tag? For DBAs, mastering trace flag is one of the prerequisites for becoming a master of SQL Server, and in most cases, trace flag is just a sword-walking slant, not necessary, but in many cases, using these tags will allow you to

Error behavior: Microsoft OLE DB Provider for SQL Server error ' 80040e2f ' cannot insert value NULL into column ' id ', table ' Web.dbo.dingdan '; column does not allow null values. INSERT failed. /untitled-2.asp, line 115 Reason Analysis:

Before we had to export the data from one table to a script, we would be able to export the data script by looking for a script to export the data on the web and then run it. A new feature is now added to Management Studio in SQL Server 2008, which

Because a primary key can uniquely identify a row of records, you can ensure that no confusedly errors occur when you perform data updates and deletions. Of course, other fields can help us eliminate sharing conflicts when we do these things, but

Catalogue1. SQL Server Publishing subscription error collection1.1. Message: Script for table "dbo. " Table "failed.1.1.1. Error Messages1.1.2. Handling Methods1.2. because of operating system error 3, the process cannot read the file

· If only the inserted table has data, the current operation is insert;· When both the inserted and deleted tables have data, the current operation is update;· The current operation is delete only when the deleted table has data.CREATE TRIGGER The