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

ʹÓÃSQLÓï¾äÆô¶¯SQL ServerÍâΧ×é¼þ·þÎñ

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'CLR', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO


Ïà¹ØÎĵµ£º

SQL ÖÐÈçºÎ·µ»Ø´æ´¢¹ý³ÌÖеĽá¹û¼¯

set @sql = 'select    *   from   OPENROWSET(''SQLOLEDB'',''SERVER='+@serverip+';uid=sa;pwd=sa;Database='+@databaseName+''',''SET   FMTONLY   OFF;set   nocount   on exec   procName '''''+@yqid+''''''' ) as   ......

SQL·þÎñÆ÷£ºCONVERTÓëCASTÇø±ðºÎÔÚ


Èç¹ûSQL Server³ÌÐòÔ±Ï뽫±í´ïʽ´ÓÒ»ÖÖ»»ÎªÁíÒ»ÖÖ£¬Ëû¿ÉÒÔ´ÓSQL Server 7ºÍ2000ÖÐ×Ô´øµÄÁ½ÖÖ¹¦ÄÜÖÐ×ö³öÑ¡Ôñ¡£ÔÚ´æ´¢¹ý³Ì»òÆäËûÇé¿öÏ£¬ÎÒÃdz£³£ÐèÒª½«Êý¾Ý´ÓdatetimeÐÍת»¯³ÉvarcharÐÍ£»CONVERTºÍCAST¾Í¿ÉÒÔÓÃÓÚÕâÖÖÇé¿ö¡£
¡¡¡¡ÓÉÓÚSQL ServerÌṩÁ½ÖÖ¹¦ÄÜ£¬Òò´ËÓ¦¸ÃÑ¡ÔñÄÄÖÖ¹¦ÄÜ»òÓ¦¸ÃÔÚÄÄÖÖÇé¿öÏÂʹÓøù¦ÄܾͺÜÈÝÒ×Èà ......

MySQLÖÐÓÃsqlÓï¾ä²åÈëʱÆÚ

mysql> create table testdate(
         -> id int not null auto_increment primary key,
         -> time date);
Query OK, 0 rows affected (0.30 sec)
mysql> insert into testdate(time) values('2010-4-23');
Q ......

SQL Óï¾ä ¼ò½é

×î½üÁ½ÌìÒ»Ö±ÔÚÕÛÌÚSQLÓï¾ä£¬Ã»°ì·¨£¬Ð´Êý¾Ý¿âµÄÐֵܸøÁËÁ½¸öÀý×ӾͲ»ÔÙ¹ÜÁË£¬¶øÇÒ×î½üÇë¼ÙÁË¡£½ñÌì¼Ó°à»¹ÊÇÕÛÌÚÕâôһ¸öÓï¾ä£¬×ÜÊDz»¶Ô£¬ÇëÀÏ´ó¿´ÁË¿´»¹ÊÇû¿´³öÃŵÀÀ´£¬ ÔÚSQLite Expert Professional ÀïÃæдµÄÓï¾ä¶¼¿ÉÒÔÖ´Ðгɹ¦£¬µ«ÊÇÔÚAndroidµÄ¹¤³ÌÀïÃæÔõôÕÛÌھͲ»¶Ô¡£ ÓôÃÆ°¡£¬½ñÌì¼Ó°àËãÊÇ°×¼ÓÁË¡£
ΪÁ˲éÕÒºÍÑ§Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ