SQL Server

Install SQL server in a non-Domain environment. The default Administrator is "machine name \ Administrator ", after being upgraded to a domain controller, because the Windows user "machine name \ Administrator" has been automatically changed to

1. An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: named pipeline provides Program , Error:

Yesterday's blogsql statement: displays the information of all tables in SQL Server. It organizes an SQL statement that displays the information of tables and columns in all databases. Today, I used it as a small tool to export the SQL server2005

SQL inert is too slow, and Excel is too slow. I found the BULK INSERT method, which is really too fast. The method for handling millions of rows of data within 10 seconds is as follows: Alter database Test Set Recovery bulk_loggedBulk insert

It is troublesome to back up server data. It is difficult to back up server data manually on a daily basis. Here I will introduce a method to create automatic backup through job scheduling of SQL Server: 1. Choose Enterprise Manager> Manage> SQL

Written by: Edgewood solutions engineers -- 8/18/2008 -- 6 comments Win SQL Server books-click here problem database partitioning ing was released with SQL Server 2005 and is becoming a popular choice for a Failover

One is to use the try... catch statement, for example: -- -This is just an instance. Create Procedure [ DBO ] . [ Mytrytran ] -- Create a stored procedure -- @ Toid int, -- the account that receives the transfer -- @ Fromid int, -

Note the use of inserted and deleted queries------------------------- -- When a person record is added to the person table-- Save the primary key personname of the record in the changetable table.Use testdbIf exists (Select name from

I understood the role of the trigger! /*Create a virtual test environment, including the table [cigarette inventory table] and table [cigarette sales table].Please pay attention to tracking the data of these two tables and understanding what

I.Application of jobs (automatic updateDB) 1,OpenSQL ServerEnterprise Manager, find the job in the Management 2,Add a job, set specific settings, and add steps to confirmSPAndSQLStatement Add scheduling to determine the frequency of execution!3

Based on a good database design, using indexes effectively is the foundation for SQL Server to achieve high performance. SQL server uses a cost-based optimization model, which queries related tables for each commit, determines whether to use or

CodeAs follows: Select serverproperty ('servername') as servernameSelect serverproperty ('buildclrversion') as buildclrversionSelect serverproperty ('colation') as collationSelect serverproperty ('colationid') as collationidSelect serverproperty

  Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Method 1: Create Table # Tabtmp (ID Int ) Insert # Tabtmp Execute (' Select ID From ' + @ Tablename ) Declare Curone

The help document address of SQL Server. Just enter it in IE.MK: @ msitstore: C: \ Program % 20files \ microsoft % 20sql % 20server \ 80 \ tools \ books \ tsqlref. chm:/ts_ba-bz_35ww.htm Backup database to disk path backupRestore database from

To:Http://yiyeweichen.ycool.com/post.2856405.html To enable SQL Server 2000 to support a large memory of more than 2 GB, perform the following operations: 1. Enable the PAE mode of the Operating SystemAdd/PAE to the boot. ini file:[Boot

Reposted from the msdn Forum/* -- Pay special attention Follow these steps. Do not follow these steps.Otherwise, your database may be damaged.Generally, steps 4 and 6 are not recommended.Step 3 is not safe, and may damage the database or lose

A new server with 4 GB memory is configured and 4 GB is correctly displayed at startup. However, after win2003sp2 is installed, the system only displays 3.37 GB. It was originally thought that there was a hardware fault in the memory, which was then

Due to special requirements encountered in the past few days, the two SQL Server servers are separated by one party every day and require highly effective data synchronization. We all know that through the Internet, it is difficult to achieve

// Performance Set statistics io on; Set statistics time on; // Mysql splitting string  Create procedure proc_split ( Inputstring VARCHAR (1000 ), Delim CHAR (1) ) BEGIN DECLARE strlen INT; DECLARE last_index INT; DECLARE cur_index INT; DECLARE

1. Use the specified string to separate the elements. The number of elements after the split is returned.Create function Get_StrLength(@ Str varchar (1024 ),@ Split varchar (10))Returns intAsBeginDeclare @ location intDeclare @ start intDeclare @