SQL server ¿ª·¢³öÀ´µÄ³ÌÐòÊÇÔõÃ´ÒÆÖ²µ½¿Í»§µÄ
ÒÔǰÓùývcд¹ý²Ù×÷SQLserver Êý¾Ý¿âµÄ³ÌÐò£¬Á¬½ÓÊý¾Ý¿âµÄʱºòÓõ½ÁËÓû§ÃûºÍÃÜÂë¡£
ÿ¸öserverµÄÓû§ÃûºÍÃÜÂëÓ¦¸ÃÊDz»Ò»ÑùµÄ£¬ÒÔǰÊǿγÌÉè¼ÆÑÝʾһϸøÀÏʦ¿´¾Í¿ÉÒÔÁË¡£
µ«ÄǸöʱºòÎÒÒ»Ö±ÓиöÎÊÌ⣬Èç¹ûÒªÊǰѳÌÐò¸ø±ðÈËÓã¬Êý¾Ý¿â»¹ÄÜÁ¬ÉÏÂ𣬶Է½ÏµÍ³ÉÏÒª×öÐ©Ê²Ã´ÄØ¡£
¶ÔÊý¾Ý¿â±È½Ï¸ÐÐËȤ£¬¿Éϧ±ÏÒµºóû´ÓÊÂÕâ·½ÃæµÄ£¬Ã»ÕÒµ½¸ü¶àµÄÐÅÏ¢¡£
½ñÌìͻȻÓÖÏëÆðÕâ¸öÒÉÎÊÁË£¬ÓÐËÄܸøÎÒ½â»óÂð¡£
дÅäÖÃÎļþ Ö±½Ó¸ÄÁ¬½Ó×Ö·û´® ÕâÑù¾Í¿ÉÒÔÒÆÖµÁË
дÅäÖÃÎļþ
»òÊÇÔڵǼ½çÃæÉÏÌí¼ÓÑ¡ÔñÊý¾Ý¿â·þÎñÆ÷¸úÊý¾Ý¿âÃû³Æ.
Ó¦¸Ã¾ÍÐÐÁ˰É
Èç¹û±¾µØ°æ±¾µÄ»°Ò»°ã¶¼ÊÇËùÓж«Î÷ÒѾ·â×°ÆðÀ´µÄ£¬°²×°Ö®ºó»áÌáʾÊäÈësqlÓû§ÃûºÍÃÜÂëµÄ
¿´ÄãµÄ³ÌÐòÔõô´¦ÀíÊý¾Ý¿âÁ¬½ÓµÄÁË£¬¿ÉÒÔÓÃÅäÖÃÎļþÒ²¿ÉÒÔÓÃ×¢²á±í
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
table1
Ãû³Æ Èë¿âÊý
CT»ú 3
CT»ú 5
X¹â»ú 4 ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......