Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

ado sqlserver ´æ´¢¹ý³Ì - MS-SQL Server / ÒÉÄÑÎÊÌâ

Õâ¸öÀý³ÌÊý¾Ý¿âpubs´æ´¢¹ý³Ìreptq1ÄÜÕýÈ·Ö´ÐУ¬
¸Ä³É×Ô¼ºµÄÊý¾Ý¿âºÍ´æ´¢¹ý³Ì¾Í±¨´í3704£¨Ó¦ÓóÌÐò¶¨Òå»ò¶ÔÏó¶¨Òå´íÎó£©
´æ´¢¹ý³ÌÔÚ²éѯ·ÖÎöÆ÷ÄÜÕýÈ·Ö´ÐУ¬¶øÇÒÒ»Ö±ÔÚÓõģ¬ÕæÊÇÔÎËÀ¡£
Private Sub CommandButton5 ......

sqlserverÈÕÆÚÎÊÌâ - .NET¼¼Êõ / ASP.NET

±íA
id name time
1 '¶¼ÊÇ' 2010-03-22 00:42:47.293
2 '¶¼ÊÇ' 2010-04-22 00:43:33.187
3 '¶¼ÊÇ' 2010-04-23 00:43:37.280
4 '¶¼ÊÇ' 2010-05-22 00:43:39.450
5 '¶¼ÊÇ' 2010-06-22 00:43:40.543
6 '¶¼ÊÇ' ......

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

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

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

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

¼±¾È£¡£¡£¡£¡sqlserver - .NET¼¼Êõ / C#

ÔÚÒ»¸ö±íͬʱ¸üжàÌõÊý¾Ý ²»ÒªËµÓÃin
¸÷λ´óϺ°ï°ïæ
ʲôÒâ˼?ÐèҪʲôÌõ¼þ?²»ÐèÒªÌõ¼þÄǾÍÖ±½Ó¸üÐÂßÂ
update xxx set yyy=zzz

Ò»´ÎUpdateÓï¾ä£¬Ö»ÄܸüÐÂÒ»¸ö£¬ÒªÃ´¶à´ÎUpdate,Ҫôдһ¸ö´æ´¢¹ý³Ì£¬´æ´¢¹ý³Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ