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

sqlÓï¾ä¼¯½õ

Ò»¡¢Ö÷ÒªÊÇÐèÒª¸üÐÂmssqlServer µÄʱºòÐèÒª½øÐÐһЩÊÇ·ñ´æÔÚµÄÅжϣ¬ÔÚmssql2000 ºÍ 2005 ÉϲâÊÔûÓÐŶÎÊÌâ
--//ÅжÏÊDZíTable_UserInfoÀïÊÇ·ñÓÐ×Ö¶Î
if not exists(select * from syscolumns where id=object_id('Table_UserInfo') and name='Tel') begin
ALTER table Table_UserInfo add Tel varchar(200)--Ôö¼Ó×Ö¶Î
--ALTER TABLE Table_UserInfo DROP COLUMN Tel--ɾ³ý×Ö¶Î
--ALTER TABLE table_name ALTER COLUMN Tel varchar(200) --ÐÞ¸Ä×Ö¶ÎÀàÐÍ
end
--//ÅжÏÒªÌí¼ÓÁеıíTable_UserInfoÖÐÊÇ·ñÓÐÖ÷¼ü
if exists(select 1 from sysobjects where parent_obj=object_id('Table_UserInfo') and xtype='PK') begin
select top 1 * from Table_UserInfo
end
--//ÅжϱíTable_StatÊÇ·ñÓÐË÷ÒýIndex_Other
IF EXISTS (SELECT * from dbo.sysindexes WHERE id = OBJECT_ID(N'[dbo].[Table_Stat]') AND name = N'Index_Other') begin
select top 1 * from Table_UserInfo
end
--// ÅжÏÊÇ·ñÓд洢¹ý³Ìpr_DoStatCount
IF EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[pr_DoStatCount]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) begin
DROP PROCEDURE [dbo].[pr_DoStatCount]
end
--ÅжÏÊÇ·ñÓд˱íTable_stat_Count
IF EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].Table_stat_Count') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin
DROP PROCEDURE [dbo].[Table_stat_Count]
end


Ïà¹ØÎĵµ£º

Shrink SQL Server 2008 Database + Log File Script

Use DatabaseName
--DB shrink
--»ñÈ¡database ¿ÕÓà¿Õ¼ä£¬¡¡¾ö¶¨ÊÇ·ñ×÷shrinkDB
exec [DBNAME].dbo.sp_spaceused
DBCC ShrinkDB(DBNAME)
--Log file shrink
Use DatabaseName
GO
Alter Database DatabaseName Set Recovery Simple
GO
Alter Database DatabaseName Set Recovery Full
GO
DBCC SHRINKFILE ('Log ......

sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«



sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ­´æÔÚÁË¡£

½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ

sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......

Éî¶È¶Ô±ÈOracleÓëSQL Server – µÚÒ»²¿·Ö


²Ù
×÷ϵͳµÄÖ§³Ö
°æ
±¾ºÍ·¢Ðаæ
ʵ
Àý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä
ʵ
ÀýÃûºÍSID
ϵ
ͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
 
±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊð
Ãû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé
·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºS ......

DelphiʹÓÃiniÅäÖÃÎļþÁ¬½ÓMS SQLÊý¾Ý¿â

ºÜÔç×ö¹ýµÄÒ»¸ödelphiÏîÄ¿£¬°ÑÀïÃæÓõ½µÄ¼¼Êõ×ܽáһϣ¬Ö÷ÒªÊÇÕë¶ÔÏóÎÒÕâÑùµÄdelphiÐÂÊÖ£¬¼¼ÊõÉÏ×ö¸ö»ýÀÛ°É£¡
¼ÙÉèÎÒÃǵÄÊý¾Ý¿âÅäÖÃÎļþServerInfo.iniÄÚÈÝÈçÏ£º
[ServerInfo]  
ServerIP=192.168.1.5
SQLDBName=Data 
SQLUserID=sa  
SQLPwd=  
ÎÒÃǶ¨ÒåÒ»¸öÁ¬½ÓÊý¾Ý¿âµÄ¹ý ......

Sql Mobile Êý¾Ý¿â¿ªÊ¼Ö®Ç°µÄÒ»µãÎÊÌâ×ܽá

1¡¢°²×°Sql Server2005 Mobile Edition£»
2¡¢¾ßÌåÔÚ´´½¨Ò»¸ö¹¤³ÌÒÔºó£¬ÏëʹÓÃSqlServerCe±ØÐëÔÚ×Ô¼º¹¤³ÌµÄÒýÓÃÀïÃæÌí¼ÓÒ»¸ödll²ÅÐУ»
ÆäĿ¼ÔÚ£ºC:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\System.Data.SqlServerCe.dll
Ìí¼ÓÁËÒÔºó¾Í¿ÉÒÔʹÓÃMobileµÄһЩÊý¾Ý¿â²Ù×÷µÄÀà¿âÁË¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ