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

SQL server ¿ª·¢³öÀ´µÄ³ÌÐòÊÇÔõÃ´ÒÆÖ²µ½¿Í»§µÄ

ÒÔǰÓùývcд¹ý²Ù×÷SQLserver Êý¾Ý¿âµÄ³ÌÐò£¬Á¬½ÓÊý¾Ý¿âµÄʱºòÓõ½ÁËÓû§ÃûºÍÃÜÂë¡£
ÿ¸öserverµÄÓû§ÃûºÍÃÜÂëÓ¦¸ÃÊDz»Ò»ÑùµÄ£¬ÒÔǰÊǿγÌÉè¼ÆÑÝʾһϸøÀÏʦ¿´¾Í¿ÉÒÔÁË¡£
µ«ÄǸöʱºòÎÒÒ»Ö±ÓиöÎÊÌ⣬Èç¹ûÒªÊǰѳÌÐò¸ø±ðÈËÓã¬Êý¾Ý¿â»¹ÄÜÁ¬ÉÏÂ𣬶Է½ÏµÍ³ÉÏÒª×öÐ©Ê²Ã´ÄØ¡£
¶ÔÊý¾Ý¿â±È½Ï¸ÐÐËȤ£¬¿Éϧ±ÏÒµºóû´ÓÊÂÕâ·½ÃæµÄ£¬Ã»ÕÒµ½¸ü¶àµÄÐÅÏ¢¡£
½ñÌìͻȻÓÖÏëÆðÕâ¸öÒÉÎÊÁË£¬ÓÐË­ÄܸøÎÒ½â»óÂð¡£
дÅäÖÃÎļþ Ö±½Ó¸ÄÁ¬½Ó×Ö·û´® ÕâÑù¾Í¿ÉÒÔÒÆÖµÁË

дÅäÖÃÎļþ
»òÊÇÔڵǼ½çÃæÉÏÌí¼ÓÑ¡ÔñÊý¾Ý¿â·þÎñÆ÷¸úÊý¾Ý¿âÃû³Æ.
Ó¦¸Ã¾ÍÐÐÁ˰É

Èç¹û±¾µØ°æ±¾µÄ»°Ò»°ã¶¼ÊÇËùÓж«Î÷ÒѾ­·â×°ÆðÀ´µÄ£¬°²×°Ö®ºó»áÌáʾÊäÈësqlÓû§ÃûºÍÃÜÂëµÄ

¿´ÄãµÄ³ÌÐòÔõô´¦ÀíÊý¾Ý¿âÁ¬½ÓµÄÁË£¬¿ÉÒÔÓÃÅäÖÃÎļþÒ²¿ÉÒÔÓÃ×¢²á±í


Ïà¹ØÎÊ´ð£º

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ