SQL Server

1. Get all database names:Select name from Master .. sysdatabases order by name 2. Get all table names:Select name from databasename .. sysobjects where xtype = 'U' order by nameXtype = 'U': indicates all user tables;Xtype = 's': indicates all

A few days ago I saw an article titled "SQL Server DBA thirty questions", which is very good and pertinent. These questions can be answered only after some operation experience is required. Many of these questions can be found through books online.

Today, when I backed up a database and restored it to another database, I found that it could not be restored. I looked at the inconsistency between the logical File Name of the original database and the physical file name. The following method can

During database development, when the data you retrieve is only one record, the transaction statements you writeCodeSelect Insert statements are usually used. However, we often encounter this situation, that is, reading a record from a result set

Synchronization Process 1. preparation. skip this step if it is complete. 1. The intranet DB server acts as the publishing server and the Internet DB server acts as the subscription server. Create a Windows user JL and a password JL on the

Creating a web application requires paging. This problem is very common in database processing. The typical data paging method is the ADO record set paging method, that is, using the paging function provided by ADO (using the cursor) to implement

Summary of the relationship between the SQL Server user name and the login name Login Name:An entity of the server. A login name can only enter the server, but cannot allow users to access database resources on the server. The definitions of each

Note three points when uploading Excel Data to SQL Server! Note: To upload Excel Data to SQL Server, you must upload the Excel Data to the server in advance. Practice: Add a fileupload upload control in the ASP. NET environment. E. X of the

Note: Many of the content in this article is also one of the most important links for merging and copying. Therefore, configuring publisher will be divided into two chapters for translation.) When SQL Server distributorAfter the configuration is

Sp_detach_dbDetach the database from the server, and you can choose to run update statistics on all tables before the separation. SyntaxSp_detach_db [@ dbname =] 'dbname'[, [@ Skipchecks =] 'skipcheck'] Parameters[@ Dbname =] 'dbname' Name of the

Len: returns the number of characters (not bytes) of the specified string expression, excluding trailing spaces. Datalength: returns the number of bytes used to represent any expression. Example 1: (same, the returned result is 5 ): Select Len

In special cases, the sysaltfiles primary database contains the rows corresponding to the files in the database. The table is stored in the master database.Each character set in the syscharsets primary database occupies one row in the table. The

SQL Server does not disclose two stored procedures: sp_MSforeachtable and sp_MSforeachdb Have you ever written code to process all tables in the database? How can I write code to process all databases in an SQL Server instance? However, do you know

From: http://blogs.msdn.com/ B /apgcdsd/archive/2012/08/01/sql-server-scan-seek.aspx SQL SERVER uses scan and search algorithms to read data from data tables and indexes. These two algorithms constitute the foundation of queries, which are almost

Method for setting a scheduled job for SQL: If you need to regularly execute a stored procedure or SQL statement of less than 3200 characters at intervals in SQL Server, you can use "manage"> "SQL Server proxy"> "job. 1. Choose manage> SQL Server

1. Establish a connection Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Sp_addmediaserver 'external Server', 'access ', 'Microsoft. Jet. OLEDB.4.0 ', 'C: \ access. mdb' 2. Query Code

Index reconstruction aims to reduce data fragmentation. Data fragmentation can cause SQL Server to read unnecessary data and reduce SQL Server performance. Re-indexing also updates column statistics. If the Column Used for the query lacks or misses

SQL Server Database Synchronization is a commonly used part of the project. If data in a project is stored on different database servers, and these databases need to be called by multiple domains, configuring SQL Server Database Synchronization is a

Today, when SQL Server 2000 is used to open all tables in the Enterprise Manager and select to return all rows, "Provider cannot be found" appears. Normal 0 false false false MicrosoftInternetExplorer4

1. Open "database source" in "Administrative Tools" under "Control Panel ". 2. Press "add" to add a new data source, and select "Driver do microsoft Access (*. mdb) ", a box will appear, enter the name you want to write in" database source ", I