Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


541: Delete duplicate data in the database several ways
Method a declare cur_rows cursor local for select main field, count (*) from table group by the main field having count (*)> 1 open cur_rows fetch cur_rows into @ id, @ max while @ @ fetch_status = 0 begin select @ max = @ max -1 set rowco...

542: SQL SERVER two methods to clear the log
Method a 1, set the database schema for the simple model: Open SQL Enterprise Manager, in the root directory of the console is open followed by Microsoft SQL Server -> SQL Server Group -> double-click to open your server -> double-click to...

543: Sql Server practical skills to operate a small collection of
(A) suspend the operation or in the installation of Sql patch sp prompted when the installation hangs before the operation, asked to restart, restart often useless here, the solution: To HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ S...

544: Ms SQL Server in single quotation marks to deal with the two techniques
---- And databases frequently used to deal with SQL statement, unless you are all bundled with controls, but the way the use of binding controls the flexibility of the existence of poor Low efficiency, functionality and so the shortcomings of the w...

545: Aggregate Functions
Aggregation function of a set of values of the implementation of the calculation and return a single value. In addition to COUNT function, the aggregation function null ignored. Aggregation function with the SELECT statement with the use of GROUP BY...

546: IDENTITY column a useful operation
DBCC CHECKIDENT Table designated check the current identity value, if necessary, also correct identification value. DBCC CHECKIDENT ( 'Table_name' [, (NORESEED | (RESEED] [, new_reseed_value]) ) ] ) 'table_name' Logo to its...

547: Database standardization and design skills
In a dynamic web site design, database design, the importance of self-evident. If designed properly, it is very difficult to query, the performance of the procedure will also be affected. Whether you are using mySQL or Oracle databases, through stan...

548: Also talk about how to reduce the log file SQL SERVER
A few days ago, when the log file is also the problem of too large, the actual size of the database for the 600M, the actual size of the log file for the 33M, but the log file space for the 2.8G!!! Tried a variety of ways, SHIRNK DATABASE, TRUNCATE...

549: SQL Server in deadlock causes and solutions
In fact, most all of the deadlock is a deeper reason: the performance of a competition for resources: A visit to a user table A (lock the table A), then a visit to Table B Visit another user B Table B (locked table B), and then attempt to access T...

550: SQL - JOIN the full use of
Outside connection. Connection can be left outside the external link, right-out connection or full outer join. Specified in the FROM clause outside link, you can group by following a set of keywords specified: Left out of the result set connected ...

551: SQL statements in a number of specific parameters on how to use variables in place of
Exec method can be used select @ tempStr = 'Update weekcount set [' + convert (varchar, @ week )+']=['+ convert (varchar, @ week )+']+ 1 where userid ='''+ replace (@ user ,'''',''''&...

552: MS SQL7 the use of the LINKED SERVER
Said yesterday that the use of REMOTE SERVER, although very easy to use, but can only be used between MSSQL, if you want to SQL7 with how to connect SQL 6.5? SQL7 or ORACLE or SYSBASE connection with how to do? This requires a LINKED SERVER. Second...

553: On SQLServer database server to optimize memory allocation strategy
Agricultural Bank of head office since 1998 to promote a new version of the official online version of the integrated business statistical information system, which is based on the WindowsNT4.0 platform, client / server model to Microsoft SQL Server...

554: SQL2000 server management SQL7 problems TIMEOUT
Younger brother of the machine to fit on the SQL2000, ready to learn, who knows in the management of other SQL7 occurs when the server message "Timeout expired", failure is as follows: 1, connected to local LAN servers, when using the ENTE...

555: Web environment in MS SQL Server data backup and recovery tape
Abstract: The magnetic tape data backup and recovery process, including the establishment of a hard disk capacity and tape considerable database, that is, the bridge database and Web information systems in order to achieve a complete tape backup and...

556: SQL Server 7.0, compared with the previous version, safe mode to change the most important
It should be a fully integrated Windows NT. In SQL Server 6.5 and earlier versions, and Windows NT security integration is not directly addressed. System privileges, then you are "sa" login, that is, the system administrator. For some IT ...

557: How to modify sql statement data table field, the realization of identity (100,1) incremental
create table common_info ( name varchar (10), value int) insert into common_info values ( 'msg_count', 100) Sql so you should write (using stored procedure): create proc p_ins_alm_msg @ msg_count int out as select @ msg_count = value...

558: How sqlserver7.0 automatically generated in the deadlock to kill
A: I would like to use sqlserver7.0 statement "set lock_timeout 3000", In order to achieve deadlock appears automatically three seconds after the purpose of killing the process, but the database for some time, the settings will be automa...

559: sql2k new Function in the sqlbook help
/ * Tofu http://www.asp888.net technical points * / CREATE FUNCTION Create user-defined function, it is the return value saved Transact-SQL routines. User-defined function can not be used for the implementation of a set of amendments to the stat...

560: Sql server using the memory limit in the number of the most appropriate
If a single Data Server, memory is a good idea to remove the system memory to run around about 20M, and the rest left to Sql Server ...


Page 28 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]