Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql ÈÕÆÚת»»

Select  
CONVERT(varchar, getdate(), 1),--mm/dd/yy  
CONVERT(varchar, getdate(), 2),--yy.mm.dd  
CONVERT(varchar, getdate(), 3),--dd/mm/yy  
CONVERT(varchar, getdate(), 4),--dd.mm.yy  
CONVERT(varchar, getdate(), 5),--dd-mm-yy  
CONVERT(varchar, getdate(), 10),--mm-dd-yy  
CONVERT(varchar, getdate(), 11),--yy/mm/dd  
CONVERT(varchar, getdate(), 12),--yymmdd 
 ----´øÊÀ¼ÍºÅ 
select convert(varchar(10),getdate(),100) --06 15 2007 »ò0 
select convert(varchar(10),getdate(),102) --2007.06.15 
select convert(varchar(10),getdate(),103) --15/06/2007 
select convert(varchar(10),getdate(),104) --15.06.2007 
select convert(varchar(10),getdate(),105) --15-06-2007 
select convert(varchar(10),getdate(),106) --15 06 2007 
select convert(varchar(10),getdate(),107) --06-15,200 
select convert(varchar(10),getdate(),108) --10:06:46 µ±Ç°Ê±¼ä 
select convert(varchar(10),getdate(),109) --06 15 2007 »òÕß9 
select convert(varchar(10),getdate(),110) --06-15-2007 
select convert(varchar(10),getdate(),111) --2007/06/15 
select convert(varchar(10),getdate(),112) --20070615select convert(varchar(10),getdate(),113) --15 06 2007 »òÕß13 
select convert(varchar(10),getdate(),114) --10:10:37:0 
select convert(varchar(10),getdate(),120) --2007-06-15 »ò20 
select convert(varchar(30),getdate(),121) --2007-06-15 10:11:45.040 »ò21 
select convert(varchar(30),getdate(),126) --2007-06-15T10:12:44:603s 
elect convert(varchar(50),getdate(),127) --2007-06-15T10:14:35:433 ˵´øÊ±Çø 
select convert(varchar(40),getdate(),130) --»ØÀúdd mon yyyy hh:mi:ss:mmmAM 
select convert(varchar(30),getdate(),131) --30/05/1428 10:17:19:470AM
12Сʱת»»³É24Сʱ
select dateadd(hh,24,getdate())
xml Êý¾ÝµÄת»»
convert(datetime, x.item.value('SaleCEOCheckDate[1]','DateTime'),120) AS SaleCEOCheckDate,


Ïà¹ØÎĵµ£º

×ÔÔö×ֶεÄSQLÓï¾ä½â¾ö·½°¸

create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [ ......

Ò»¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)

/*
±êÌ⣺һ¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê£¬ÊØµÃ±ùɽѩÁ«»¨¿ª)
ʱ¼ä£º2010-05-10
µØµã£ºÖØÇ캽ÌìְҵѧԺ
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐйý²âÊÔ£¬×îºÃÿ´ÎÖ»µ¥¶ÀÔËÐÐÒ»¸öÓï¾ä¡£
ÎÊÌâ¼°ÃèÊö£º
--1.ѧÉú±í
Student(S#,Sname,Sage,Ssex) --S# ѧÉú±àºÅ,Sname ѧÉúÐÕÃû,S ......

oracle³£ÓÃsqlÓï¾ä

ÐÞ¸ÄÁÐÊôÐÔ
alter table tablename modify(name ,varchar2(10)) Áпí¶È²»µÃСÓÚÐÞ¸ÄǰµÄ¿í¶È
ÈÕÖ¾¹ÜÀí
ÊÓͼ v$logfile
alter database add logfile 'd:\orcl01.log' size 10m;//Ìí¼Ó×é
alter database add logfile member 'd:\orcl02.log' to group 4;//Ïò4×éÖÐÌí¼Ó³ÉÔ±
alter database drop logfile member 'd: ......

SQL Server2005 µ¼ÈëÊý¾Ý³ö´í

´íÎóÌáʾ£º
Ö¸¶¨µÄÁ¬½ÓÀàÐÍ“OLEDB”δ±»Ê¶±ðΪÓÐЧµÄÁ¬½Ó¹ÜÀíÆ÷ÀàÐÍ¡£µ±ÊÔͼ´´½¨Î´ÖªÁ¬½ÓÀàÐ͵ÄÁ¬½Ó¹ÜÀíÆ÷ʱ»á·µ»Ø´Ë´íÎó¡£Çë¼ì²éÁ¬½ÓÀàÐÍÃû³ÆµÄƴдÊÇ·ñÕýÈ·¡£
½â¾ö·½·¨£º
sqlserver2005-ÅäÖù¤¾ß-SqlServer configuration manager-SqlServer2005·þÎñ-sqlserver Integration Services£¬ÓÒ»÷-Ñ¡ÔñÊôÐÔ£¬È»ºó° ......

sql»Ö¸´xp_regread

sql»Ö¸´xp_regread
ɾ³ýµôxp_regreadºó£¬·¢ÏÖÒÔǰµÄ×÷Òµ²»Äܲ鿴£¬Ö»ÄÜÈ¥»Ö¸´ÁË¡£
exec sp_addextendedproc 'Xp_dirtree','xpstar.dll'    »Ö¸´ºó·¢ÏÖ²»ÄÜʹÓÃ
ÕÒµ½dbcc addextendedproc ("Xp_regread","xpstar.dll") »¹ÊDz»ÄÜʹÓÃ
ºóÀ´²Å·¢ÏÖ»Ö¸´µÄʱºòÒªÓÃСдdbcc addextended ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ