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

200·ÖÇó´´½¨ÁÙʱ±í£¨sqlserver£©

±ÈÈçsqlÓï¾äÊÇ£º
SQL code:

select top 300
CA01.A_id as '±ä¶¯´ÎÊý',
CA01.A0188 as 'ÈËÔ±id',
CA01.apname as 'ÉóÅúÕß',
CA01.CA0100 as 'È·ÈÏ״̬',
CA01.CA0101 as '±ä¶¯ÀàÐÍ',
CA01.CA0102 as 'ÉêÇë±ä¶¯ÈÕÆÚ' from CA01



ÓÐÁ½¸öÎÊÌ⣺

1£º Òª°Ñ²éѯ³öÀ´µÄÊý¾Ý·Åµ½Ò»¸öбíÖÐ

2£º ËäÈ»ÓÐas £¬µ«ÊÇбíÖеÄ×Ö¶ÎÃû³ÆÈÔÈ»ÊÇÔ­±íÖеÄ×Ö¶ÎÃû³Æ


²»Èüӷ֣¬Áí¿ªÐÂÌù¼Ó·Ö

select top 300
CA01.A_id,
CA01.A0188,
CA01.apname,
CA01.CA0100,
CA01.CA0101,
CA01.CA0102
into #tmp
from  CA01



ÏȰÑÊý¾Ý·Åµ½Ð±íÖУ¬È»ºóÔÚ½øÐÐͳ¼Æ

sqlÓï¾äÊDz»¹Ì¶¨µÄ

¾ÍÊÇ˵Ҫ²éѯµÄ×Ö¶ÎÊDz»¹Ì¶¨µÄ£¬µÃÏȰÑÊý¾Ý·Åµ½Ò»ÕÅбíÖУ¬È»ºóÔÙ¶ÔÊý¾Ý½øÐвéѯ£¬ÉÏÃæµÄsqlÓï¾äºÜ¼òµ¥£¬¿ÉÄÜ»áÓбȽϸ´ÔӵijöÏÖ£¬±ÈÈçÓï¾äÖдøÓÐ×Ó²éѯ

ÒýÓÃ
ÏȰÑÊý¾Ý·Åµ½Ð±íÖУ¬È»ºóÔÚ½øÐÐͳ¼Æ

ÒýÓÃ
sqlÓï¾äÊDz»¹Ì¶¨µÄ


°ÑÄãµÄ±í½á¹¹¡¢²âÊÔÊý¾ÝºÍÄãÒªµÄ½á¹ûÌù³öÀ´

1027480591 ¼ÓÎÒqq˵°É

Çé¿ö±È½Ï¸´ÔÓ£¬ºÇºÇ

SQL code:
select top 300
CA01.A_id,
CA01.A0188,
CA01.apname,
CA01.CA0100,
CA01.CA0101,
CA01.CA0102
into


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

sqlserver order byÅÅÐòÎÊÌâ - .NET¼¼Êõ / ASP.NET

Order by ʱ¼ä×Ö¶Î desc
 ÅŲ»ÁË˳ÐòÁË
ǰÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡
¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊ ......

sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼­ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£

Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£

ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......

sqlserver ת mysqlµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÎÒÃǵÄϵͳÊÇ asp.net + sqlserver2005 ¿ª·¢µÄ£¬
ÏÖÔÚÏë°ÑÊý¾Ý¿âÇ¨ÒÆµ½ mysql ÉÏÀ´¡£
ÎÒ¿´ÁËÒ»ÏÂÏà¹ØµÄÎÄÕ£¬·¢ÏÖ sqlserver ºÍmysqlÔÚÊý¾ÝÀàÐÍÉÏÓÐЩ²î±ð£¬
ÁíÍ⣬ÎÒÃǵÄϵͳÓÃÁËһЩ Óû§×Ô¶¨Ò庯Êý ºÍ´óÁ¿µÄ´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ