SQL Server

Today, when you use a stored procedure to invoke a program, the time or date that you find the SQL is not synchronized with the computer's clock. For example, I change the current time 12:00 to 13:00, and if you get the getdate of SQL Server right

In a stored procedure, if the total number of statistics records will seriously affect the efficiency of the same query conditions the total number of records must be the same, so if the first page to save the total number of records, click on the

Php + mssql makes it really painful. The type of ntext fields used to read mssql in php has another problem: when the content of ntext is too long, the ntext fields are not completely read.I have been searching for it on the Internet for a long time.

Example 1 The code is as follows:Copy code Select OBJECT_NAME (id), id from syscommentsWhere id in(Select object_id (name) from dbo. sysobjects where xtype = 'p')And text like '% FieldName %'Group by id Example 2In Database SQL Server 2005/2008,

A. Causes of data loss:Program errorHuman errorComputer errorDisk failedDisasters (such as fire, earthquake) and theftB. What is backup?Backup creates a copy of data.Used to restore and restore data after system failureFile copy is not equal to

If we use the command mode, it would be easy to restore. The code is as follows:Copy code Restore database [PoloSoft-Full] from disk = 'C:/Users/Administrator/Desktop/PoloSoft. Bak'With replace; Or you won't use the command mode. We can refer

Stored procedure method The code is as follows:Copy code DECLARE @ name VARCHAR (25)DECLARE @ SQL VARCHAR (1000)DECLARE @ logid INTDECLARE sysdatabase_name cursor for select name FROM master. dbo. sysdatabasesOPEN sysdatabase_nameFetch next from

ExampleThe following script uses the CONVERT () function to display different formats. We will use the GETDATE () function to obtain the current date/time: The code is as follows:Copy code CONVERT (VARCHAR (19), GETDATE ())CONVERT (VARCHAR (10),

In this example, we will use the following table, which has duplicate PK values. In this table, the primary key is two columns (col1 and col2 ). We cannot create a unique index or primary key constraint because the two rows have duplicate primary

1. Click Database> task> generate script in your mssql database" 2. Then we will see the next step in the "generate and release scripts" window. 3. Select the database object for script writing and select the first one for all export. If you want to

I found a strange problem in the past few days, that is, when I took my notebook from the development room to the dormitory, my ASP program could not connect to the SQL server database. After analysis and judgment, I found that there was no network

I. Back up the database1. Open SQL Enterprise Manager and click Microsoft SQL Server in the root directory of the console.2. SQL Server Group --> double-click to open your Server --> double-click to open the Database Directory3. Select your database

I. Residual dataWhen you perform an SQL Server 2000 log transfer experiment, the setting process may be interrupted occasionally. If so, some data will still be stored in the log transfer data table of each server, and the subsequent log transfer

A trigger is similar to a stored program.DatabaseObjectIt responds to a request in the database environment. SQL Sever 2005 contains three trigger objects: AFTER, Data Definition Language (DDL), and INSTEAD-.The AFTER trigger is a stored program. It

First, a complex method is provided to compress logs and database files as follows:1. Clear logsDump transaction database name WITH NO_LOG2. Truncate transaction logs:Backup log database name WITH NO_LOG3. Compress database files (if not compressed,

The database server backs up the database at two o'clock every morning and deletes the database backup file five days ago. Otherwise, the hard disk will pop up.Windows logs provide the following information:SQL Server Scheduled Job 'DB maintenance

SET instead of SELECT is recommended for SQL Server.When the expression returns a value and assigns a value to a variable, the SET method is recommended.The following table lists the differences between SET and SELECT. Pay special attention to the

Go to SQL Server, choose Manage> maintenance plan, right-click maintenance plan, find new maintenance plan, and select. 2. You can see that "new maintenance plan" can be set by default or by name. Click "OK; 3. See the following figure: Select the

Implementation of connecting pdo odbc to SQL serverPhp_mssql.dll and php_pdo_mssql.dll in the latest php Tutorial 5.3.6 have all disappeared.There is only one php_pdo_odbc.dll.So ~ The latest and best php connection mssql method should be like this$

 SQL Server database backup and restorationPaste path: http://blog.111cn.net/zjcxc/archive/2003/12/29/20074.aspxThe T-SQL statement is used to realize the function of database backup and restoration, which reflects the four knowledge points in SQL