Sql 2005启动不了，报错如下时的解决办法！
解决办法：
开始->programs->MicroSoft SQL Server 2005->Configuration tools->SQL Server Configuration Manager
选择 SQL Server 2005 Network Configuartion-> Protocols for SQL ExpRESS 再 选择 TCP/IP 属性 ,选择IP Addresses
IP1 的 IP Address 请确认是 你服务器的 IP地址 ， 如果服务器为本地的话。在网上邻居看一下IP 地址 填上。IP 2 为 127.0.0.1
---------------------------------------------------------------------------------------------------------------
报错如下：
2009-11-04 10:30:08.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2009-11-04 10:30:08.96 Server (c) 2005 Microsoft Corporation.
2009-11-04 10:30:08.96 Server All rights reserved.
2009-11-04 10:30:08.96 Server Server process ID is 1344.
2009-11-04 10:30:08.96 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-04 10:30:08.96 Server This instance of SQL Server last reported using a process ID of 1512 at 2009-11-4 10:28:23 (local) 2009-11-4 2:28:23 (UTC). This is an informational message only; no user action is required.
2009-11-04 10:30:08.96 Server Registry startup parameters:
2009-11-04 10:30:08.96 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-04 10:30:08.96 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-04 10:30:08.96 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSS
相关文档：
USE [master]
GO
/****** 对象: StoredProcedure [dbo].[sp_backupdatabase] 脚本日期: 07/15/2009 16:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[sp_backupdatabase]
@bak_path nvarchar(4000)='', ......
1.创建表
(1)用Create Table 命令创建表
语法:
Create Table tabl_name
({
}column_name As computed_column_expression
}
}[，...n]
)
[On {fiegroup | Default}]
[Textimage_On {fiegroup | Default}]
例子:
打开cust数据库，创建一个表，该表包含了学生的有关信息，即有学号、姓名、性别、出生� ......
这几天用了一下Microsoft SQL Server 200的分析服务，贴出来给大家分享一下。
请多多指正。谢谢。
一、需求：
建立一个图书订单统计系统
1、统计各个图书馆订单数量。
2、统计各个图书馆订单的各个状态的数量占该图书馆的订单数量的百分比。
3、同时统计原始数量和储运数量
二、数据表
� ......
Comparison of SQL and MDX Syntax
The Multidimensional Expressions (MDX) syntax is similar to the syntax of Structured Query Language (SQL). In many ways, the functionality supplied by MDX is also similar to that of SQL; with effort, you can eve ......
