SQL Server

A cursor provides you with a method to operate data in a table on a row-by-row basis instead of a result set.1. How to use a cursor1) define the Cursor statement Declare Cursor2) create a cursor statement Open 3) extract the cursor column value and

Step 1: Install SQL200 and start SQL2000. Download SQL2000 from the Internet and install it. (My operating system is XP and I installed the SQL Personal Edition). Open the SQL Service Manager as shown in the following figure. Click Start/continue

Specific operations:Find the owner of the current blocking statement based on the spid and blocked in master. dbo. sysprocesses, and then use dbcc inputbuffer () to view the blocking statement.Example:Open three query analyzers A, B, and CCreate a

Create two tables:Table 1: student:Table 2: course:(In this case, the table is created to demonstrate the connection to the SQL statement. Of course, we will not create the table in actual development. In actual development, the two tables will have

If your hard disk space is small and you do not want to set the database log to the minimum value (because you want other normal logs to Be RECORD), and the speed requirement is high, we recommend that you use turncate table1 to clear all the data,

Steps:1) Add/delete programs to completely delete SQL server.2) Delete the SQL server Directory that has not been deleted.3) Open the Registry Editor, find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \

Copy codeThe Code is as follows:/** @ Curentpage current page* @ Pagesize number of records per page* @ TableName: Table Name* @ Key primary key (Auto sort)* @ Where query Condition1) null is null2) do not include where when there are query

Recently, I analyzed the database of a project. to import a large amount of data, I want to import up to 2 million pieces of data to sqlserver at a time. If I use a normal insert statement to write the data, I am afraid that the task cannot be

1. Export and import data to a database in SQL Server1. Select the database to be transferred in the SQL Server Enterprise Manager, right-click and choose all tasks> back up the database.2. Select database for backup-complete,Target backup to press

However, the volume is still very large. Therefore, in daily work, how to reduce the size of SQL Server backup files is a concern of many database administrators.Maybe Microsoft's database product design experts have heard the voices of many

When the specified conditions are met, the database automatically runs the operations specified by the Administrator. When automatic management is used to process daily transactions, administrators can take time to focus on other things, such as

Q:What is the difference between varchar and Nvarchar in SQL server? varchar seems to be an English character and a Chinese character both stand in two bytes, while Nvarchar is an English character and a Chinese character occupies two bytes. But

1. Write Data to another table in the same database:Copy codeThe Code is as follows:Use db1GoCreate table t1 (Item varchar (100 ),Prov varchar (100 ),Qty int );Insert into t1 (item, prov, qty)Select 'original name', 'xx province ',(Select count

SuperSocket information: (SpnRegister): Error 1355. How can this problem be solved?When SQL Server is started on a computer running Microsoft SQL Server 2000, SQL Server programs always try to register virtual servers in Active Directory. You may

Generally, this sa cannot change or delete the name. It is a little tasteless. After installing sql2000, I felt strange. I was always worried that my computer would not be able to pull out my password one day, even in the dark road for so many days,

Example 1: query the student table in the database through the Stored ProcedureWe know that in SQL, when we query a table, we can use select * from student to query it. How should we write it in the stored procedure?Solution:First, open the query

1. Account and password settings To use the same password as SYS, SYSTEM, DBSNMP, and SYSMAN, select "all accounts use the same password ".BI user, password ch51 *****, SCOTT user. All the above are the same password ch5 *******Select "use different

Copy codeThe Code is as follows:/*Date: 2009-03-19Function: obtains national game task list data based on various conditions.*/Create procedure [dbo]. [PrGs_Nation_Task_GetList]@ PageSize int = 100, -- the number of records displayed on each page.

Here is an example of where you need to modify it.A. xtype in (167,231) 167 and 231 are the xtype values of varchar and nvarchar columns found in the policypes system table. If other types of columns are also injected, add it to the backend of 167

Table sysdatabases: stores database information in the DBMS.Select [name] from [sysdatabases] order by [name]You can get the database information in the DBMS.Table sysobjects: stores information about data tables in the database.Con. ChangeDatabase (