SQL Server 2005 Êý¾Ý¿â´´½¨Î¬»¤¼Æ»®Ê§°Ü£¿£¿£¿£¿
ºÙ£¬Ðֵܰ¡£¬ÕâÊÇÔõô»ØÊ£¿£¿£¿£¿
ÄãµçÄÔ±¾µØµÄͼƬ¿´²»µ½
http://d:/ÎÒµÄÎĵµ/My%20Pictures/sql%20server%20²Ù×Ýʧ°Üͼ/Database%20weihu
ºìXX
ÔõôÔÚÕâÑùµÄÂÛ̳ÉÏ·¢·Å½ØÍ¼°¡£¬ÄǸö¡®²åÈëͼƬ¡¯µÄ¹¦ÄÜÒªÊäÈëͼƬµØÖ·¿ÉÊÇÊäÁË£¬Í¼Æ¬Ã»·¨ÏÔʾզ°ì°¡£¬¼±ËÀÁË.................
ÎÒ°ÑͼƬ·ÅÔÚÕâ¶ù£ºhttp://user.qzone.qq.com/975508300/infocenter?ptlang=2052
²»ÖªµÀÄܲ»Äܱ»¿´µ½ÁË
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......