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

PowerShell±Ê¼Ç£¨Èý£©£ºµ÷ÓÃMS SQLÊý¾Ý¿â

ÊÔÁËÒ»°ÑPowerShell·ÃÎÊÊý¾Ý¿â£¬¸úÓÃC#д¼¸ºõûÈκÎÇø±ð~
ΪÁ˼òµ¥Æð¼û£¬´úÂëÓеã³ó£¬²»ÓÃÌ«É
$ConnString = "server=_SERVER_;database=_DATABASE_;user id=_UID_;password=_PWD_";
$db = New-Object System.Data.SqlClient.SqlConnection($ConnString);
$db.Open();
$Sql = "select top 10 * from sys.objects where type='U' order by [Name]";
$cmd = New-Object System.Data.SqlClient.SqlCommand($Sql,$db);
$r = $cmd.ExecuteReader();
$a = "","";
while ($r.Read())
{
 $a = $a + $r["Name"].ToString();
}
$r.Close();
$cmd.Dispose();
$db.Close();
$db.Dispose();
echo $a


Ïà¹ØÎĵµ£º

SQL Óαêѧϰ

    ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
      a_id                      a_name               ......

SQLÓï¾ä½Ì³Ì

ÔÚÕâÒ»Ò³ÖУ¬ÎÒÃÇÁгöËùÓÐÔÚÕâ¸öÍøÕ¾ÓÐÁгö SQL Ö¸ÁîµÄÓï·¨¡£ÈôÒª¸üÏ꾡µÄ˵Ã÷£¬ÇëµãѡָÁîÃû³Æ¡£
ÕâÒ»Ò³µÄÄ¿µÄÊÇÌṩһ¸ö¼ò½àµÄ SQL Óï·¨×öΪ¶ÁÕ߲ο¼Ö®Óá£ÎÒÃǽ¨ÒéÄúÏÖÔھͰ´ Control-D ½«±¾Ò³¼ÓÈëÄúµÄ¡ºÎÒµÄ×î°®¡»¡£
Select
SELECT "À¸Î»" from "±í¸ñÃû"
Distinct
SELECT DISTINCT "À¸Î»"
from "±í¸ñÃû"
Where
......

ʹÓÃSQLʱ±ØÐ뿼ÂǵÄÎå¸ö¹Ø¼üÒòËØ

 Ê¹ÓÃSQLʱ±ØÐ뿼ÂǵĹؼüÒòËØ
Ò»£¬»ñµÃ½á¹û¼¯ËùÐè·ÃÎʵÄÊý¾ÝÁ¿£¬ÔÚûÓÐÈ·¶¨Ä¿±êÈÝÁ¿Ö®Ç°£¬ºÜÄѶ϶¨²éѯִÐеÄЧÂÊ£»
¶þ£¬¶¨Òå½á¹û¼¯ËùÐèµÄ²éѯÌõ¼þ£¬Ò²¾ÍÊÇÈçºÎÏÞ¶¨½á¹û¼¯£¬ÈçºÎºÏÀíµÄʹÓÃsql×Ӿ䣻
Èý£¬½á¹û¼¯µÄ´óС£¬È¡¾öÓÚ±íµÄ´óСºÍ¹ýÂËÌõ¼þµÄϸ½Ú£¬µ«²»¶¼ÊÇÕâÑù£¬µäÐ͵ÄÇé¿öÊÇ£¬Èô¸É¸ö¶ÀÁ¢Ê¹ÓÃʱЧÂʲ»¸ßµÄÌõ ......

֪ʶС½á(PL/SQL)

1) ʱ¼äת»»º¯ÊýÖÐÈç¹ûÓÐʱ¼ä±äÁ¿yyyy-mm-ddÁ½±ßÐèÁ½''
to_date(''' || to_char(a_valid_date_end, 'yyyy-mm-dd') ||''', ''yyyy-mm-dd'')
2) select distinct(e.itemnum) bulk collect into v_itemnum
½«×Ö·û´®Êý×éÒÔ·Ö¸ô·û·Ö¸ôµÄ×Ö·û´®µ÷ÓÃ
pkg_maximo_common.get_string(v_itemnum, ',', '')
3) unionÖ»Êǽ«Á½¸ö½á¹ ......

·Àsql×¢ÈëÀà

 using System;
using System.Text.RegularExpressions;
using System.Web;
namespace FSqlKeyWord
{
/**//**//**//// <summary>
/// SqlKey µÄժҪ˵Ã÷¡£
/// </summary>
public class SqlKey
{
private HttpRequest request;
//private const string St ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ