SQL SERVERÖÐÒ»Ð©ÌØ±ðµØ·½µÄÌØ±ð½â·¨
SQL code
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-04-20 20:10:41
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 6.1 <X86> (Build 7600: )
-- CONTENT£ºSQL SERVERÖÐÒ»Ð©ÌØ±ðµØ·½µÄÌØ±ð½â·¨2
----------------------------------------------------------------*/
--1.¹ØÓÚwhereɸѡÆ÷ÖгöÏÖÖ¸¶¨ÐÇÆÚ¼¸µÄÇó½â
SQL code
--»·¾³
create table test_1
(
id int,
value varchar(10),
t_time datetime
)
insert test_1
select 1,'a','2009-04-19' union
select 2,'b','2009-04-20' union
select 3,'c','2009-04-21' union
select 4,'d','2009-04-22' union
select 5,'e','2009-04-23' union
select 6,'f','2009-04-24' union
select 7,'g','2009-04-25'
go
ÎÒÃÇÒ»°ãͨ¹ý datepart(weekday )½øÐÐÇó½â£¬±ÈÈçÇó½âÐÇÆÚ2µÄ¼Ç¼
select * from test_1
where DATEPART(WEEKDAY,t_time+@@DATEFIRST-1)=2
/*
id value t_time
----------- ---------- -----------------------
3 c 2009-04-21 00:00:00.000
*/
ÕâÀïÉæ¼°µ½ @@datefirst Õâ¸öϵͳ±äÁ¿£¬Ò»°ãÎÒÃÇÓÃÀ´µ÷½Ú²»Í¬µØ·½µÄÈÕÆÚϰ¹ß¡£
Èç¹ûÄã¾õµÃ¹ØÓÚÕâ¸ö±äÁ¿ºÜÄÑÒ²ÀÁµÃÈ¥ÒÀÀµËüµ÷½Ú£¬ÕâÀﻹÓÐÒ»ÖÖ·½·¨
Äã¿ÉÒÔʹÓÃÒ»¸ö²ÎÕÕÈÕÆÚ,ͨ¹ýÏàͬÐÇÆÚÊý³É7µÄ±¶ÊýµÄÔÀí½øÐвéѯ
select * from test_1
where DATEDIFF(DAY,'1900-01-02',t_time)%7=0
/*
id value t_time
----------- ---------- -----------------------
3 c 2009-04-21 00:00:00.000
*/
--2.¹ØÓÚÔÚwhereɸѡÆ÷ÖÐÖ¸¶¨´óСд²éÕÒµÄË÷ÒýÒýÓÃÎÊÌâ
SQL code
--»·¾³
--drop table test_2
create table test_2
(
id int identity(1,1),
value varchar(10)
)
insert test_2 select
'abc' union all select
'Abc' union all select
'ABC' union all select
'aBc'
go
create clustered index in_value on test_2(value)
--ÎÒÏÈÒª²éÕÒ ÖµÎª'ABC'µÄ¼Ç¼ 񻂿·Ö´óСдµÄ
select * from test_2
where value COLL
Ïà¹ØÎĵµ£º
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\' \',\'\'),\':\',\'\')
20040912110608
select CONVERT(varchar(12) , getdate(), 111 ) ......
sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ´æÔÚÁË¡£
½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ
sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......
ijÏîĿ֮ǰµÄÊý¾Ý¿âÓб仯£¬µ«ÊÇÒÔǰдµÄ³ÌÐòÊÇÖ§³ÖÀÏÊý¾Ý¿âµÄ£¬ÐÂÊý¾Ý¿âÓÐһЩÎÊÌ⣬ÐèÒªÐ޸쬵«ÊÇÊý¾Ý¿â¾ÍÖØ¸´ÁË£¬ÓÚÊǾÍÒª°Ñ¿ª·¢»úÉÏ֮ǰµÄÊý¾Ý¿âÖØÐÂÃüÃû¡£
ÕâÀï¼Ç¼һϲ½Ö裨¾ÉÃû³Æ£ºMobileMsg£¬ÐÂÃû³Æ£ºMobileMsg_old£©£º
1¡¢¹ØµôÆóÒµ¹ÜÀíÆ÷£¬´ò¿ª²éѯ·ÖÎöÆ÷£»
2¡¢ÐÞ¸ÄÊý¾Ý¿âÃû³Æ£º
EXEC sp_dboption 'MobileMs ......
--------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-23 08:08:36
-- Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul  ......
1¡¢°²×°Sql Server2005 Mobile Edition£»
2¡¢¾ßÌåÔÚ´´½¨Ò»¸ö¹¤³ÌÒÔºó£¬ÏëʹÓÃSqlServerCe±ØÐëÔÚ×Ô¼º¹¤³ÌµÄÒýÓÃÀïÃæÌí¼ÓÒ»¸ödll²ÅÐУ»
ÆäĿ¼ÔÚ£ºC:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\System.Data.SqlServerCe.dll
Ìí¼ÓÁËÒÔºó¾Í¿ÉÒÔʹÓÃMobileµÄһЩÊý¾Ý¿â²Ù×÷µÄÀà¿âÁË¡£ ......