query

Ado| Stored Procedure | experience In a project, I need to use a stored procedure to access the data, in order to provide a more consistent interface to invoke, I do not use CreateParameter (), but rather call the Commandptr refresh () function to

Server Maintenance plans that are automatically performed on a regular basis: Rebuilds the index with the new fill (duty) factor to reorganize the data on the data and index pages. This ensures that database pages contain equally distributed data

If your database design allows null values in any column, you need to know how different clauses in your query deal with the problem. 　　 On the surface, it may be shown that the SQL clause in and exists can be interchanged. However, when dealing

Query Analysis | Using shortcut keys ALTER procedure Sp_getfields @tablename varchar (100) As DECLARE tmpcursor cursor FOR Select name from syscolumns where id = object_id (@tablename) Open Tmpcursor DECLARE @fieldname varchar (50) DECLARE @sqlstr1

Query Analysis | scripts --With the following script, you can get the script of the creation of any object, the Internet seems to be circulated, but the things that belong to their own use or feel comfortable. --When you add a shortcut key, you can

The server transaction log (Transaction logs) is a very important but often overlooked part of the database structure. Because it is not as active as the schema in the database, few people are concerned about the transaction log. The transaction log

Ado|command| Notes | objects First, the characteristics of the introduction ⒈sqlcommand: Represents a Transact-SQL statement or stored procedure to be executed on a SQL Server database. ⒉sqldatareader: Provides a way to read a forward-only row

variables | stored Procedures | Pagination to create a stored procedure that returns the results of a specified record, you must first specify the number of records to return the result set, either with a temporary table or with a table variable

server| Access | Three methods for data access to Microsoft SQL Server meta data Shanghai Minimally Invasive Software Co., Ltd. Xiaoguidong For readers: Microsoft SQL Server, advanced users Introduction to meta-data The most common definition of

Stored Procedures | pagination | data CREATE PROCEDURE Sp_page @tb varchar (50),--table name @col varchar (50),--Paging by this column @coltype int,--type of @col column, 0-digit type, 1-character type, 2-date Time type @orderby bit,--sort, 0-order,

Using Use_concat hints --use Use_concat hints in Oracle Last Updated:thursday, 2004-11-18 21:48 eygle Use_concat prompts to force each or predicate in the optimizer to extend a query as a separate query block. Finally, the results of all

The PL/SQL cursor provides a way for a program to select multiple rows of data from a database and then handle each row separately, providing Oracle with a means to indicate and control the stages of SQL processing. I will think you have a certain

Two myths about indexing using indexes: Using the <> and!= operators, causing queries to not use indexes First of all, please remember this conclusion: The index is not used after <> and!= are used For example, the following example uses Select

Four myths about indexing using indexes: Effects of null values on indexes Let's do some test data first: Sql> CREATE table t (x int, y int); Table created Note that here I do a unique (federated) index of table T: Sql> Create unique index t_

Ado| Notes | objects First, the characteristics of the introduction 1. Represents a set of data commands and a database connection for populating the DataSet and updating the SQL Server database. 2, there is no direct connection between the

Data | database First, the principle of database selection 1, stable and reliable (high-availability) Database preservation is the enterprise's most important data, is the core of enterprise application, stable and reliable database can ensure the

server| Error | Resolve through the above several aspects of the inspection, error 1 The cause of the occurrence can basically be excluded. Let's describe in detail how to troubleshoot error 2. The error message shown in Figure 2 is often

Web in recent years, web-based free email system is very popular, at present, several famous free email websites have basically become the majority of people's choice, the establishment of a simple free email service site is no longer like the

Web|web Service |web Server | security | Attack Run Nmap Search the entire network can list all known servers within the domain. In addition, you can view DNS to see what the server administrator has set for this domain. Then use the previous

Web|web Service |web server Access database, because this project is a small community-oriented Community Data Center server, so choose a small database. Because Java portability can use the server on a Linux platform, you can use the database