SQL Server

In this article, we'll cover the concepts available in two SQL Servers, which are noteworthy techniques when using SQL Server.1. OPTIMIZE for UnknownThe OPTIMIZE for hint (hint) is added to the SQL Server 2005 version to allow the DBA to determine

1. Select * from sys.dm_tran_locks or sp_lock view request_node field for ' X ' (exclusive lock) or ' IX ' (Intent exclusive lock)2. View process details with SP_WHO2 + PID (process ID)3. Use DBCC INPUTBUFFER (PID) to view the contents of the

--Cursors in SQL Server--Declaring cursors/*declare cursorname [insensitive] [scroll] CursorFor [For {read only|update[of[,..., n]]}]Insensitive means that the extracted data is stored in a temporary table created in the tempdb library, and any

SQL Server UrlEncodeif exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ UrlEncode] ') and xtype in (n ' FN ', n ' IF ', n ' TF ')--delete the function drop functions [dbo]. [UrlEncode] Gocreate FUNCTION dbo. UrlEncode (@URL

The two verification methods are significantly different. The focus is on trusted connections and untrusted connections. Windows authentication is more secure than Hybrid Authentication. When using this connection mode, SQL does not judge the SA

You can obtain the desired data table information from the system table sysobjects in the database. The specific SQL statement is as follows: Select name from sysobjects where type = 'U '; Because the system table sysobjects stores all database

Someone is looking for SQL Server to store email data on the Internet. In fact, SQL Server provides OLE DB provider to access exchange.   Microsoft ole db provider for exchange publicly stores data in Microsoft Exchange 2000 Web store in tabular

When the foreign key constraint is added to an existing column in the table, the SQL Server 2005 database engine checks the existing data in the column by default, to ensure that all values except null exist in the referenced primary key or unique

In this example, use the following tools to import Excel Data: • SQL Server Data Transmission Service (DTS) • SQL Server connection Server • SQL Server Distributed Query • ActiveX Data Object (ADO) and

-- Five, compute by, grouping based on the columns after compute by and order by, select * From book1order by title desccompute AVG (pricing) by title -- 6. group byselect number, count (title) from book1group by title/* error message 8120, level 16,

1. First, Windows Server 2003/window Server 2000 must be commonly used on Windows servers. For the developed platform, you can select Windows XP and other professional systems. But there are load restrictions (I am afraid the system will not be used

I saw some people discussing the difference between pre-read and physical read on the internet today. I personally think that both physical read and pre-read operations require reading data from the disk to the memory, the reading time is different,

I once met a user who has a very large MSDB database and asked me to help find out why. Use sp_spaceused to find the data size of all tables. The problem is that SQL Server backs up and restores the historical table to a large amount of data. You

The following describes how to set an SQL proxy job: If you need to regularly execute a stored procedure or SQL statements of less than 3200 characters in SQL Server, you can use management> SQL Server proxy> job. 1. Choose manage> SQL Server proxy>

Permission management is involved in program development. The system uses an integer to record user permissions. The permission level is set: Level1 1 Level2 2 Level3 4 Level4 8

Direct access tool-database utility-Upgrade Wizard database to the past is no problem.NOTE 2:1. Because SQL2000 does not contain "auto number", all fields you set with "auto number" will become non-empty fields, which must be manually modified, then,

The two days have all been spent here. In fact, this is not a very complicated thing, but I have been engaged for a long time. First, download the jdbc SQL Server Driver. Then, test MSSQLServer. jar, msbase. jar, and msutil. Jar under

You can use the "generate SQL script" tool that comes with SQL Server 2000 to generate SQL scripts for creating tables, views, and stored procedures. So can we generate SQL scripts for the data in the table and automatically import the data to SQL

Use [test]Go/***** Object: storedprocedure [DBO]. [test1_sp_pageview] script Date: 10/09/2010 09:55:50 ******/Set ansi_nulls onGoSet quoted_identifier onGoCreate proc [DBO]. [test1_sp_pageview]@ SQL ntext, -- the SQL statement to be executed@

1. Open the Enterprise Manager and expand the server group. 2. Click the server, right-click the server, and click the properties menu. 3. Click the memory tab in the pop-up dialog box. There are two methods to set the memory: 1. Set min server