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

sqlserverÑ­»·Éú³ÉÊý¾Ý - MS-SQL Server / »ù´¡Àà

ÏÖÔÚÓÐÒ»¸ö±ítable1£¬Ö»ÓÐÒ»¸ö×ֶΣ¬varchar£¨10£©
num
111
112
113
114
ÏÖÔÚÏëҪѭ»·table1ÖеÄËùÓÐÊý¾Ý£¬Ô­À´µÄ111Éú³É111001-111999²åÈëµ½table2ÖÐ
SQL code:
Select ltrim([num])+right(1000+number,3)col
from tb a,master..spt_values b
where type='P' and number between 1 and 999


sqlÖеÄÑ­»·ÒªÓÃÓα꣬ÏÈÕ¼¸ösf

SQL code:
if not object_id('tb') is null
drop table tb
Go
Create table tb([num] int)
Insert tb
select 111 union all
select 112 union all
select 113 union all
select 114
Go
Select ltrim([num])+right(1000+number,3)col
from tb a,master..spt_values b
where type='P' and number between 1 and 999
/*
col
------------------
111001
112001
113001
114001
111002
112002
113002
114002
111003
112003
113003
114003
111004
112004
113004
114004
111005
112005
113005
114005
111006
112006
113006
114006
111007
112007
113007
114007
111008
112008
113008
114008
111009
112009
113009
114009
111010
112010
113010
114010
111011
112011
113011
114011
111012
112012
113012
114012
111013
112013
113013
114013
111014
112014
113014
114014
111015
112015
113015
114015
111016
112016
113016
114016
111017
112017
113017
114017
111018
112018
113018
11


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔÏ°¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»ÁË°¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ