SQL Server³£ÓÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®
Ò»¡¢Ê¹ÓÃSqlConnection¶ÔÏóÁ¬½ÓSQL ServerÊý¾Ý¿â
1¡¢µÇ¼Êý¾Ý¿âµÄ·½Ê½ÎªSQL ServerÑé֤ģʽ
server=·þÎñÆ÷Ãû;database=Êý¾Ý¿âÃû³Æ;uid=Óû§;pwd=ÃÜÂë
2¡¢µÇ¼Êý¾Ý¿âµÄ·½Ê½ÎªWindowsÑé֤ģʽ
server=·þÎñÆ÷Ãû;database=Êý¾Ý¿âÃû³Æ;Integrated Security=SSPI
ÆäÖУ¬Integrated Security¼´Trusted_Connection,È¡ÖµÓÐfalse(¼´no)¡¢true(¼´yes»òSSPI)
ÆäËû˵Ã÷£ºÔÚÁ¬½Ó±¾»úʱ£¬·þÎñÆ÷Ãû¿ÉÒÔÊÇlocalhost»òÕß(local)»òÕß.
×¢Ò⣬Èç¹ûʹÓõÄSQL ServerÊÇEXPRESS£¨¼òÒ×°æ/ѧϰ°æ£©£¬Ôò±ØÐëÔÚ·þÎñÆ÷Ãûºó¼Ó\SQLEXPRESS
¶þ¡¢Ê¹ÓÃOleDbConnection¶ÔÏóÁ¬½ÓOLE DBÊý¾ÝÔ´
1¡¢Á¬½ÓACCESSÊý¾Ý¿â
provider=Microsoft.Jet.OLEDB.4.0;Data Source=AccessÎļþ·¾¶
2¡¢Á¬½ÓSQL ServerÊý¾Ý¿â
provider=SQLOLEDB;Data Source=·þÎñÆ÷Ãû;Initial Catalog=Êý¾Ý¿âÃû;uid=Óû§;pwd=ÃÜÂë
Èý¡¢Ê¹ÓÃOdbcConnection¶ÔÏóÁ¬½ÓODBCÊý¾ÝÔ´
Driver=Êý¾Ý¿âÌṩ³ÌÐòÃû;Server=·þÎñÆ÷Ãû;Trusted_Connection=yes;Database=Êý¾Ý¿âÃû
ËÄ¡¢Ê¹ÓÃOracleConnection¶ÔÏóÁ¬½ÓOracleÊý¾Ý¿â
Data Source=Oracle8i;Integrated Security=yes
Ïà¹ØÎĵµ£º
c06 --------------7545623Ìõ
c05---------------1032652Ìõ
vc01--------------427741Ìõ
SQL Statement from editor:
select c0602 "ÉÌÆ·±àÂë",c0625 "ÉÌÆ·ÌõÂë",
c0103 "ÉÌÆ·Ãû³Æ",c0104 "¹æ¸ñ",c060 ......
MySQL Date º¯Êý
ÏÂÃæµÄ±í¸ñÁгöÁË MySQL ÖÐ×îÖØÒªµÄÄÚ½¨ÈÕÆÚº¯Êý£º
º¯ÊýÃèÊö
NOW()
·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä
CURDATE()
·µ»Øµ±Ç°µÄÈÕÆÚ
CURTIME()
·µ»Øµ±Ç°µÄʱ¼ä
DATE()
ÌáÈ¡ÈÕÆÚ»òÈÕÆÚ/ʱ¼ä±í´ïʽµÄÈÕÆÚ²¿·Ö
EXTRACT()
·µ»ØÈÕÆÚ/ʱ¼ä°´µÄµ¥¶À²¿·Ö
DATE_ADD()
¸øÈÕÆÚÌí¼ÓÖ¸¶¨µÄʱ¼ä¼ä¸ô
DATE_SUB()
´ÓÈÕÆÚ ......
±¾ÎĵØÖ·£ºhttp://qzone.qq.com/blog/236000056-1217427602
ÎÞ·¨Á¬½Óµ½·þÎñÆ÷
·þÎñÆ÷£ºÏûÏ¢18452, ¼¶±ð16£¬×´Ì¬1
[Microsoft][ODBC SQLServer Driver][SQL Server]Óû§‘sa’µÇ½ʧ°Ü¡£ÔÒò£ºÎ´ÓëÐÅÈÎSQL ServerÁ¬½ÓÏà¹ØÁª
¸Ã´íÎó²úÉ ......
SQLÊý¾Ý¿âÖÐÓÃimageÀ´´æ´¢Îļþ,µ«SQLûÓÐÌṩֱ½ÓµÄ´æÈ¡ÎļþµÄÃüÁî.
/*--bcp ʵÏÖ¶þ½øÖÆÎļþµÄµ¼Èëµ¼³ö
Ö§³Öimage,text,ntext×ֶεĵ¼Èë/µ¼³ö
imageÊʺÏÓÚ¶þ½øÖÆÎļþ,°üÀ¨:WordÎĵµ,ExcelÎĵµ,ͼƬ,ÒôÀÖµÈ
text,ntextÊʺÏÓÚÎı¾Êý¾ÝÎļþ
×¢Òâ:µ¼Èëʱ,½«¸²¸ÇÂú×ãÌõ¼þµÄËùÓÐÐÐ
µ¼³öʱ,½ ......
±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_SQL_COMP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_SQL_COMP]
GO
/*--²âÊÔÁ½×éSQLµÄƽ¾ùʱ¼ä
ÀûÓÃosql.exeÀ´²âÊÔÁ½×é SQL Óï¾äµÄÖ´ÐÐʱ¼ä
²âÊԵĴ洢¹ý³ ......