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.

Problem One of the first things to do when managing SQL Server is to establish an appropriate backup plan to minimize the loss of any data in a failed event. After setting up a backup plan, of course, you have to do some database configuration,

Which strategy is better? Partitions can be implemented either by using one of these two policies or by combining two policies effectively. For strategies I and Strategy II, refer to the table below, which explains the effects of these two

OK, we first create a database: Data_test, and create a table in this database: tb_testtable Create DATABASE Data_test--Creating databases Data_test Go Use Data_test Go CREATE TABLE Tb_testtable--Creating tables ( ID int identity (1,1)

--Simple query --Projection Query /* Simple Query Keyword Description: All: Specifies that all records are displayed, including duplicate rows. All is the default setting. Distinct: Specifies that all records are displayed, but does not include

These days because of need, always want to install SQL Server 2008来 as a Web background database to do some experiments, but there is always no time, today finally have time, then installed SQL Server 2008, the following is my installation steps, I

Copy Code code as follows: /* --sqlserver capitalize the first letter of the string: --Author: jinjazz/csdn --sqlserver2005 Enable oleautomation sp_configure ' show advanced options ', 1; Go Reconfigure; Go sp_configure ' Ole

DateTime and smalldatetime represents the date and time data type for the date and time of day. Microsoft SQL Server stores values for datetime data types within two 4-byte integers. The first 4 bytes stores the number of days before or after base

The first time to see such a SQL statement, do not understand, which used the following less common Aggregate functions: GROUPING Operator used to summarize data: ROLLUP SELECT Case GROUPING (O.customerid) when 0 THEN

Begin A while ago, there was an SQL query requirement in the project, with two tables of the same structure (Table_left & Table_right), as follows: Figure 1. Examine the groups (GROUPID) of the table table_left, and whether there is a set of

server| function//in PHP processing date is very inconvenient, such as the two date difference between the month? What should we do? FileName: date.inc.php3 Before you use these two functions, you must first convert the date or datetime to the

This article summarizes the SQL Server 2005 Command prompt utility for reference learning applications. Practical Tools Description Installation location bcp utility Used to copy data between a Microsoft SQL Server

Server Ningbo Bonded Area official Committee computing Center Dong Baohua ----Linux as a free Unix-like operating system, with its open source code, multitasking, Xwindow and other features for many users, and many enterprises adopt Linux to A

server| function 1. String function Length and analytical use DATALENGTH (char_expr) returns the string contains the number of characters, but does not contain the trailing spaces SUBSTRING (expression,start,length) Don't say much, take the

Data Explorer is a new feature in the upcoming SQL Server 2014, which is a feature that makes self-service business intelligence in an enterprise more flexible and thus lowers the threshold for business intelligence. This article is found in the

The configuration options for SQL Server servers are those that people understand less and are often misused. When a technical support person asks you to adjust an option in some way, and another technical support person asks you to adjust the same

A Introduced Some "super users" with access to data have learned professional Transact-SQL. The convenience of the Report Builder in SQL Server 2005 Report Services (SSRS) extends to the creation of powerful Transact-SQL queries, making it easier

This article discusses some of the new features of SQL Server 2005 that will help you create a new type of database application. The way database development is changing as Microsoft SQL Server, the release of Beta 2, is released. As a database

This paper gives the basic concept of SQL Server Data Warehouse, and uses the example construction process to analyze, for everyone's reference! Basic concepts: 1. Cubes: Cubes are the primary object of online analytical processing (OLAP) and are

vb language using ADO to connect and manipulate SQL Server database tutorialThis article mainly introduces the VB language using ADO connection, operation SQL Server database tutorial, this article explains in detail, the code has a lot of comments,