Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


621: Delete data
11.2.1 DELETE Syntax DELETE statement to delete data from the table, the syntax is: Each parameter as follows: FROM This parameter is optional option, used to connect DELETE keyword and the data you want to delete the name of the object. table_...

622: Index View
We have already mentioned in the previous view about the following point of view: As the view of the result set to return to the ranks of the structure with the table have the same tabular form, and we can be in SQL statement, as quoted as quoted in...

623: Database Update - add data
Ability to maintain a database of information accuracy, timeliness, to a large extent dependent on the database update function of the strength and real-time. Database updates, including insertion, deletion, modification (also known as updates) to o...

624: Full-text search database
SQL Server 2000 of the Standard Edition and Enterprise Edition version of the table provides the complexity of the data search string --- Full Text Search (Full-Text Searches). This feature requires the installation through the custom installation o...

625: Results storage
Messages often need to be preserved in order to use. SELECT statement used to query the data, you can set the data storage to a new table or variable. 10.6.1 store the query results table SELECT ... INTO statement using the query results can be st...

626: View Profile
View is from one or more table or view in the export table, its structure and data is based on the table based on query. And table, the view is defined including the number of data columns and multiple rows of data, but on the very nature of these d...

627: Merger inquiries
Merger inquiries UNION operator is used to query data from different combinations to form a comprehensive information of the query results. UNION operation will automatically remove duplicate rows of data. It should be noted that the combined query ...

628: Process management using the system cursor
After the establishment of a cursor will use the system to manage the process of management of the cursor, the cursor of the system mainly in the following process: sp_cursor_list, sp_describe_cursor, sp_describe_cursor_tables, sp_describe_cursor_co...

629: sql diary (related subquery, dynamic crosstab articles)
Also recently re-read the books about sqlserver, mainly about the view of the relevant sub-sql queries and cross-table knowledge. Related subquery subquery and the general difference is: quoted-related subquery column external inquiries. This abil...

630: Sql Server Basic functions
1. String length function analysis datalength (Char_expr) to return the string that contains the number of characters, but does not include the spaces behind substring (expression, start, length) not more than that, check substring right (char_ex...

631: SQL query syntax documentation
A, SQL query language intensive structure (SQL) relational database is used to query the standard language, which includes the same number of keywords and syntax for the database components (such as tables, indexes, fields, etc.) the establishment a...

632: xp_cmdshell
To the operating system command line interpreter implementation of a given command string, and return to the text of any output line. Granted a non-administrative user permissions xp_cmdshell. In Microsoft ® Windows ® 98 operating system ...

633: From the dynamic SQL in the return value
declare @ TransactorID int set @ TransactorID = 0 print (@ TransactorID) - exec sp_executesql N'select @ TransactorID = 68 ', N' @ TransactorID int ', @ TransactorID exec sp_executesql N'select @ TransactorID = 5 ', N'...

634: SQL Server in the pattern matching
SQL Server Books Online search above like, found a few %,_,[],[^] contain wildcards. Such as: select * from mybbs where Content like '[w]%' like keywords used to search for a pattern matching string, or date time value. SQL Server Books i...

635: Locking mechanism of MS SQL
Lock overview 1. Why should the introduction of lock Multiple users at the same time the concurrent operation of the database will have the following problem of data inconsistencies: Lost update A, B two users read and modify the same data, in w...

636: Used in the SQL Server stored procedure code
First created in the SQL Server stored procedure is as follows: CREATE PROCEDURE InsertOrtho (@ ChildID varchar (10) out, @ date datetime out, @ therapistID varchar (10) out, @ clinicID integer out, @ skeletal varchar (1) out, @ angleClass va...

637: Can not be used as "sysadmin" log on SQL Server how to do?
Do not have to re-install SQL Server. To re-visit the SQL Server, you need to modify SQL Server 2000 and SQL Server 7.0 decided to SQL Server authentication mode registry key. In SQL Server 7.0, the key is: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsof...

638: SQL Server data object the establishment of the dynamic structure and access
Microsoft SQL Server and ORACAL, Sybase is more popular in the current database management system (RDMS), with SQL Server's continuous improvement and development, as well as Windows NT network operating system with the perfect combination for d...

639: ado how to use the sql function
SQL function Using SQL function, you can SELECT statement in a query, the direct calculation of the level of database information Average, the total number of minimum, maximum, sum, standard deviation, variance and other statistics. Recordset obje...

640: The use of stored procedures in use database
It's well known.Microsoft SQL Server is not allowed in stored procedures or triggers in the database using the USE statement to change the current database. How do? Can, of course, the direct use of [databasename]. [User]. [Tablename] to do to ...


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