SQL Server

For new users who are new to SQL databases, there are many questions about SQL versions, but they are too lazy to study them carefully. Although the problem is simple, the impact is not small. Version differences SQL Server 2000 has four

Drop procedure xp_cmdshell Drop procedure xp_servicecontrol Drop procedure xp_regwrite Drop procedure sp_oacreate Drop procedure xp_dirtree Drop procedure xp_regread Drop procedure sp_msgetversion Drop procedure xp_enumgroups Drop procedure

1. Enterprise Manager-> Management-> current activity-> process infoTo disconnect, right-click the target instance and choose kill process. 2. Check the system performance:Control Panel-> Administrative Tools-> performance (or enter MMC in the

1) the manager does not actively refresh the page. You need to manually refresh the page to see the latest status (performance considerations)2) in rare cases, the recovery process is suspended. In this case, if you want to recover and return to the

I have recently received a training session to explain SQL Server optimization and make some reserves.   First, let's explain several terms:Execution Plan: the code segment after SQL compilation. It is not binary code, but the Execution Code for SQL.

Cursors provide a flexible way to retrieve and operate data from tables. cursors are mainly used on servers to process SQL statements sent from clients to servers, or data processing requests in batch processing, stored procedures, and triggers.

Designing an application system does not seem difficult, but it is not easy to optimize the system performance. There are multiple options in terms of development tools, database design, application structure, query design, and interface selection,

# Region "namespace" Imports System. data Imports System. data. sqlClient # End Region ''' ''' connect to the base class' ''' ''' 2010-02-05 Public MustInherit Class BaseDBConnection Implements IDisposable # Region "constructor" '

Rank-and-column inversion is one of the commonly used techniques in sqlserver. Unlike sqlserver2000's case-based splicing method, sqlserver2005 provides the limit and unlimit keywords to implement this technique. 1. Use the marker to put the rows

Tutorial object: PowerBuilder8.0 Microsoft SQL Server 2005 Summary: connection through the common interface ODBC First, enter db profile in PB8.0 .. Then go to the ODBC Administrator in Utilities under ODB ODBC Click Add .. Select the SQL Server

Use a Transact-SQL statement to import and export data: 1. query access data in SQL SERVER: -- ===================================================== ================== SELECT * FROM OpenDataSource ('Microsoft. jet. OLEDB.4.0 ', 'Data Source = "c: \

SQL server Table value functions Keywords: SQL server, table Value Function The Table Value Function of SQL server Returns a table type, which is equivalent to a virtual Table stored in memory.It is easy to implement the table value function:The

The deployment report Services prompts you to enter the login user name and password. No matter how you enter the password, the total prompt is not verified. Http: // 172.18.191.21/ReportServer/   Solution: There is an RSWebApplication. config file

For the database system that has just been installed, if it is installed by default, it is likely that an error is reported during remote connection. The common error is: "When you connect to SQL Server 2005, this failure may occur if SQL Server

A self-written tool that can be used to reduce repetitive work and give full play to the programmer's ability to "copy-paste. If you have any shortcomings, please consult more.   1. After installation, open the interface as follows: After

Database YourDB has full backup YourBaackUpFile. bak. It can be restored using following two steps. Step 1:Retrive the Logical file name of the database from backup.RESTORE FILELISTONLYFROM DISK = 'D:BackUpYourBaackUpFile.bak'GOStep 2:Use the values

Select APP_NAME () as w -- Application of the current session Select @ ERROR -- return the ERROR code (integer) of the last executed Transact-SQL statement)Select @ IDENTITY -- return the last inserted id value SELECT USER_NAME () -- returns the

Here we mainly demonstrate three arithmetic words, UNION, except t, and INTERSECT. There is a reason to put them together, because they all operate on two or more result sets, these result sets have the following restrictions: The columns and

1: If the parameter is of the int type: Declare @ a xmlSet @ a =' 1 5 4 3 2 'Select * from product where id in (Select d. x. value ('./id [1]', 'int') from @ a. nodes ('/*') as d (x ))   2: If the parameter is of the varchar

SQL SERVERRegular Database Backup   Click "manage" -- "SQL server proxy" -- "job" Create a job: On the General tab, enter "name" in "regular backup database", "enable", select "check", and "target local server ", "Category" select "database