Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


681: Using SQL Server for the Web browser to provide images
Microsoft SQL Server database server can be stored in the SQL database a large number of pictures and text. The use of image and text data types are image picture type and the text of the type of text. VB or VC if the use of front-end application de...

682: View the index used to improve the performance of SQLServer2000
Author: Gail Erickson Contributor: Lubor Kollar Contributor: Jason Ward Microsoft Corporation September 2000 Abstract: This document describes the SQL Server 2000 Enterprise Edition's new features - the index view. On the index view and dis...

683: VC procedures used to create a SQL Server ODBC data source
Associated with the database in the release of the software, if the program is access to the database using ODBC, you need to install the software to create ODBC data source. Number of ODBC data source information is stored in the registry. HKEY_L...

684: SQL Server Optimization Tips Index
There are a number of SQL Server allows you to detect, adjust and optimize the performance of SQL Server tools. In this article, I will explain how to use SQL Server database tools to optimize the use of the index, the paper also relates to the gene...

685: Remote detection of MS SQL Server security account
ODBC is an open data interconnection (Open Database Connectivity) abbreviation, it is a database for remote access (mainly relational database) unified interface standard. Under the realities of the use of ODBC is a database access library, It prov...

686: In SQL Server 2K to achieve case-sensitive query (WHERE ...)
- Create the following user-defined function (UDF) CREATE FUNCTION StrComp (@ Str1 VARCHAR (50), @ Str2 VARCHAR (50)) - ALTER FUNCTION StrComp (@ Str1 VARCHAR (50), @ Str2 VARCHAR (50)) RETURNS INTEGER AS BEGIN DECLARE @ i INTEGER - DECLARE @...

687: In Microsoft SQL Server 2000 data warehousing using district
Abstract: This article describes how to use the district to improve the SQL Server 2000 Enterprise Edition in the Data Warehouse manageability, query performance and load speed, and discuss the relational database and analysis services to multi-dime...

688: MSSQLServer in Linux to access the database
---- Linux as a free Unix-type operating system, with its open source code, multi-tasking, X?? Window and other features used by large number of users, and there are many enterprises to adopt Linux as their internal network-wide function server (WWW...

689: In SQL Server stored procedure to deal with error
SQL Server stored in the process of "error handling" is just wrong to return to the client, access providers can usually do. But at least you can know that T-SQL in the implementation of a time when far more than what the error occurred. I...

690: In the SQL Server running on the computer where the virus scanning software
Q: What if I need to have SQL Server running on the machine running virus-scanning software so that we will not affect the performance? A: The answer to that question depends on the operation you want the type of virus scanning software. There are ...

691: In SQLServer how to recover data in the storage
In SQL Server provides a way to restore this stored procedure. A database consists of two files, mdf and ldf database files log files 1.sp_attach_db [@ dbname =] 'dbname', [@ filename1 =] 'filename_n' Add a database to the system,...

692: Based on how the release procedure for MS SQL Server
Many of my friends in the preparation of the completion of the procedures based on the SQLServer procedure to release a headache because only published applications and BDE is not enough, it is necessary to install SQLServer Client software, can als...

693: How to obtain the optimal performance of SQL Server
In order to maximize the optimization of SQL Server performance, first of all you must determine the number of areas. When the optimization of several aspects, they can raise the maximum system performance. Then you can analyze several aspects of th...

694: Support for the SQL Server full-text search extension
Margaret Li (program managers, data access) and Frank Pellow (program manager, SQL Server relations Abstract Microsoft SQL Server 7.0 version of the introduction of a variety of functions, support for the presence of SQL Server itself in several of ...

695: The implementation of a secure SQL Server installation
Collection and dissemination of data is one of the responsibilities of network management, and the need to ensure the accuracy of these data and security. No matter what their operating system, database servers require special management to ensure t...

696: MS SQL Server2k deployment of Data Transformation Services
1. Goals MS SQL Server bigger amount of data transmission, we mostly used data transmission services. Now assume, in the development environment, we have designed a DTS package and runs well, the next thing is we have to do the migration and deploy...

697: How to use SQL statements to achieve classification
How to use SQL statements to achieve the following objectives? Database: MS SQL 2000: drop table mytest go create table mytest ( sn int, code varchar (8), ins_no varchar (6), ) go insert mytest values (1,'01 ',' A ') inse...

698: MSSQL database to generate the entire SQL script tools
the path to the right scptxfr.exe declare @ cMd varchar (1000) set @ cmd = 'master.dbo.xp_cmdshell' + '' 'c: \ "Microsoft' + 'SQL Server "' + '\ MSSQL \ Upgrade \ scptxfr.exe' + '/ S YourSe...

699: Random sequence of the algorithm
Found the two algorithms, the first a very simple, but not random, the second is a typical pseudo-random number algorithms, but use to 2 millions of this great power of integer, real pain if there is calculated on UNIX password of the source code li...

700: Search results page to display sql statement
Four ways to get table record n to m Article: 1. select top m * into a temporary table (or table variable) from tablename order by columnname - will insert the top m T set rowcount n select * from table order by columnname desc variable 2. sel...


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