Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


721: Sqlserver use to store and access session
asp.net provides a three way session storage. 1 InProc 2 State Server 3 SQL Server The first one is, we often used, is No. 2 in a state server using the machine with its memory to store the session state of other machines, in fact, we can also i...

722: SQLDMO from SQL Server to use to obtain information
Abstract: ms sql server provides a very convenient COM component "SQLDMO" to help us access and management of SQL Server. Here to provide some ideas and to achieve. System Requirements: windows2000server vs.net rc3 sql server 2000 Bo...

723: Talk about the data from the sql server database into mysql database experience
Work necessary to sql server stored in the database all the data into mysql database to collect relevant information online to find the two methods, are now to talk about their views. The first is to install the mysql ODBC, use the Export function ...

724: How to make the Microsoft SQL Server will not increase the log file
How to reduce the MSSQL log file has been a recurrent problem, but the essence of the problem in many areas has been the answer, I will not repeat them here. Now we discuss the fundamental issues, namely how to make the log file is no longer increa...

725: SQL Server non-normal to delete the log file (ldf) recovery method
Transaction log file (ldf) in the SQL Server service did not start the case be removed (SQL Server is in working condition can not delete the log file), in which case restart SQL service, the database was marked as the corresponding question (suspen...

726: SQL Server 7.0 database, the six methods of data movement
My work is a database administrator to maintain multiple servers in the database, often a server in a database moved to another server, the mobile data experience, some experience, would like to share. 1. Through the DTS Designer tool to import or ...

727: The expansion of the use of SQL Server as the access attributes, like the Notes column
access the design view has a good list of features designed ----- Notes, which allows designers to clearly see the significance of each column. General sql server table to build this function, but he has extended attributes, this feature is also tru...

728: On the SQL Server in a few visits unpublished registry extended stored procedure
SQL Server contains a number of you have access to the system registry extended stored procedure. However, these extended stored procedure is not open sql server 7.0 from there, In SQL server 2000 is still retained, they may be removed later. But i...

729: Note on the use of Adodb.Stream
Components: "Adodb.Stream" Any of the following methods: Cancel method Use the following Object.Cancel Description: the abolition of the implementation of pending asynchronous Execute or Open methods of the call. Close method Use th...

730: According to Chinese consonant, it is necessary to in the table to find records, how to achieve
According to Chinese consonant, it is necessary to in the table to find records, how to achieve these goals? For example, enter "zgyh", will be able to find all the "Bank of China," the record. if exists (select * from dbo.sysob...

731: Access database and the Data Interoperability SQLserver2000 Introduction
SQLserver by using the Query Analyzer to achieve the implementation of SQL statement: 1. The Access data into SQLserver implemented in SQLserver the following statement in the B04 will be able to Access data table into the SQLserver table sqltablen...

732: Monthly stored procedure to build the application data sheet
In order to facilitate database storage, data backup, recovery, in the actual library building, we hope to establish a specific date data tables, for example, we can set up event table for EV_yyyymm (yyyy for the year, mm for the month), the use of ...

733: How to obtain the MSSQLServer, Oracel, Access the data dictionary information
------------------------- MS SQLServer ----------------------- ------------------------------------- - Table Description SELECT dbo.sysobjects.name AS TableName, dbo.sysproperties. [value] AS TableDesc FROM dbo.sysproperties INNER JOIN dbo.syso...

734: Asp used in the numerical type of the value of stored procedure
In order to improve the efficiency of the procedure Asp, Asp sometimes need to use Sql Server to use the storage technology, following a brief introduction. Stored procedure to establish Here only briefly how the Sql Server Enterprise Manager How ...

735: sqlserver in, sql programming knowledge of several small
1, just remove the insert (delete) data SELECT fieldname FROM INSERTED (DELETED) 2, for the first UPDATE is DELETE and then INSERT want UPDATE if data values before and after, it should be removed from DELETED, and then removed from INSERTED; 3, I...

736: Sql statement used to generate data dictionary Sqlserver
SELECT table = case when a.colorder = 1 then d.name else''end, - The serial number field = a.colorder, Field Name = a.name, - ID = case when COLUMNPROPERTY (a.id, a.name, 'IsIdentity') = 1 then '√' else''end, / ...

737: The use of SQL Server 2000 create temporary Job asynchronous implementation of SQL scripts
Scenarios: In a large number of complex database updates very time-consuming inquiries. Users in order to avoid a long wait, time-consuming operation that can be used to implement the method of induction, immediately return to the implementation of...

738: Through OLE DB to connect MSSQL Server garbled when the solution
When using OLE DB with MS SQL Server connection, if the database code page and local differences in conducting inquiries, when the return value of character will become? Or garbled, Microsoft's Web site said that it was a BUG, and described as f...

739: W2K AD SERVER on the use and installation of SQL2000 Enterprise Edition Dual
Cluster installation process: 1. Machine hardware configuration: server A Model CPU Memory Hard Drive Array 1 card card card ML350G3 2.4G 2G 36.4 * 1 642 HP integrated HP NC3123 server B Model CPU Memory Hard Drive Array 1 card card card ML35...

740: MSSQL database: stored procedure to learn
This example from the two tables inside, we took out the first two lines, and then into a table. In reality, we often encountered such a situation, in a database there are two tables, Table 1 assume that the company's storage products this quar...


Page 37 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]