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

mssqlÈ¥³ýÖØ¸´²¢ÅÅÐòµÄÎÊÌâ

SQL code:
/*
create database temp
use temp

create table employees
(
eID int identity primary key,
eName nvarchar(50) not null,
eSex smallint not null default(1),
eSort smallint default(0)
)

insert into employees values('a1',1,1);
insert into employees values('b5',0,5);
insert into employees values('a6',0,6);
insert into employees values('b3',1,3);

insert into employees values('a1',1,7);
insert into employees values('b5',0,9);
insert into employees values('a6',0,10);
insert into employees values('b3',1,20);
*/


ÏëµÃµ½ÕâôÑùµÄÒ»¸ö½á¹û£º£¨È¥³ýÖØ¸´µÄeName£¬²éѯ³öesort×î´óµÄ¼Ç¼¼¯£©
5 a1 1 7
6 b5 0 9
7 a6 0 10
8 b3 1 20

{{


Ïà¹ØÎÊ´ð£º

×ÜÕ¾·ÖÕ¾MSSQL¿â½á¹¹

Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......

MSSqlÊý¾Ý¿â±»¹ÒÂí

ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......

150·ÖÇóvbscriptÖÐÅжÏmssqlÓï·¨´íÎó

ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?


»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if 
else


²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸

ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......

mssql£¬mysqlÓëmstlq

·´ÕýÎÒÊǾ­³£·Ö²»Çå¡­¡­
¼ÌÐøÉ¢·Ö
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡­¡­

LZÄ㻹ÓпÉÓ÷Öô£¿

ÒýÓÃ
LZÄ㻹ÓпÉÓ÷Öô£¿
5·Ö

ÒýÓÃ
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡­¡­

ÓÐÒâ˼¡£¿´±êÌ ......

MSSQL´æ´¢Êý¾ÝÎÊÌâ

ÎÒÓõÄÊÇrealÊý¾ÝÀàÐÍ£¬µ«ÊǴ洢СÓÚ1µÄÊýÊ±Ç°ÃæµÄ0ûÓÐÁË£¬¸ÃÔõô½â¾ö£¬±ÈÈ磺ÎÒÏë´æ´¢0.1£¬ÔÚÊý¾Ý¿âÀïÖ»ÓС°.1¡±,0ûÓÐÁË£¬ÒªÔõôÉèÖ㬻òÕßÊý¾ÝÀàÐÍÊDz»ÊÇÒª»»Ò»ÖÖ ??
decimal(9,1)

Õâ¸öÃ²ËÆÓëÀàÐÍÎÞ¹Ø
Óë²Ù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ