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

SQL Report Service 2008 ·ÃÎÊÌáʾÓû§ÃûºÍÃÜÂë

  ×î½üʹÓÃSQL Report Service 2008¿ª·¢±¨±í£¬ÔÚ¹«Ë¾Ã»ÎÊÌ⣬µ«»Ø¼Ò°²×°SqlServer2008 ºó£¬Ê¹Óñ¨±í£¬ÔÚ¿ª·¢µÄʱºòÔ¤ÀÀûÎÊÌ⣬µ«ÊDZ¨±í²¿Êðµ½·þÎñÆ÷ºó·ÃÎÊʱ¾ÍÌáʾÊäÈëÓû§ÃûºÍÃÜÂ룬µ«ÎÞÂÛÎÒÊäÈëʲô¶¼²»ÐУ¬ºÜÓôÃÆ¡£
  ×Ô¼ºµçÄÔXP ¹«Ë¾windows server 2008 
  iis Ò²²»ÊÇͬһ¸ö°æ±¾¡£
  ×î¸Õ½Ó´¥Õâ¸ö¶«¶«£¬ºÜ¶à²»¶®£¬ÕýÔÚѧϰÖУ¬Çë¸ßÊÖÖ¸½Ì¡£ÓÈÆäÊÇÏà¹ØÅäÖ÷½Ãæ¡£





лл¸÷λÁË£¬¸ÕÎÒÒ²¿´ÁËÏà¹ØÄÚÈÝ¡£ÆäÖÐÓеÄÌáµ½ÓòµÄÎÊÌ⣬¸ÕÍüÁË˵£¬×Ô¼ºµçÄÔûÓÐÁ´½Óµ½¹«Ë¾µÄÓò·þÎñÆ÷£¬ÊÇºÍÆäËûÈË×éµÄ¾ÖÓòÍø¡£ÕâЩ¶¼²»Ì«¶®¡£
 


Ïà¹ØÎÊ´ð£º

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ