SQL Server

Unable to manage the unit created by MMC. After searching online, the solution is as follows: 1. [start] --> [run] Regedit press ENTER2. Find the following registry subkeys:HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ 80 \ tools \

Encryption of stored procedures and stored functions: With Encryption Create procedure DBO. sp_xml_main @ Table_name nvarchar (260) = '', @ Dirname nvarchar (20) ='' With Encryption As Begin .................... End Go

When purchasing Windows Server and SQL Server, the keyword "Number of users" will be increased. At first, many people, including me, thought they could be installed on computers with limited number of users. This is actually wrong. It is also

Data operations between databases on different servers -- Create linked server Exec Sp_addmediaserver ' Itsv ' , ' ' , ' Sqloledb ' , ' Remote Server name or IP address ' Exec Sp_add1_srvlogin ' Itsv ' , ' False '

Sometimes we need to clear the list of Connected Server names in SQL Server. Then we searched through the network and found a solution: delete the following files: C: \ Documents ents and Settings \ XXX \ Application Data \ Microsoft SQL Server \ 10

SQL 2005 system service cannot be started. error message : title: connect to the server -------------------------- cannot connect to sharesun/ SQL 2005. ------------------------------ additional information: An error occurred while

The default datetime format of the Chinese version of SQL Server is yyyy-mm-dd thh: mm: Ss. Mmm.For example:Select getdate ()11:06:08. 177I sorted out the date format conversion methods that may be frequently used in SQL Server:Example:Select

There are two Repeated Records. One is a completely repeated record, that is, records with all fields being repeated, and the other is records with duplicate key fields, such as duplicate name fields, other fields are not necessarily repeated or can

This evening, my brother encountered a strange problem. The ID of a table can be displayed, but other columns cannot be queried, for example:   My first response is that billcode is of the char type and should be followed by a space. So let

We all know that many database software provide the automatic numbering function for tables, which is very useful for some table functions and can reduce unnecessary work, I recently used SQL Server, So I encountered some problems in this process,

Precautions for SQL Server If you are in charge of a SQL Server-based project, or you have just been in touch with SQL Server, you may have to face some database performance problems, this articleArticleIt will provide you with some useful

Reposted from [http://tech.ddvip.com/2009-01/12310522771020.4.html] SQL2000 cannot remove this user because the selected user has an object After the SQL database is moved from one server to another, or the database is backed up, the SQL Server

If you need to regularly execute a stored procedure or SQL statements of less than 3200 characters in SQL Server, You can use "manage"> "SQL Server proxy"> "job.1. Choose "manage"> "SQL Server proxy"> "job" (right-click)> "create job"> 2. Create

SQL Server INDEX OPTIMIZATION Clustered Index , The data stored in the table is stored in the order of indexes. , Higher retrieval efficiency than normal indexes , However, data is added / Modify / The deletion has a large impact.

You can use the BCP tool to export objects in the database as data files. The specific operations are as follows: 1. Contains query statements Exec master .. xp_mongoshell 'bcp "select * from database. DBO. tablename" queryout "C: \ a.txt

I,Previously, I used to compare two datetime data types, A and B, to determine whether the same year and the same month are the same method: Where   Year () =   Year (B) And   Month () =   Month (B) And   Day ()

Table creation: Create Table [dB. DBO]. tablename (Stud_id int constraint constraintname1 not null primary key, Name nvarchar (5) not null, Birthday datetime, Gender nchar (1 ), Telcode char (12 ), Zipcode char (6) constraint

SQL Server provides a special data type: image, which is a type that contains binary data. The following example shows how to put text or photos in the database. In this article, we will see how to store and read images in SQL Server. 1. Create a

I. Why should I introduce locks? When multiple users concurrently perform database operations, the following data inconsistency occurs: ◆ Update loss A and B read and modify the same data. The Modification result of one user destroys the

　1. A trigger is a special stored procedure. It cannot be explicitly called. Instead, it is automatically activated when a record is inserted, updated, or deleted into the table.Therefore, triggers can be used to implement complex integrity