SQL Report Service 2008 ·ÃÎÊÌáʾÓû§ÃûºÍÃÜÂë
×î½üʹÓÃSQL Report Service 2008¿ª·¢±¨±í£¬ÔÚ¹«Ë¾Ã»ÎÊÌ⣬µ«»Ø¼Ò°²×°SqlServer2008 ºó£¬Ê¹Óñ¨±í£¬ÔÚ¿ª·¢µÄʱºòÔ¤ÀÀûÎÊÌ⣬µ«ÊDZ¨±í²¿Êðµ½·þÎñÆ÷ºó·ÃÎÊʱ¾ÍÌáʾÊäÈëÓû§ÃûºÍÃÜÂ룬µ«ÎÞÂÛÎÒÊäÈëʲô¶¼²»ÐУ¬ºÜÓôÃÆ¡£
×Ô¼ºµçÄÔXP ¹«Ë¾windows server 2008
iis Ò²²»ÊÇͬһ¸ö°æ±¾¡£
×î¸Õ½Ó´¥Õâ¸ö¶«¶«£¬ºÜ¶à²»¶®£¬ÕýÔÚѧϰÖУ¬Çë¸ßÊÖÖ¸½Ì¡£ÓÈÆäÊÇÏà¹ØÅäÖ÷½Ãæ¡£
лл¸÷λÁË£¬¸ÕÎÒÒ²¿´ÁËÏà¹ØÄÚÈÝ¡£ÆäÖÐÓеÄÌáµ½ÓòµÄÎÊÌ⣬¸ÕÍüÁË˵£¬×Ô¼ºµçÄÔûÓÐÁ´½Óµ½¹«Ë¾µÄÓò·þÎñÆ÷£¬ÊÇºÍÆäËûÈË×éµÄ¾ÖÓòÍø¡£ÕâЩ¶¼²»Ì«¶®¡£
Ïà¹ØÎÊ´ð£º
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......