Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

SQL Server CONVERT() º¯Êý

SQL Server CONVERT() º¯Êý
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊǰÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý¡£
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_converted º¬ÓÐÐèҪת»»µÄÖµ¡£style ¹æ¶¨ÈÕÆÚ/ʱ¼äµÄÊä³ö¸ñʽ¡£
¿ÉÒÔʹÓÃµÄ style Öµ£º
Style IDStyle ¸ñʽ
100 »òÕß 0
mon dd yyyy hh:miAM £¨»òÕß PM£©
101
mm/dd/yy
102
yy.mm.dd
103
dd/mm/yy
104
dd.mm.yy
105
dd-mm-yy
106
dd mon yy
107
Mon dd, yy
108
hh:mm:ss
109 »òÕß 9
mon dd yyyy hh:mi:ss:mmmAM£¨»òÕß PM£©
110
mm-dd-yy
111
yy/mm/dd
112
yymmdd
113 »òÕß 13
dd mon yyyy hh:mm:ss:mmm(24h)
114
hh:mi:ss:mmm(24h)
120 »òÕß 20
yyyy-mm-dd hh:mi:ss(24h)
121 »òÕß 21
yyyy-mm-dd hh:mi:ss.mmm(24h)
126
yyyy-mm-ddThh:mm:ss.mmm£¨Ã»Óпոñ£©
130
dd mon yyyy hh:mi:ss:mmmAM
131
dd/mm/yy hh:mi:ss:mmmAM
ʵÀý
ÏÂÃæµÄ½Å±¾Ê¹Óà CONVERT() º¯ÊýÀ´ÏÔʾ²»Í¬µÄ¸ñʽ¡£ÎÒÃǽ«Ê¹Óà GETDATE() º¯ÊýÀ´»ñµÃµ±Ç°µÄÈÕÆÚ/ʱ¼ä£º
CONVERT( ......

oracle sql µÄÓï¾ä

delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷
wait() µÈµ½Ðм¶Ëø±»ÊÍ·Å£¬²Å½øÐÐÊý¾Ý²Ù×÷
dropÒ»ÕűíʱҲ»á¶Ô±í¼ÓËø£¬DDLÅÅËüËø,ËùÒÔÔÚɾ³ýÒ»ÕűíʱÈç¹ûµ±Ç°»¹ÓÐÓû§²Ù×÷±íʱ²»ÄÜɾ³ý±í
alter table ÃüÁîÓÃÓÚÐ޸ıíµÄ½á¹¹(ÕâЩÃüÁî²»»á¾­³£ÓÃ)£º
Ôö¼ÓÔ¼Êø£º
alter table ±íÃû add constraint ¡¡Ô¼ÊøÃû primary key (×ֶΣ©;
½â³ýÔ¼Êø£º(ɾ³ýÔ¼Êø)
alter table ±íÃû drop primary key£¨¶ÔÓÚÖ÷¼üÔ¼Êø¿ÉÒÔÖ±½ÓÓô˷½·¨£¬ÒòΪһÕűíÖÐÖ»ÓÐÒ»¸öÖ÷¼üÔ¼ÊøÃû, ×¢ÒâÈç¹ûÖ÷¼ü´Ëʱ»¹ÓÐÆäËü±íÒýÓÃʱɾ³ýÖ÷¼üʱ»á³ö´í£©
alter tbale father drop primary key cascade ; (Èç¹ûÓÐ×Ó±íÒýÓÃÖ÷¼üʱ£¬ÒªÓôËÓï·¨À´É¾³ýÖ÷¼ü,Õâʱ×Ó±í»¹´æÔÚÖ»ÊÇ×Ó±íÖеÄÍâ¼üÔ¼Êø±»¼°ÁªÉ¾³ýÁË£©
alter table ±íÃû drop constraint Ô¼ÊøÃû;
(ÔõÑùȡһ¸öÔ¼ÊøÃû£º1¡¢ÈËΪµÄÎ¥·´Ô¼Êø¹æ¶¨¸ù¾Ý´íÎóÐÅÏ¢»ñÈ¡!
2¡¢²éѯʾͼ»ñÈ ......

oracle sql µÄÓï¾ä

delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷
wait() µÈµ½Ðм¶Ëø±»ÊÍ·Å£¬²Å½øÐÐÊý¾Ý²Ù×÷
dropÒ»ÕűíʱҲ»á¶Ô±í¼ÓËø£¬DDLÅÅËüËø,ËùÒÔÔÚɾ³ýÒ»ÕűíʱÈç¹ûµ±Ç°»¹ÓÐÓû§²Ù×÷±íʱ²»ÄÜɾ³ý±í
alter table ÃüÁîÓÃÓÚÐ޸ıíµÄ½á¹¹(ÕâЩÃüÁî²»»á¾­³£ÓÃ)£º
Ôö¼ÓÔ¼Êø£º
alter table ±íÃû add constraint ¡¡Ô¼ÊøÃû primary key (×ֶΣ©;
½â³ýÔ¼Êø£º(ɾ³ýÔ¼Êø)
alter table ±íÃû drop primary key£¨¶ÔÓÚÖ÷¼üÔ¼Êø¿ÉÒÔÖ±½ÓÓô˷½·¨£¬ÒòΪһÕűíÖÐÖ»ÓÐÒ»¸öÖ÷¼üÔ¼ÊøÃû, ×¢ÒâÈç¹ûÖ÷¼ü´Ëʱ»¹ÓÐÆäËü±íÒýÓÃʱɾ³ýÖ÷¼üʱ»á³ö´í£©
alter tbale father drop primary key cascade ; (Èç¹ûÓÐ×Ó±íÒýÓÃÖ÷¼üʱ£¬ÒªÓôËÓï·¨À´É¾³ýÖ÷¼ü,Õâʱ×Ó±í»¹´æÔÚÖ»ÊÇ×Ó±íÖеÄÍâ¼üÔ¼Êø±»¼°ÁªÉ¾³ýÁË£©
alter table ±íÃû drop constraint Ô¼ÊøÃû;
(ÔõÑùȡһ¸öÔ¼ÊøÃû£º1¡¢ÈËΪµÄÎ¥·´Ô¼Êø¹æ¶¨¸ù¾Ý´íÎóÐÅÏ¢»ñÈ¡!
2¡¢²éѯʾͼ»ñÈ ......

SQL±¸·ÝÓ뻹ԭ¾­µäÎĵµ

SQL±¸·ÝÓ뻹ԭ¾­µäÎĵµ
======================================================================
SQL±¸·Ý
======================================================================
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹Ô­Ê±Ê¹ÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÄÜ»¹Ô­È«²¿Êý¾Ý£¬²¢¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÖ¸¶¨µÄʱ¿Ì¡£
£¨4£©Îª±£Ö¤ÊµÏÖ¼´Ê±µã»Ö¸´£¬¶ÔÊý¾Ý¿âµÄËùÓÐ*×÷¶¼½«ÍêÕûµØ¼ÇÈëÈÕÖ¾£¬ÕâÑù£¬ÈÕÖ¾Õ¼Óÿռä½Ï´ó£¬¶ÔÐÔÄÜÒ²ÓÐËùÓ°Ïì¡£
------------------
£¨2£©´óÈÝÁ¿ÈÕÖ¾¼Ç¼»Ö¸´Ä£ÐÍ
------------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹Ô­Ê±Ê¹ÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÈÕÖ¾Öв»¼Ç¼*×÷ϸ½Ú£¨Èçselect into¡¢create indexµÈ£©£¬¶øÖ»¼Ç¼*×÷µÄ×îÖÕ½á¹û£¬Òò´ËÕ¼ÓÃÈÕÖ¾¿Õ¼äС¡£
£¨4£©Ö»Ö§³Ö½«Êý¾Ý¿â»¹Ô­µ½ÊÂÎñÈÕÖ¾±¸·ÝµÄʱ¿Ì£¬¶ø²»Ö ......

DataGridViewµÄÔö¼Ó,ÐÞ¸Ä,ɾ³ýÃüÁîÖ¸¶¨SQLÓï¾ä

 '±£´æÊý¾Ý
    Private Sub Save()
        Try
            If MsgBox("È·¶¨Òª±£´æËùÐ޸ĵÄÊý¾ÝÂð£¿", MsgBoxStyle.Question Or MsgBoxStyle.DefaultButton2 Or MsgBoxStyle.YesNo, "ϵͳÌáʾ") = MsgBoxResult.Yes Then
                GridView.Rows(0).Cells("spbm").Selected = True
                Dim gCummand As New SqlClient.SqlCommandBuilder(gDataAdapter)
                With gDataAdapter
                    Dim parameterU As SqlClient.SqlParameter
                    'ÖØÐ ......

SQL²Ù×÷È«¼¯

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢ËµÃ÷£º´´½¨Ð±í
create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
¸ù¾ÝÒÑÓÐµÄ±í´´½¨ÐÂ±í£º
A£ºcreate table tab_new like tab_old (ʹÓÃ¾É±í´´½¨Ð±í)
B£ºcreate table tab_new as select col1,col2… from tab_old definition only
5¡¢ËµÃ÷£ºÉ¾³ýбídrop table tabname
6¡¢ËµÃ÷£ºÔö¼ÓÒ»¸öÁÐ
Alter table tabname add column col type
×¢£ºÁÐÔö¼Óºó½«²»ÄÜɾ³ý¡£DB2ÖÐÁмÓÉϺóÊý¾ÝÀàÐÍÒ²²»Äܸı䣬ΨһÄܸıäµÄÊÇÔö¼Óv ......

sql server Á¬½Ó³Ø

SQL Server ¼ÓÔØÇý¶¯ºÍurlµÄÓï¾äÔòΪ
Çý¶¯°üΪcom.microsoft.sqlserver.jdbc.SQLServerDriver
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";
Çý¶¯°üΪcom.microsoft.jdbc.sqlserver.SQLServerDriverʱ
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sample"; ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2376] [2377] [2378] [2379] 2380 [2381] [2382] [2383] [2384] [2385]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ