SQLServer¸ß¼¶±à³Ì
±¾ÆªÄÚÈÝϵÊôSQLServer¸ß¼¶±à³Ì£¬ÊÊÓÃÓÚÓûÌá¸ß×Ô¼ººÍ¸´Ï°»òÓ¦¸¶ÃæÊÔµÄÅóÓÑÔĶÁ£¬Í¬Ê±±¾ÈËѧϰ²»¾Ã£¬ÔÚ×ܽáºÍ¹éÄÉʱ´íÎóºÍ²»Ç¡µ±Ö®´¦ÔÚËùÄÑÃ⣬»¹ÇëÖ¸³öÆäÖБ¶ËÄß’£¬ÓèÒÔÍêÉÆ¡£
±í1:Users
USE [Wish]
GO
/****** ¶ÔÏó: Table [dbo].[Users] ½Å±¾ÈÕÆÚ: 01/29/2010 13:26:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [varchar](16) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Nickname] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[Password] [varchar](60) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Email] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Question] [varchar](40) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Answer] [varchar](40) COLLATE Chinese_PRC_CI_AS NOT NULL,
[age] [int] COLLATE ,
[ShowEmail] [bit] NOT NULL CONSTRAINT [DF_Users_ShowEmail] DEFAULT ((1)),
[Signature] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL,
[ImageUrl] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_Users_ImageUrl] DEFAULT (''),
[AddedDate] [datetime] NOT NULL CONSTRAINT [DF_Users_AddedDate] DEFAULT (getdate()),
CONSTRAINT [PK_Users_UserID] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UK_Users_UserName] UNIQUE NONCLUSTERED
(
[UserName] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Ò».¸ß¼¶²éѯ
1.¾ÛºÏº¯Êý£¨ÓÃÓÚͳ¼Æµ¥ÕűíÀïµÄÐÅÏ¢£©¡£
.³£Óú¯Êý£ºAVG() Çóƽ¾ùÊý COUNT() ·µ»Ø·ûºÏÌõ¼þµÄÐÐÊý Max() Çó×î´óÖµ MIN() Çó×îСֵ SUM() ÇóºÍµÈ¡£
.¾ÙÀý˵Ã÷£¬Èç¹ûÓÐÈçÉϵÄÒ»ÕÅ±í£º
ͳ¼ÆÓû§×ÜÈËÊý  
Ïà¹ØÎĵµ£º
±íA
tmpA:
id name
00 Ãû×ÖA
01 Ãû×ÖB
02 Ãû×ÖC
03 Ãû×ÖD
04 Ãû×ÖE
tmpB:
id class
02 °à¼¶A
06 & ......
»·¾³£ºvs2005+sqlserver2005+PowerDesigner 12
´ò¿ªPowerDesigner 12(ÒÔϼò³Æpd)£¬Ð½¨pdm¹¤³Ì£¬ÈçͼËùʾ£º
×¢£ºdbmsÑ¡ÔñÄúÄ¿Ç°ÐèҪת»»µÄÀà±ð£¬ÎÒÓõÄÊÇsqlserver2005¡£
È»ºóÑ¡Ôñ²Ëµ¥¡¶Êý¾Ý¿â¡·¡¶ÏµÍ³DSN¡·£¬Ñ¡Ôñ»òÕßÌí¼ÓÄúÐèÒªµÄÊý¾Ý¿â£¬ÎÒÕâÀïÑ¡ÔñµÄÊÇsql server¡£ÈçͼËùʾ£º
½¨ºÃ ......
Êý¾ÝÀï(sqlserver) µÄ²Ù×÷ £º
eg £º2008-3-31 10:34 --> 2008-3-31
Ò».½ØÈ¡×Ö·û´®·½Ê½
select substring('2008-3-31 10:34',0,charindex(' ','2008-3-31 10:34'))
¶þ.
Select
CONVERT(varchar, getdate(), 1),--mm/dd/yy
CONVERT(varchar, getdate(), 2),--yy.mm.dd
CONVERT(varchar, getdate() ......
SQLServerÖÐDatetimeÀàÐÍÊý¾ÝµÄ±È½Ï
2009Äê02ÔÂ20ÈÕ ÐÇÆÚÎå 16:40
/* ¶¨Ò忪ʼÈÕÆںͽáÊøÈÕÆÚ*/
declare @date_a datetime,@date_b datetime
set @date_a='2009-2-10'
set @date_b='2009-2-12'
/* ÔÚÈÕÆÚdate_a(°üº¬) ºÍdate_b(²»°üº¬) Ö®¼ä*/
select * from ut_article where createtime between @ ......
Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£ ......