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


Ïà¹ØÎÊ´ð£º

phpÁ¬½ÓSqlServer´íÎó

´ó¼ÒºÃ£¬ÎÒÔÚ²¿ÊðÓʼþweb¶ËµÄʱºò£¬ÓÃroundcubeÁ¬½ÓsqlserverÊý¾Ý¿â³öÏÖÏÂÃæµÄ´íÎó¡£
21-Sep-2009 12:00:49] MDB2 Error: not found (-4): [Error message: extension mssql is not compiled into PHP]
ºÃÏñÊÇ ......

Access Êý¾ÝÉýǨµ½ SQLServer2005

ÎÒÔ­±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£
ÏÖÓÐÎÊÌâÈçÏ£º

1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô­±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......

Ôõô½«´øÌØÊâ×Ö·ûµÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿

Java code:

Ôõô½«ÏñÏÂÃæµÄ´øÌØÊâ×Ö·û(µ¥ÒýºÅ¡¢°Ù·ÖºÅ£¬Ë«ÒýºÅ£¬#ºÅ£¬ÃÀÔª·ûºÅ......)µÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿
String mystring="
insert into T_PUB_RZGL(N_RZID,N_RZLX,N_BMDM,N_YGGH,C_RZNR ......

sqlserver°²×°²»ÉÏ

ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿

ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿

ÄѵÀ¾µÏ ......

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ