SQL Server

On this topic, I also see other methods on the Internet to solve the problem.However, from the perspective of performance and code volume, I have a better solution.Here we will share with you.The principle is actually very simple,Knowledge 1. Length

Copy codeThe Code is as follows:-- Create a data table createtable TestData(ID int identity (1, 1) primary key,Data int,ColA varchar (20 ),ColB varchar (20))Go-- Insert Test DataDeclare @ counts intDeclare @ I intSet @ counts = 10000Set @ I = 1While

It is understood that the vast majority of developers have a thorough understanding of indexing, limited to the fact that most daily work has no chance, and there is no need to care about or understand indexing, when a query is too slow, you can

Use an SQL statement to add or delete a modified Field1. Add a fieldAlter table docdsp add dspcode char (200)2. delete a fieldAlter table table_NAME drop column column_NAME3. Modify the field typeAlter table table_name alter column column_name

After attaching a database, you cannot view the database relationship diagram or establish a database relationship diagram.My solution is as follows:1. Set the compatibility level to 90 (2005 to 90) (2000 to 80)Copy codeThe Code is as follows:USE

Two organizational structure tables (Organise) and wage distribution History Table (WagePerMonthHis)The two tables are associated through Organise. Item_id and WagePerMonthHis. OrgIdS.In the Organise table (hereinafter referred to as the O table),

1. multiline Functions, also known as Group Functions and Aggregate Functions1. Types of Group FunctionsAvg, count, max, min, stddev, sum, varianceAvg averageSelect avg (nvl (column 1, 0) from table 1Count calculates the number of rowsAggregate

First, a few nonsense words are as follows:(1) trigger is a special stored procedure. Its execution does not need to be explicitly called, but is triggered by some events, this is a bit similar to the Event Processing Mechanism in C. A trigger is

[Available] if the CD-KEY is required to install SQL server 2000, use regedt32 to open the registry, create a DWORD key in the following primary key [HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager]SafeDLLSearchMode and

To meet the above requirements, we can use the following methods, but the efficiency is quite different.First, create an index in the Order table:Create unique index idx_eid_odD_oidD ON Orders (EmployeeID, OrderDate DESC, OrderID DESC)Multiple

Menu:User_Role => RoleId => RoleMenuRoleMenu => MenuId => MenuThe business relationship between them is:After a user logs in, the user ID is used to obtain the User_Role list, and the roles included by the user are obtained.Use User_Role to find all

Copy codeThe Code is as follows:SELECTTableName = OBJECT_NAME (c. object_id ),ColumnsName = c. name,Description = ex. value,ColumnType = t. name,Length = c. max_lengthFROMSys. columns cLEFT OUTER JOINSys. extended_properties exONEx. major_id = c.

After the following stored procedure is created, you can directly call the stored procedure by page.Note: If the data volume is large and the performance requirement is high, please customize the processing.Copy codeThe Code is as follows:Alter

Copy codeThe Code is as follows:Create table tb (standards varchar (50), amount varchar (50), variation varchar (50), statuss varchar (50), Reason varchar (50 ))Insert into tb values ('55', '123456', '4', 'backlog of things ', 'Insufficient

Copy codeThe Code is as follows:Using System. Data;Using System. Diagnostics;Using System. Data. SqlClient;　　　 String connectionString = "Data Source = HG-J3EJJ9LSW5PY; Initial Catalog = Test; User ID = sa; password = hg ";DataTable dataTable = SQL _

Copy codeThe Code is as follows:--*************************************** ****************-- * Paging stored procedure *-- * Sahara Forest *-- * 2010-6-28 *--*************************************** ****************If exists (select * from sysobjects

The following describes the solutions of a master in SQL.For your reference:Assume that a table contains three columns: Student ID, name, and school.Then insert data into the table.040501 Sun Ming Shandong University040502 Li Hao Shandong Normal

Solution:It is not possible to directly attach or attach data. It is certainly no problem to use script + to export data.Steps for transferring Sql2005 to Sql2000 1. Generate database scripts for version 2000 Manger studio in Sql2005-- Open "Object

Figure 1 wins the 10 Statement: SQL Server database SummaryA rough summaryAfter a period of study, I also had some knowledge about databases.Databases are basically composed of tables, relationships, and operations. For Beginners, the first thing to

Copy codeThe Code is as follows:ALTER function [dbo]. [GetOrderNum] (@ Ebaystockflag varchar (20) // rule letter)Returns varchar (100)ASBEGINDeclare @ dt CHAR (8)Declare @ flag varchar (20)Set @ flag = 'B' + @ ebaystockflagSet @ dt = CONVERT (CHAR (8