SQL Server

Remember: During the 08 installation, You need to customize an instance, for example, mysql2008 (you cannot use the default instance)When installing SQL server 2008 express, the system prompts "An error occurred while restarting the computer

1. the query conditions are accurate.Ii. SQL logic execution sequenceFROM --> JOIN --> WHERE --> GROUP --> HAVING --> DISTINCT --> ORDER --> TOPIii. HorizontalQuery required fieldsWhen connecting multiple tables in an SQL statement, use the table

According to the general practice, some fields cannot be exported to generate the formatted XML file, so there is no way to format the imported data during the import.I think of two points: 1. manually modify and format the XML file; 2. Create an

Copy codeThe Code is as follows:-- Code 1 DECLARE @ cc INTSELECT NewsId, ROW_NUMBER () OVER (order by SortNum DESC) AS RowIndex INTO # tb FROM news WITH (NOLOCK) WHERE NewsTypeId = @ NewsTypeId AND IsShow = 1SET @ cc = @ ROWCOUNTSELECT n. * FROM

Remove duplicate dataAdd two fieldsAlter TABLE T_Employee Add FSubCompany VARchar (20 );Alter table T_Employee ADD FDepartment VARCHAR (20 );Assign values to newly added fieldsUPDATE T_Employee SET FSubCompany = 'beijing', FDepartment = 'development

Create a clustered index for the CreateTime column in The Liwu_Items tableFirst, the paging syntax unique to sqlserver2005Copy codeThe Code is as follows:Declare @ page intDeclare @ pagesize intSet @ page = 2Set @ pagesize = 12Set statistics io

For example, if we import a customer's profile, we know that the customer's name is ZhangShan. We want to know that in our business database (eg: NorthWind, in which data tables have fields with this name value set to ZhangShan, we can achieve this

SQL Server replication is divided into three types. The following describes these three Replication technologies and their existing defects. You can select an appropriate replication method based on the specific situation during use, avoid

Generally, there are two ways to connect to SQL server. One is to use the client tools provided by SQL server, such as the Enterprise Manager, query analyzer, and transaction probe; the second is to use a client program developed by the user, such

Copy codeThe Code is as follows:------------------------------------------------------ Paging stored procedures for SQL 2000-- Time:----------------------------------------------------Alter procedure [dbo]. [uoSp_RecordPager]-- The name of the table

Clustered index: physical storage is sorted by indexNon-clustered index: physical storage is not sorted by indexAdvantages and disadvantagesClustered index: the data insertion speed is slow (the time is spent on the "sort of physical storage", that

1. set bakupfolder = F: \ backup \Backup files are stored in the directory F: \ backup \ (this directory must be created in advance)2. By default, each database is placed in a subdirectory with the same name under bakupfolder (automatically created

1. char type:1 byte for English (ASCII) characters and 2 bytes for one Chinese character. It is convenient to store fixed-length data for CHAR, And the indexing efficiency on CHAR fields is extremely high, for example, if char (10) is defined,

1./* + ALL_ROWS */It indicates that the overhead-based optimization method is selected for the statement block, and the optimal throughput is obtained to minimize the resource consumption.For example:SELECT/* + ALL + _ ROWS */EMP_NO, EMP_NAM, DAT_IN

I think we can use string parameters to solve this problem at this time. We can use the string Splitting Method to separate a parameter into several parameters. Here is an example:Assume that you have a list of product information (showing the basic

A program with no more than 2000 SwitchesSo I found the next tutorial online.Write a batch to automatically start the serviceWow hahaI suddenly felt that network language was not a major obstacle.Almost all of them are written.Wow hahaAn ORACLE

The following are my statistical solutions:Solution 1 (recursive ):Simple Table Structure:CategoryID int (4 ),CategoryName nvarchar (50 ),ParentID int (4 ),Depth int (4)In this way, the parent directory of ParentID is obtained recursively based on

Test EnvironmentHardware: CPU core T5750 memory: 2 GBSoftware: Windows server 2003 + SQL server 2005OK, first create a database: data_Test, and create a table: tb_TestTable in this database.Copy codeThe Code is as follows:Create database data_Test --

Someone suggested that the cursor would be poor and the row would be locked. Fortunately, I locked a temporary table instead of a data table, which does not affect the write operation of the data table.Below is the reply from the 14th floor, which

Copy codeThe Code is as follows:-- I believe that we will always import data to the database, but some data records the data of all columns in the row may be null, which is not required for null data.-- Now we need a simple query to remove these