SQL Server

ado|server| Firewall 1. The firewall must be configured to allow port 1433 to be introduced, and 1024-65535 for outgoing ports 2. The connection string must specify the SQL Server address: IP address, server DNS name, or name in the host file 3.

Most iterative language compilers have built-in error handlers (for example, TRY ...). Catch statements, developers can use them when designing code. Although SQL Server 2000 developers cannot take advantage of built-in tools like the developers of

Delphi is an excellent visual software development environment, and has been widely used in the development of database software. In the DELPHIC/S version environment, combined with its optimized database operation, and Borland db Engine (i.e.: BDE,

This article describes how to use SQL Server database query cumulative values, for example analysis. There is a requirement that it create a SQL Server query that includes cumulative values based on the event time. A typical example is a bank

The Silent SQL Server 2005 installation is a possible two steps: 1) Create a Setup.ini file The template file contained in the SQL Server CD is called Template.ini. On this basis, you create another ". ini file" that contains a single [Options]

Here's how I've verified the automated backups that are available. 1, open Enterprise Manager-> Management->sql Server Agent 2, create a new job, the name of the job to take, for example: Data backup, the owner Select SA, of course, you can also

During the development of the database, the complex business logic and the operation of the database are often encountered, and the SP is used to encapsulate the database operation. If there are more SPS in the project, writing and there is no

Here are a few of my statistical options: first Scenario (recursive): The simple table structure is: CategoryID Int (4), CategoryName nvarchar (50), ParentID Int (4), Depth Int (4) In this way, according to the parentid level of the use of

Server| Stored Procedure | Execute Execute A user-defined function, system procedure, user-defined stored procedure, or extended stored procedure that performs a scalar value. Also supports the execution of strings within Transact-SQL batches To

I. BACKGROUND Previously wrote an article about: SQL Server cursor Usage: View a database of all table size information (sizes of all tables in a DB), which lists information about all tables of a data, including the number of records in a table,

Creating a new SQL Server system can be tricky. SQL Server is a product that really focuses on hardware, and its performance has a lot to do with how you configure the server, especially how to configure your server's storage subsystem. With this in

First, Introduction Microsoft SQL Server 2000 's XML functionality simplifies the task of providing existing code as a Web service. This article focuses on the transformation between incoming and outgoing Transact SQL code data and XML messages

View Restrictions To create an index on a view in SQL Server 2005, the corresponding view definition must include: Any, not any OPENROWSET, OPENQUERY, OpenDataSource Arithmetic OPENXML on imprecise (floating, real) values COMPUTE, COMPUTE by

Although SQL Server 2008 has so far been considered a new version of the database system. But it will continue to update. For this reason, database administrators still need to consider backward compatibility issues when deploying SQL Server 2008.

In the process of installing SQL Server 2012 on a Windows Server 2012 server, an error was reported, an installation failed,In the process of installing SQL 2012. The following error occurred: An error occurred while enabling Windows feature NetFx3,

Some problem solving methods for installing sqlserver20081, the installation of SQL Server appears as shown, the solution is: start → run → input "regedit" → find "hkey_local_machine\system\currentcontrolset\control\session Manager "Click the item

SQL Server Data Recovery to pointing point in time (Full recovery)When it comes to database recovery, in fact, we generally have two of the most common, one is simple recovery, through the backup bak file directly to restore the database, the

Functions in a database are similar to functions in C #sequentially,The price is special here.Print can be printed in the Message bar.Mathematical functionsCeiling () The upper limit does not care how big the decimal point is, directly ignoreFloor ()

Databasedefinition : Some data files stored on the hard diskMemory:Some data that the computer temporarily stores. Net-sql ServerPhp-mysqlJava-oreaclData types in the database:int decimal (length, number of decimal digits)Bit-Boolean type 1-true

Analyze and compare execution time plan reads1. View execution time and CPUSET STATISTICS Time Onselect * from Bus_devhistorydataset statistics time offYou can see it in the message after execution.2. View the operation of the query for I/OSET