SQL Server

SQL Server 2000 is successfully installed under Vista. Operating System: Windows Vista Home Basic SQL Server 2000 Version: Personal Edition CPU: Core 2 Duo t7100 1, Install msderela. The link is Http://download.microsoft.com/

Four advanced features of SQL Server Indexes   I. Index building filter (filtering during index creation) Some indexes are very inefficient. For example, if the query status is in progress, 99% of orders are completed, and 1% are in progress.

When I knocked on the student information management system, I found a problem. In fact, this problem should be summarized during the five examples, but it was also confused and hard to understand. Now I finally understand it. In the student

SQL Server Error-transaction can not start while firehose Mode Today, I used em to modify a field in a table in the SQL-SERVER, And the SQL-SERVER prompts when I exit: "Transaction can notStart while firehose mode" (Firehose is a type of cursor

After the database is imported, fields that need to be automatically added must be overwritten, and the length of all numeric types must be increased. It is best to use decimal. All default values are lost. It mainly belongs to the numeric type

Use of triggers in SQL Server -- Check whether the specified expert record exists from the temporary tableCreate Function f_expert_exist_in_temp (@ Expertid numeric (9 ),@ Sqltype numeric (9 ),@ Trs_flag numeric (9) )Returns intAsBeginDeclare

Module mdlcommon Public txtsql as string' stores SQL statements Public dbset as Dataset Public errormsg as string' stores error messages Public Function executesql (byval strsql as string, byref errmsg as string) as Dataset Dim CNN as sqlclient.

In the past two days, petshop is edevil? I have made a lot of discussions on petshop, and I am also making a discussion here. I will give you an understanding of the new cache management content in Asp.net 2.0 and the cache processing in petshop 4.

1. What is a stored procedure?Stored Procedures (Stored Procedure) are a set of SQL statements for specific functions in large database systems. They are compiled and stored in the database, you can run a stored procedure by specifying its name and

Create Function bin_to_dec (@ v_bin varchar (32 )) Returns int As Begin Declare @ v_bin1 varchar (32) Declare @ v_dec bigint Declare @ v_com bigint Declare @ v_temp_dec bigint Declare @ v_temp_bin1 varchar (32) Declare @ v_temp_bin2 varchar

In the past few days, the restoration function of the ms SQL database is used. One problem is that the current user is using the database and cannot recover it. I checked some posts, mainly through the stored procedure. A few days ago, I found a

Create Function f_getpy (@ STR nvarchar (4000 )) Returns nvarchar (4000) As Begin Declare @ strlen int, @ Re nvarchar (4000) Declare @ t table (CHR nchar (1) Collate chinese_prc_ci_as, letter nchar (1 )) Insert into @ T (CHR, letter) Select 'ay', 'A'

SQL Server creates a table, but its maximum row size exceeds the maximum number of bytes per line (8060) I. symptomGenerally, this phenomenon is applicable when SQL files are created in the query analyzer. Generally, the following prompts

How to Set up an SQL server as a remotely accessible serverAn external IP address is required.The following describes how to solve the three most common connection errors.The first error "SQL server does not exist or access is denied" is usually the

Log on to the remote SQL Server.Check whether the IP address of the ping server can be pinged. This is to see whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network and check the configuration. Make

Http://blog.csdn.net/tuoxie5431/archive/2010/01/19/5214010.aspx   When executing SQL queries, the main bottlenecks are: CPU computing speed, memory cache size, and disk Io speed. For queries of large data volumes, the bottleneck is generally

1. query Excel Data Select * From OpenRowSet ('Microsoft. Jet. oledb.4.0 ', 'Excel 5.0; HDR = yes; database = C:/aa.xls ', 'select * from [sheet1 $]') Select * From OpenDataSource ('Microsoft. Jet. oledb.4.0 ', 'Data source = "C:/aa.xls"; user id =

1. Install the JDBC SP3 installation program of MS on the Internet.2. After the installation is successful, set classpath and add install_dir/lib/msbase. jar; install_dir/lib/msutil. jar; install_dir/lib/MSSQLServer. jar to classpath;3. After step 2

SQL Server Stored Procedure To put it bluntly, it is a batch processing process. It means that a bunch of SQL statements are executed continuously, which may contain some variables, process control, and display. Therefore, first define a stored

Summary:1. Install SQL server2 000Install SQL Server 2000 Patch SP3Install the driver for SQL Server 2000 for SP3(Patch SP3 first, and then install the driver for SP3. When installing the patch, install the two verification methods for the sake of