Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

pl/sql´Ê»ãµ¥Ôª

 
2±êʶ·û¹æÔò
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿ ³£Á¿Ê±£¬Ã¿ÐÐÖ»ÄܵÚÒ»Ò»¸ö±êʶ·û
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿£¬³£Á¿Ê±£¬±êʶ·ûÃû³Æ±ØÐëÒªÒÔ°¢À­²®×Ö·û£¨A~Z,a~z£©¿ªÊ¼£¬²¢ÇÒ×î´ó³¤¶ÈΪ30¸ö×Ö·û¡£Èç¹ûÒÔÆäËû×Ö·û¿ªÊ¼£¬ÄÇô±ØÐëҪʹÓÃË«ÒýºÅÒýס¡£
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿³£Á¿Ê±£¬±êʶ·ûÃû³ÆÖ»ÄÜʹÓ÷ûºÅA~Z,a~z£¬0~9£¬_,$ºÍ#¡£Èç¹ûÊ¹Ó ......

SQL server 2005°²×°ÎÊÌâ»ã×Ü

 SQL2005 ·ÖÎå¸ö°æ±¾£¬ÈçÏÂËùÁУ¬
¡¡¡¡1.Enterprise(ÆóÒµ°æ),
      2.Development(¿ª·¢°æ),
¡¡¡¡3.Workgroup,(¹¤×÷Ⱥ°æ)
¡¡¡¡4.Standard,(±ê×¼°æ)
¡¡¡¡5.Express.(àÅ£¬¹ÀÇҾͽÐËü¼òÒ×°æ°É)
¡¡¡¡Õ⼸¸ö°æ±¾£¬ÎÒÃǾ¿¾¹Ó¦¸ÃʹÓÃÄÄÒ»°æÄØ﹖
¡¡¡¡ÕâÊÇÐí¶à³õѧSQL2005µÄÈË×î³£ÎʵÄÎ ......

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

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

·À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ºÅ