Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


641: SQL Server with Exchange Server integration applications - SQL Mail
This paragraph from the article excerpts of the new railway publishing house "with BackOffice establish Intranet / Extranet applications," a book (now available at all bookstores. Such as the Haidian Book City, such as Xidan Books Building...

642: Distributed queries and distributed transactions
Microsoft? SQL Server? Allow creation and as the link server OLE DB data source link. The link to the OLE DB data source, you can: OLE DB data source from the rowset quoted as Transact-SQL statements in the table. The command passed to the OLE DB ...

643: Modify sql statement used in the field data sheets to achieve 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...

644: The correct configuration and use SQL mail
Costs of the effort some time ago, and finally fixed the SQL mail configuration and use. Finishing out _Rambo want me to share the relevant documents. I would I configure SQL mail to describe the process again. I mainly use SQL mail to complete t...

645: DTS Import and Export on the lost object, such as the default value
Using DTS Wizard in SQL SERVER or between the data between two database import and export value by default configuration, only the object, as well as import and export table view object, for example, as the other defaults, stored procedures and othe...

646: TOP N and SET ROWCOUNT N which faster
Too lazy to translate the effect: Index in a suitable time, Top n and set rowcount n is the same as fast. However, for a disorderly heap, top n faster. Principle to see that the English themselves. Q. Is using the TOP N clause faster than using S...

647: How to view the phrase used in ORDER BY
Not bother to translate the original text, and generally view the use of the Order by is not valid unless the use of Top keywords, then we can use to deceive the Top 100 percent of the SQL parser. USE pubs GO CREATE VIEW AuthorsByName AS SELECT...

648: How to compare case-sensitive
Q: How are not case-sensitive instance of SQL Server 7.0 users to prepare to enter the password case-sensitive comparison process? A: If the system has been upgraded to SQL Server 2000, you can specify the data in column-level collation. (SQL Serve...

649: How to save as a string of IP address into a binary value
For SQL Server 2000, you can use the following function: CREATE FUNCTION dbo.IPAddrStr2Bin (@ strIP varchar (15), @ Validate bit = 1) RETURNS binary (4) AS BEGIN IF @ Validate = 1 BEGIN - Only digits and dots IF @ strIP LIKE'%[^. 0-9]% &...

650: How to randomly select n records or records for a random order
Q. How to sort the results of random? A. To get a random sort out, or to return x be a random selection of listed, you can use the random number. But the RAND function in a query can only return a result. NOWID function you can return the bar to do...

651: SQL script to generate some BUG
email: chair3@sina.com Microsoft's SQL script to generate my heart broken ... ... I always thought that was my point of order, or I operational errors, In addition, customer service personnel frequently complain about the procedures I bug, aft...

652: MSSQL take up too much memory on the issue of
Often see people ask, MSSQL taking up too much memory, but also continued to grow; or the use of memory has been set up, but it does not use so many, this is how children do the same thing? First of all, we take a look at how the use of MSSQL memor...

653: To deal with the user's stored procedure to isolate
CREATE PROCEDURE [LoneUser] - INPUT @ DBName nvarchar (50), @ UserName nvarchar (50) AS Exec sp_configure 'allow updates','1' RECONFIGURE WITH OVERRIDE Declare @ ExecStr nvarchar (4000) Select @ ExecStr = 'Declare @ b var...

654: 1069 error (due to a logon failure can not start service) solution
Appear in the layout of the frequency of this problem is very high, the novice usually experience this problem more reason is very simple to install SQL Server is used as the default logged-on user to start SQL Server service account (for their own ...

655: Update sql server books online
SQL 2000 SP3 with the release, Books Online has launched a new version, however, the installation of Microsoft SQL Server 2000 Books Online (Updated - SP3) after EM or QA by F1, old or out of BOL, how do ? Check the registry, it is easy to find HK...

656: Stored procedure to replace text, ntext column string
/ * author: amjn date :2003-03-28 version: 1.0 function: the replacement of text, ntext string column (do not support Chinese) * / declare @ ptr varbinary (16) declare @ amjnId int declare @ Position int, @ len int set @ len = datalength ( ...

657: MD5 algorithm for T-SQL to achieve the (FOR SQL2000)
/************************************************* **************************** * Name: T-SQL MD5 Algorithm * Author: Rambo Qian * Create Date: 2003-04-10 * Last Modified by: Rambo Qian * Last Update Date: 2003-04-16 * Version: V1.0.00 ******...

658: Depth SQL Server 2000 on the support of XML
We can use very simple ADO database access, but if we want to retrieve from the database data to XML format is displayed, then God must charge point, of course, we can find some off-the-shelf Although ADO2.5 applications that support XML, but it sti...

659: WIN2000-depth registry (15) SQL Server
SQLServer Introduction SQLServer is Microsoft to the relational database management system (RelationalDatabaseManagementSystem, RDBMS) market competitors, with its competitive products, including Oracle and Informix. SQLServer running on Windows...

660: Explore in depth MS SQL Server 2000 network connection security issues
Database of e-commerce, financial and ERP systems, usually to preserve an important business partner and customer information. The majority of enterprises, organizations and government departments are the electronic data stored in various databases,...


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