Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


241: About SQLServer Full Text Search
About SQLServer Full Text Search Full-text indexing and full-text search sql server 7.0 is a new feature, it can be of data type out of character (for example, varchar, text and other types of column) index, and through the realization of the full ...

242: SQLMail transceiver and the use of automatic processing of e-mail
SQLMail transceiver and the use of automatic processing of e-mail SQL SERVER or provided through EXCHANGE expansion OUTLOOK to send and receive e-mail storage process, the process of following a few simple to explain. First, start SQL Mail xp_sta...

243: The stored procedure in SQLServer to call COM components
The stored procedure in SQLServer to call COM components SQL server in T-Sql function of language is very powerful, but when there is some restrictions and inconvenience, one day, like why do not like tofu asp components, like a lot of use it? said...

244: SQLServer in single quotation marks to deal with the two techniques
SQLServer in single quotation marks to deal with the two techniques And databases to be frequently used to deal with SQL statement, unless you are all bundled with controls, but the way the use of binding controls the flexibility of the existence o...

245: How to recover data in SQLServer
How to recover data in the SQLServer in the SQL server to restore data in several ways: 1. Nature is a backup method to restore the backup method is the safest, most reliable way to operate is also very simple, as long as the sql server in enterpri...

246: SQL2000 How to generate XML
SQL2000 How to generate XML Introducing SQL2k ago when SQL2k has been referred to the support of XML, use for XML statement can be very easy to implement the results into a XML, to a large extent this can improve system efficiency and the developme...

247: Also talk about how to reduce the log file SQLSERVER
Also talk about how to reduce the log file SQLSERVER also met a few days before the log file too big problem, the actual size of the database for the 600M, the actual size of the log file for the 33M, but the log file space for the 2.8G!!! Tried a ...

248: How can we limit the SQLServer only designated machines connected
How can we limit the SQLServer only designated machines connected Q. How can I restrict access to my SQL Server so that it only allows certain machines to connect? (v1.0 19.10.1998) How can I restrict the SQL Server can only connect the machine t...

249: SQL tips
SQL tips These has been picked up from thread within sqljunkies Forums sqljunkies.com / "> http://www.sqljunkies.com Problem The problem is that I need to round differently (by halves) Example: 4.24 rounds to 4.00, but 4.26 rounds to 4.5...

250: Stored in SQLServer and output image
Stored in SQLServer and output image Next 1 2 3 Saved in the SQL Server and the output picture cashcho (translation) Keyword SQL Server images Source http://www.bipinjoshi.com/ Introduction Sometimes we need to save some binary data into the ...

251: 6 kinds of data methods SQLServer7 Mobile
6 kinds of data methods SQLServer7 Mobile Next 1 2 1. Through the DTS Designer tool to import or export DTS Designer The powerful, multi-task and visual interface, easy to operate, but generally not much to know, if only for part of SQL Server da...

252: Sql statement of the security vulnerabilities Password Authentication
Password Authentication Sql statement Sql statement of security vulnerabilities as an international standard database query language in a variety of programming environments has been widely used. As a mature and stable system, the user login and pas...

253: SQLServer database maintenance
SQLServer database using the database maintenance process, as a result of power outages or other reasons, it may lead to some minor errors in the database, such as slow access to certain tables in particular, can not meet the conditions of query dat...

254: Examples of presentation of the opening of the SQL Full Text Search
Examples of presentation of the opening of the SQL Full Text Search How to enable SQL full-text search feature? Examples of this article to you through this issue post-folding. This is a full-text index of an example, the first use in Query Analyze...

255: With the date of the two classic SQL statement
With the date of the two classic SQL statement Next 1 2 3 1. With a statement where a certain date to draw the greatest number of days in the month? SELECT DAY (DATEADD (dd,-DAY (2004-02-13), DATEADD (mm, 1, 2004-02-13))) AS Day Number 2. Less r...

256: Mobile hard disk files using SQL
Mobile hard disk files using SQL The following code will demonstrate how to use SQL database of the mobile hard disk file: ...

257: Best use of SQL query summary
Best use of SQL query summary Next 1 2 3 4 A simple query Simple Transact-SQL query including the selection list only, FROM clause and WHERE clause. They are looking for that out, query or view, as well as the search conditions. For example, the...

258: SQL Data Manipulation basic (primary) 1
SQL Data Manipulation basic (primary) 1 In order to establish the interactive site, you need to use the database to store information from visitors. For example, you want to build a site with job placement services, you need to store, such as biogr...

259: SQL Data Manipulation basic (primary) 2
SQL Data Manipulation basic (primary) 2 SELECT queries using ISQL implementation When you install SQL Sever, you called at the same time installed a ISQL / w application. ISQL / w to allow you to implement interactive SQL query. Included in the qu...

260: SQL Data Manipulation basic (primary) 3
SQL Data Manipulation basic (primary) 3 Field operations Typically, when you retrieve from a table field values, the value created by the definition of the table linked to the field names. If you select the authors from the table all the author...


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