SQL²éѯ - MS-SQL Server / »ù´¡Àà
½á¹¹
ÐÕÃû ѧºÅ ÐËȤ
ÕÅÈý 1 ×ãÇò
ÕÅÈý 1 ÀºÇò
ÕÅÈý 1 ÓÎÓ¾
ÀîËÄ 2 ÓðëÇò
Ï£ÍûµÃµ½½á¹ûÈçÏÂ
ÐÕÃû ѧºÅ ÐËȤһ ÐËȤ¶þ ÐËȤÈý £¨ÕâÀïµÄ¡°ÐËȤX¡±±íÍ·¸öÊý ÒÑÐËȤ×î¶àµÄÈËΪÖ÷ ÕÅÈýÓÐ3¸öÐËȤ£©
ÕÅÈý 1 ×ãÇò ÀºÇò ÓÎÓ¾
ÀîËÄ 2 ÓðëÇò
Õâ¸öSQLÔõôд¡«
»¹ÌùÂð£¿
Ìù...
תÖúóÔÙUNION°É
SQL code:
/*------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-14 16:15:04
-- Version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microso
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......