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

Select sysobjects. Name as [Table], sysproperties. [value] As table description, Syscolumns. Name as field, properties. [value] As field description, policypes. Name as type, Syscolumns. length, isnull (columnproperty (syscolumns. ID, syscolumns.

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" '

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: \

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

Create an index Suppose you want to find a sentence in this book. You can search one page by one, but it takes a lot of time. By using the index of this book, you can quickly find the topic you want to search. The index of a table is very similar to

The basic objects of SQL mainly include constants, delimiters, and reserved keywords.1. ConstantsA constant is a hexadecimal or numeric constant that contains text and numbers. A String constant contains one or more characters in the single