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

¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì SQL Server


¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì
 ¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì ÀýÒ»
create proc pr_select_Natural
(
 @CDATE  datetime,
 @FAC_NAME varchar(50),
 @BATTERY_TYPE varchar(20),
 @MAKE_MODE varchar(20),
 @PRODUCE_MODE varchar(20),
 @YEAR  char(4),
 @MONTH  char(2),
 @TDATE  datetime,
 @PAGENUM varchar(12)
)
as
declare @strWhere varchar(500)
if ( @CDATE = null )
 set @strWhere = @strWhere+' and CDATE ='+ @CDATE
if ( @FAC_NAME = null )
 set @strWhere = @strWhere+' and FAC_NAME like ''%''+@FAC_NAME+''%'' '
if ( @BATTERY_TYPE = null )
 set @strWhere = @strWhere+' and BATTERY_TYPE like ''%''+@BATTERY_TYPE+''%'''
if ( @MAKE_MODE = null )
 set @strWhere = @strWhere+' and MAKE_MODE like ''%''+@MAKE_MODE+''%'''
if ( @PRODUCE_MODE = null )
 set @strWhere = @strWhere+' and PRODUCE_MODE like ''%''+@PRODUCE_MODE+''%'''
if ( @YEAR = null )
 set @strWhere =@strWhere+ ' and YEAR like ''%''+@YEAR+''%'''
if ( @MONTH = null )
 set @strWhere = @strWhere+' and MONTH like ''%''+@MONTH+''%'''
if ( @TDATE = null )
 set @strWhere = @strWhere+' and TDATE = @TDATE'
if ( @PAGENUM = null )
 set @strWhere = @strWhere+' and PAGENUM like ''%''+@PAGENUM+''%'''
 
set @strMAIN = 'select
  CDATE  as ³ö³§Ê±¼ä,
  FAC_NAME  as ·¢»õ³§¼Ò,
  BATTERY_TYPE as µç³ØÐͺÅ,
  SEND_TYPE as ·¢»õÀàÐÍ,
  SEND_NUM as ¼ì²âÊýÁ¿,
  MAKE_MODE as ÖÆ×÷·½Ê½,
  PRODUCE_MODE as Éú²ú·½Ê½,
  BATTERY_NUM as µç³Ø×éÊýÁ¿,
  [YEAR]  as Äê,
  [MONTH] as ÔÂ,
  TDATE  as ÈÕÆÚ,
  SEND_RULE as ·¢»õ¹æÔò,
  SEND_CODE as ·¢»õ×é±àºÅ,
  BATTERY_SORT as µç³ØÀà±ð,
  PAGENUM as ÌõÂëºÅ,
  FITTING_CODE as ×°ÅäºÅ,
  LINE_CODE as Éú²ú»úºÅ,
  FLAG  as ÊÇ·ñ·ÅÐÐ,
  REMARK  as ±¸×¢,
  OTHER  as ÆäËû,
  BLANK_COL as ¿Õ°×ÁÐ
    from T_INFOCODE_NATUR


Ïà¹ØÎĵµ£º

sqlÖеÄDBO

DBOÊÇÿ¸öÊý¾Ý¿âµÄĬÈÏÓû§£¬¾ßÓÐËùÓÐÕßȨÏÞ£¬¼´DbOwner
ͨ¹ýÓÃDBO×÷ΪËùÓÐÕßÀ´¶¨Òå¶ÔÏó£¬Äܹ»Ê¹Êý¾Ý¿âÖеÄÈκÎÓû§ÒýÓöø²»±ØÌṩËùÓÐÕßÃû³Æ¡£
±ÈÈ磺ÄãÒÔUser1µÇ¼½øÈ¥²¢½¨±íTable£¬¶øÎ´Ö¸¶¨DBO£¬
µ±Óû§User2µÇ½øÈ¥Ïë·ÃÎÊTableʱ¾ÍµÃÖªµÀÕâ¸öTableÊÇÄãUser1½¨Á¢µÄ£¬ÒªÐ´ÉÏUser1.Table£¬Èç¹ûËû²»ÖªµÀÊÇÄ㽨µÄ£¬Ôò·ÃÎÊ» ......

SQL Server:½«ÁиüдÓÒ»¸ö±í´«µÝµ½ÁíÒ»¸ö±í

ÎÊ£ºÔõÑùÔÚÒ»¸öUPDATEÓï¾äÖÐʹÓñíBµÄÈý¸öÁиüбíAÖеÄÈý¸öÁУ¿
¡¡¡¡´ð£º¶ÔÕâ¸öÎÊÌ⣬Äú¿ÉÒÔʹÓÃÇ¿´óµÄ¹ØÏµ´úÊý¡£±¾Ò³ÖеĴúÂë˵Ã÷ÁËÈçºÎ×éºÏʹÓÃfrom×Ó¾äºÍJOIN²Ù×÷£¬ÒÔ´ïµ½ÓÃÆäËû±íÖÐÊý¾Ý¸üÐÂÖ¸¶¨ÁеÄÄ¿µÄ¡£ÔÚÉè¼Æ¹ØÏµ±í´ïʽʱ£¬ÄúÐèÒª¾ö¶¨ÊÇ·ñÐèÒªµ¥Ò»ÐÐÆ¥Åä¶à¸öÐУ¨Ò»¶Ô¶à¹ØÏµ£©£¬»òÕßÐèÒª¶à¸öÐÐÆ¥Åä±»Áª½Ó±íÖеĵ¥Ò» ......

SQL Server ExpressµÄʹÓÃ

      ½ñÌìÖÕÓÚÖªµÀSQL 2005 ÔõôÓÃÁË£¬¸Ð¾õÒÔǰ̫ÀÁÁË£¬Ã÷Ã÷ÏëÖªµÀµÄ¶«Î÷¿ÉÊÇÒòΪÒѾ­ÓÐsql2000¾ÍÀÁµÃ²é¡£ÖªÊ¶Õâ¶«Î÷ÊÇÈÕ»ýÔÂÀ۵ģ¬ÕæÕýµ½ÓõÄʱºò²ÅÈ¥²¹¾ÍÒѾ­ÍíÁË¡£
      ÒÔǰ°²×°VS2005µÄʱºò¾Í¿´µ½°²×°ÍêÁËÒÔºó»áÓÐÒ»¸öSQL2005£¬¿ÉÊÇ×Ô¼º²»»áÓã¬ÄǸöʱºòÖ» ......

PHPµÄ±àдSQLÓï¾äʱ¶ÔÐèҪתÒå×Ö·ûµÄ´¦Àí

1. ¶ÔÓÚPHP magic_quotes_gpc=onµÄÇé¿ö£¬ ÎÒÃÇ¿ÉÒÔ²»¶ÔÊäÈëºÍÊä³öÊý¾Ý¿âµÄ×Ö·û´®Êý¾Ý×÷
addslashes()ºÍstripslashes()µÄ²Ù×÷,Êý¾ÝÒ²»áÕý³£ÏÔʾ¡£ Èç¹û´ËʱÄã¶ÔÊäÈëµÄÊý¾Ý×÷ÁËaddslashes()´¦Àí£¬
ÄÇôÔÚÊä³öµÄʱºò¾Í±ØÐëʹÓÃstripslashes()È¥µô¶àÓàµÄ·´Ð±¸Ü¡£ 2. ¶ÔÓÚPHP magic_quotes_gpc=off µÄÇé¿ö ±ØÐëÊ¹Ó ......

ͨ¹ýT SQLÓï¾äѹËõSQL ServerÊý¾Ý¿â

Çå¿ÕÈÕÖ¾£º
dump transaction ¿âÃû with no_log
½Ø¶ÏÈÕÖ¾£º
backup log ¿âÃû with no_log
ѹËõÊý¾Ý¿â£º
dbcc shrinkdatabase (¿âÃû, Ä¿±ê±ÈÂÊ)
ѹËõÊý¾Ý¿âÎļþ£º
dbcc shrinkfile (ÎļþÃû»òID, Ä¿±ê´óС)
ÎļþÃû»òID¿ÉÒÔͨ¹ýϵͳ±ísysfiles²éÕÒ£¬Èç¹û²»Ö¸¶¨Ä¿±ê´óСSQL Server½«×î´óÏ޶ȵÄѹËõÊý¾Ý¿âÎļþ¡£
²é¿´Ñ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ