Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


701: The biggest query of data to sort the problem (only with a written statement)
CREATE TABLE hard (qu char (11), co char (11), je numeric (3, 0)) insert into hard values ( 'A','1 ', 3) insert into hard values ( 'A','2 ', 4) insert into hard values ( 'A','4 ', 2) insert into ha...

702: SQL way to achieve cross-table
In general cross-division statistics are a form more complex, showing a more clear mission, but the database itself does not provide the function of the realization of cross-table that he created not only to cross-table process, the cursor, a tempor...

703: SQL Server 2000 configuration options
SQL Server server configuration options are fewer people understand that and often misuse the option. When a technical support personnel ask you to adjustment in accordance with an option in some way, and the other technical support staff is asking ...

704: Show ﹑ view the process of encryption, such as SQL object
Keyword unrestricted bytes than SQLexplorer security, with encryption SYSCOMMENTS View all of the code create PROCEDURE sp_decrypt (@ objectName varchar (50)) AS begin set nocount on - CSDN: j9988 copyright: 2004.01.05 - V3 .1 - Break byte un...

705: how to sql server2000 in storage encryption and decryption process
>> Encryption From the Books Online: Use the WITH ENCRYPTION option: IF EXISTS (SELECT name FROM sysobjects WHERE name = 'encrypt_this' AND type =' P ') DROP PROCEDURE encrypt_this GO USE pubs GO CREATE PROCEDURE encry...

706: For the original procedure of fuzzy query
Small stickers of their own code, the use of lazy way to do so. Using C + + to get out of character, guided into a table kept up. Sql server and then use to sort their own way (codepage: 936, require customers to install when it is published can o...

707: Dynamic cursor
For example, you no longer based on the specific circumstances of your modification: declare @ sqlExec varchar (8000), @ tableName varchar (255) set @ tableName = 'sysobjects' set @ sqlExec = 'declare cursor1 cursor for' + CHAR (1...

708: How to clear log sqlserver
Method 1: The first step: backup log database_name with no_log Or backup log database_name with truncate_only - no_log and truncate_only is synonymous here,can not implement the second step: 1. Contraction specific database of all data and log f...

709: sql server services the entire Raiders
The attributes of a Service Service with ACID properties That is, of Atomic Atomic, Consistent consistency, Isolated isolation, Durable permanent Atomicity That matters should be used as a working unit, transaction processing is complete, all th...

710: How data synchronization between the two SQLSERVER
The use of database replication technology to copy data to update the concept of synchronous replication is a set of data copied from one data source to multiple data sources of technology, is a data storage site to more than an effective way. The u...

711: The problem of lock
Now there is always this error message! -2147467259 Your transaction (process ID # 30) was deadlocked with another process and has been chosen as the deadlock victim.Return your transaction. use master go create proc killspid (@ dbname varchar (...

712: String can not resolve more than 8000 ways
Often it was mentioned that using dynamically generated SQL statement approach to data processing long sentences, could not be dealt with to discuss this issue on the following: / *-- --* Test environment data / if exists (select * from dbo.sysobj...

713: how to sqlserver in the text, ntext, and image operations
WRITETEXT Allow for the existing text, ntext or image columns in non-interactive update log records. Complete rewrite of the statement will be affected out of any existing data. WRITETEXT statement can not be used in view of the text, ntext and ima...

714: odbc connection sql server dynamic of dsn
SELECT * FROM OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0', 'Data Source = "d: \ temp"; User ID = Admin; Password =; Extended properties = dBase IV')... abc ...

715: Record after deletion of the table, how to make a new record is still the No. 1 to start from
There are two ways: Method 1: truncate table to your table - it will not only delete the data, but also to re-home digital identity attribute fields. Method 2: delete from your table dbcc checkident (your table name, reseed, 0) - re-home digita...

716: ms sql server database can not enter the word simple body
Chinese table storing the data types of all fields into unicode That is all into nchar, nvarchar, ntext of. To be stored and then when the characters keep adding N Such as: insert into yourTable (a1) values (N 'content'); ...

717: How do I create a database setup
Dlg_SetupDatabase: / / install the database interface szMsg = "Please choose the type of application installed"; szTitle = "application installation type"; SetupDatabase = "server-side"; noSetupDatabase = "clie...

718: ACCESS database will be converted to SQL SERVER database Some experience
Recently busy ACCESS database will be converted to SQL SERVER database study, which found a number of experiences to share with you. 1.ACCESS the database automatically when the ID type in the conversion, sql server does not set it as automatic ID-...

719: SQL Server 2000 will use existing code as a Web service provider
Use. NET distributed applications to establish Steve Kirk and Priya Dhawan Microsoft Developer Network Abstract: This article describes how to use Microsoft SQL Server 2000's XML functionality to the existing stored procedure code as a Web se...

720: When the SQL Server database when the collapse of how to restore?
Come to an end the work of this afternoon free, writing articles, you may be helpful:) Any database system can not avoid the collapse of the situation, even if you use the Clustered, Hot Standby ... ... still can not completely eradicate the system...


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