Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


401: I have learned with SQL: a data query
I have learned with SQL: a data query Not to mention whether you are engaged in the work program or do not intend to learn SQL, can be a matter of fact almost every developer will eventually hit it. You do not need most of them also responsible for...

402: Follow me SQL: Second SELECT statement options
Follow me SQL: Second SELECT statement options Follow me SQL is divided into three parts, which cover the basic knowledge of SQL standards. In the last article we discussed a number of database terminology and four kinds of basic types of data quer...

403: Follow me SQL: Three sub-options to the use of combined SQL query
Follow me SQL: Three sub-options to the use of combined SQL query Do you have in order to obtain the required information and repeated inquiries? Sub-option, also known as sub-query, perhaps it is you are looking for. This SQL function allows you t...

404: Follow me SQL: four inquiries a number of forms
Follow me SQL: four inquiries a number of forms Across multiple forms of data combination, and sometimes it is difficult to figure out which one to use SQL syntax. I will be here on a number of forms will be combined in a single query statement, th...

405: Follow me SQL: Create and modify tables five
Follow me SQL: Create and modify tables five Once again welcome you to SQL (Structured Query Language) based on series of tutorials. This article will introduce the database definition language (DDL) used to create databases and forms, as well as t...

406: Follow me SQL: Six types of serial data
Follow me SQL: Six types of serial data SQL data type determines the contents of a field in the database will be how to deal with, storage and display. The definition of a standard SQL92 data types, the purpose is to establish its own database of m...

407: Follow me SQL: seven from the exterior to delete sub-data
Follow me SQL: seven from the exterior to delete sub-data In this article I would like to describe how to delete rows from the table, it is necessary to delete these out at the same time, dependent on other forms of standards. To resolve this probl...

408: Follow me SQL: 8 Numerical data types
Follow me SQL: 8 Numerical data types SQL92 standard definition of a number of basic data types, which are SQL database based on a variety of data types. In the "string data type," a text, we have discussed in detail the criteria as defin...

409: Follow me SQL: 9 datetime and interval data types
Follow me SQL: 9 datetime and interval data types datetime and interval time are two types of related data. Their role in the following areas: to create or change records of a particular record, the time when a running record of time, or datetime c...

410: Entry and improve the storage process
Entry and improve the storage process What is this stored procedure? Has been defined with the function of stored procedure when the same service, simply call the execute, the command will automatically be completed. SQL statement is no more than...

411: SQLServer2000 installation and the basic framework
SQL Server 2000 installation and the basic framework SQL Server, we always talk about this word, perhaps very few people thought about SQL Server in the end what it is. The problem difficult to clear a few words. We have discussed ways to use seria...

412: Database of commonly used simple SQL statement summary
Database of commonly used simple SQL statement summary It easier to understand SQL statement that I cited, this article assumes that students have established a performance management database, the full text of the management of student achievement...

413: Basic knowledge of SQLServer Connection
Basic knowledge of SQL Server connections Introduction Communication, so Windows applications with SQL Server is only a matter of communicating the use of two commonly used Object Library, or OLE DB and ADO.NET. As a result of the adoption of ADO ...

414: mssql table book to read the names of keys as a "default" of the key
mssql table book to read the names of keys to the default key Executive: Quote: EXEC master.dbo.xp_regenumvalues HKEY_CLASSES_ROOT, CLSID \ "0D43FE01-F093-11CF-8940-00A0C9054228" \ ProgID Return to: Value Data 1 NULL Scripting.FileSy...

415: UNIX server settings for Oracle Full Text Search
UNIX server settings for Oracle Full Text Search At present, almost all full-text search functions in support of the mainstream databases. Previously I had sql server 2000 to achieve, the feeling is very simple, convenient, full-text search index t...

416: Undisclosed MsSQLServer encryption function
Undisclosed MsSQLServer encryption function MSSQL if the user information of interest may be found inside the store master.dbo.sysxlogins a user's password, but then, password field is null, if not a bunch of can not read the binary, the passwo...

417: SQL injection attacks completely summarize articles
SQL injection attacks completely summarize articles SQL injection attacks on the 1st pass 1. Found that the location of SQL injection; 2. To determine the type of back-end database; 3. XP_CMDSHELL executable to determine the situation 4. Found ...

418: I was outside the SQL related to the solution
I was outside the SQL related to the solution Go look at the past, was "sysadmin" can not log in, it is being held to the outside, this may be some trouble, friends do not want to reinstall SQL, had no choice but to turn the information, ...

419: How to make MySQL more secure?
How to make MySQL more secure? All other information as any person can read the text to be transmitted. If you are worried about this, you can use the compressed protocol (MySQL3.22 and above) to make things more difficult. In order to make everyth...

420: Modified method of MySQL password
Modified method of MySQL password MySQL is a true multi-user, multi-threaded SQL database server. MySQL is a client / server structure to achieve it by a server daemon mysqld and many different client programs and libraries of components. Because o...


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