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
Ïà¹ØÎĵµ£º
create trigger updatemaster //´´½¨´¥·¢Æ÷Ãû×ÖÊÇ updatemaster
on votedetails &nb ......
Ò»¡¢Ñ»·
create table tb(
col1 varchar(1),
col2 varchar(2)
)
insert tb(col1,col2)values('0','0')
go 10000000
¶þ¡¢Êý¾ÝºÏ²¢
if object_id('[order]') is not null drop table [order]
go
create table [order]([orderid] int,[ordertype] varchar(1))
insert [ord ......
ÈçºÎʹÓà SSL À´È·±£Óë SQL Server 2000 °²È«Í¨ÐÅ
¸üÐÂÈÕÆÚ£º 2004Äê04ÔÂ20ÈÕ
±¾Ò³ÄÚÈÝ
Ä¿±ê
ÊÊÓ÷¶Î§
ÈçºÎʹÓñ¾ÕÂÄÚÈÝ
ÕªÒª
Äú±ØÐëÁ˽âµÄ±³¾°ÖªÊ¶
°²×°·þÎñÆ÷ÑéÖ¤Ö¤Êé
ÑéÖ¤Ö¤ÊéÊÇ·ñÒѰ²×°
ÔÚ¿Í»§¶Ë°²×° CA °ä·¢µÄÖ¤Êé
Ç¿ÖÆËùÓпͻ§¶ËʹÓà SSL
ÔÊÐí¿Í»§¶Ë¾ö¶¨ÊÇ·ñʹÓà SSL
Ñé֤ͨÐÅÊÇ·ñÒѼÓÃÜ
ÆäËû× ......
1¡¢ sql²éѯ×îºóÒ»ÌõÊý¾Ýselect * from table order by id DESC limit 1
2¡¢select top1 * from tablename where order by id desc
ͨ¹ýÔÚmysqlÖвâÊÔ£¬Ö»ÓеÚÒ»ÖÖ¿ÉÒÔʹÓ㬲»ÖªµÀÆäËûÊý¾Ý¿âÊÇ·ñÖ§³ÖµÚ¶þÖÖ·½·¨£¬ÍøÉϺܶàÈË˵ÓõڶþÖÖ·½·¨ ......
bit ÕûÐÍ bit Êý¾ÝÀàÐÍÊÇÕûÐÍ£¬ÆäÖµÖ»ÄÜÊÇ0¡¢1»ò¿ÕÖµ¡£ÕâÖÖÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢Ö»ÓÐÁ½ÖÖ¿ÉÄÜÖµµÄÊý¾Ý£¬ÈçYes »òNo¡¢True »òFa lse ¡¢On »òOff int ÕûÐÍ int Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 231(-2147483648)µ½231 (2147483 647)Ö®¼äµÄÕûÊý¡£´æ´¢µ½Êý¾Ý¿âµÄ¼¸ºõËùÓÐÊýÖµÐ͵ÄÊý¾Ý¶¼¿ÉÒÔÓÃÕâÖÖÊý¾ ......