SQLÐÐתÁÐ ÁÐתÐÐ
--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ׶® ÕûÀíÈË£ºÖйú·ç
(Roy)
ÈÕÆÚ
:2008.06.06 ******************************************************************************************************************************************************/
--1¡¢Ðл¥ÁÐ
--> --> (Roy)
Éú³É測試數據
if
not
object_id
(
'Class'
)
is
null
drop
table
Class
Go
Create
table
Class(
[Student]
nvarchar
(
2
),
[Course]
nvarchar
(
2
),
[Score]
int
)
Insert
Class
select
N
'ÕÅÈý
'
,N
'ÓïÎÄ
'
,
78
union
all
select
N
'ÕÅÈý
'
,N
'Êýѧ
'
,
87
union
all
select
N
'ÕÅÈý
'
,N
'Ó¢Óï
'
,
82
union
all
select
N
'ÕÅÈý
'
,N
'ÎïÀí
'
,
90
union
all
select
N
'ÀîËÄ
'
,N
'ÓïÎÄ
'
,
65
union
all
select
N
'ÀîËÄ
'
,N
'Êýѧ
'
,
77
union
all
select
N
'ÀîËÄ
'
,N
'Ó¢Óï
'
,
65
union
all
select
N
'ÀîËÄ
'
,N
'ÎïÀí
'
,
85
Go
--2000·½·¨
:
¶¯Ì¬:
declare
@s
nvarchar
(
4000
)
Set
@s
=
''
Select
@s
=
@s
+
','
+
quotename
(
[Course]
)
+
'=max(case
when [Course]='
+
quotename
(
[Course]
,
''''
)
+
'
then [Score] else 0 end)'
from
Class
group
by
[Course]
exec
(
'select [Student]'
+
@s
+
'
from Class group by [Student]'
)
Éú³É¾²Ì¬:
select
[Student]
,
[Êýѧ
]
=
Ïà¹ØÎĵµ£º
CREATE PROCEDURE [dbo].[PUB_CORP_SEARCH]
@oi_return INT OUTPUT , ......
ÍøÕ¾£ºhttp://werysoft.com/
Èç¹ûÄú±ØÐë¹ÜÀí»·¾³ÖеĶàÖÖÀàÐ͵ÄÊý¾Ý¿â·þÎñÆ÷£¬ÔòʹÓü¯ÖÐʽ¹¤¾ßµ÷ÕûËùÓÐÊý¾Ý¿â¿ÉÄÜ»á±È½Ï·½±ã¡£Werysoft µÄ QweryBuilder Ö¼ÔÚΪÄúÌṩ´ËÏÄÜ¡£Äú¿ÉÒÔʹÓÃËü´Óͬһ GUI Á¬½Óµ½ Microsoft SQL Server¡¢Sybase ASE¡¢SQL Anywhere ºÍ Oracle ʵÀý£¬È»ºó²é¿´¡¢´´½¨¡¢¸üкÍɾ³ýÊý¾Ý¿â½Å±¾¡¢¼Ü ......
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Xml;
using System.Data;
namespace MyDbTest
{
class Program
{
static void Main(string[] args)
{
SqlConnection thisConnection = new SqlConnection(
@ ......
SQL Server 2000 µÄϵͳÊý¾Ý¿â
SQL Server 2000·þÎñÆ÷°²×°ºó»á½¨Á¢4ϵͳÊý¾Ý¿â¡£·Ö±ðÊÇmaster¡¢model¡¢msdb¡¢tempdb¡£
1¡¢masterÊý¾Ý¿â
masterÊý¾Ý¿âÊÇSQL Server 2000ÖÐ×îÖØÒªµÄÊý¾Ý¿â£¬¼Ç¼ÁËSQL Server 2000µÄ·þÎñÆ÷¼¶ÏµÍ³ÐÅÏ¢£¬°üÀ¨ËùÓÐÕË»§ºÍÃÜÂ룬´ÅÅ̿ռ䡢Îļþ·ÖÅäºÍʹÓá¢ÏµÍ³¼¶µÄÅäÖòÎÊý¡ ......