SQL Server

The cursor is evil! In relational databases, our thinking about queries is set-oriented. The cursor breaks this rule, and the cursor makes the way we think is done on a line-by-row basis. For developers of Class C, this is a more comfortable way to

Access The operation is very simple, the specific steps are as follows: Open your MDB database, tools--> Database Utilities--> compression and Repair Database (c) ... SQL SERVER In general, the contraction of the SQL database does not greatly

The osql tool is a Microsoft Windows 32 command Prompt tool that you can use to run Transact-SQL statements and script files. The osql tool communicates with the server using the ODBC database application programming Interface (API).This article

Myth #23: The process of lock escalation is escalated from row locks to page locks, and then page locks are upgraded to table locks Error Actually not, in SQL Server 2005 and prior versions, lock escalation will rise directly to the table lock.

Brief introduction In SQL Server, an index is an enhanced existence, which means that SQL Server can still implement functionality even without indexes. However, indexes can greatly improve query performance in most cases, especially in OLAP. To

This article is a transcript of the programmer's SQL code, which will explain the string functions of SQL Server. In fact, the database, like the Program language library, will integrate many APIs that can be used. These APIs, if you are familiar

People these days in doing student information management system, appear The most should be the problem, "Real time error ' 91 ': Object variable or with block variable not set." As shown on the right: In this case, we should first refer to MSDN,

1 Introduction Microsoft has introduced XML-related features and Transact-SQL keyword FOR XML and OPENXML in Microsoft SQL Server 2000. This allows developers to write Transact-SQL code to obtain query results in the form of XML streams and to

The life cycle of the global temporary table persists until the creation session (not the creation level) terminates. For example, if you create a global temporary table in a stored procedure, the table is not destroyed when the scope of the stored

I heard that Ms SQL 2005 with the report function, so I tested a bit, but also relatively easy to use, so I recorded a stored procedure to write a report example. Since there is no voice in the test process, I am here to explain. The stored

Here's a concrete example: if you have a single problem file. This file has a 50MB size, and your entire database runs about billions of bytes, so it makes sense to recover a single failed file. One of the things that happens when a file or

Policy Management is a new feature in SQL Server 2008 that manages the various properties of database instances, databases, and database objects. Policy management under the SSMs Object Explorer database instance under the Administration node, as

I don't know if it's a SQL Server 2008 bug, I've installed SQL2008 (I chose to install the report service), but there is no virtual directory for the Reporting service in IIS at all. Just such a problem, other bi designers, Reporting Services, etc.

One of the basic skills of a database administrator (DBA) is a deep understanding of the SQL Database engine's system database. It is also useful for database developers to understand the system databases that SQL Server brings. Some of these system

This article summarizes the way SQL Server connects across servers. 1, OpenDataSource Open the database example directly with this statement in SQL: OPENDATASOURCE( 'SQLOLEDB','Data Source=TQDBSV001 ;User ID=fish;Password=2312').RackDB.dbo.CS

Q: I recently found that many of the entries in the sysindexes Index table were not created by myself. Listening to colleagues say that they are not real indexes, but rather statistics created automatically by the SQL Server query optimizer. How do

Problem Security is a major consideration for any company. Database backups are easily stolen and restored to another instance of SQL Server. As we explore the new features of SQL Server 2008, we are interested in a feature called Transparent data

A friend called me today to ask me about the maximum supported physical memory capacity of the Windows Server 2003 32bit Enterprise Edition, mainly because the server is running a database server with a memory usage of 2G, and servers are very

List of directories in this document:1. An overview of some of the doubts provided by the SQL Server System2, the system function call when the default substitution optional parameter use is not uniform3.The queue Field column message_enqueue_time

--open Window function: Further processing on the basis of the result set (aggregation operation)--over function, add a field to show maximum age select *, Max (stuage) over () Maxstuagefrom dbo. student;--over function, add a field to show total