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

sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ

    sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾­´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®·Ö¸Ðл£¡£¡£¡
´íÎóÈçÏ£º
Unable to list the users.
[Microsoft][ODBC SQL Server Driver][SQL Server]δÄÜ×¼±¸Óï¾ä¡£
SQLSTATE=37000.


{{--


Ïà¹ØÎÊ´ð£º

Çósqlserver 2005 Êý¾Ý¿âÁ¬½Ó½â¾öÎÊÌâ¡£

ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......

PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)

PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......

Ô¶³ÌÊý¾Ý¿âÎÊÌ⣨sqlserver 2005£©

àÅ ¡£ÓÖ·¢ÌùÁË

ÈçÌ⣬ÎÒ¸Õ×öÍêÒ»¸öÏîÄ¿·Åµ½ÓòÃû¿Õ¼äÉÏ£¬È»ºóÊý¾Ý¿âÒ²ÔÚ¿Õ¼äÀïÃæÅªºÃÁË£¬ÏÖÔÚÎÒͨ¹ýSqlserver 2005Á¬½Óµ½Ô¶³ÌÊý¾Ý¿â£»
ÏÖÔÚÖ÷ÒªµÄÎÊÌâÊÇ£ºÎÒÈçºÎ°Ñ±¸·ÝµÄÊý¾Ý¿âµ¼ÈëÔ¶³ÌÊý¾Ý¿â¡£

²¹³ ......

¹ØÓÚÔÚSqlServerÖÐʹÓÃcurrent_dateµÄÎÊÌ⣡

SQL code:
select * from hr_emp_event_def as req
where req.eed_status='NEW' and
req.eed_alert_flag='Y' and
datediff(day,req.eed_estimate_start_date,current_date())*24=re ......

sqlserverÁÙʱ±í

exec('select * into #aaa from Base_Email' )

select * from #aaa

drop table #aaa


(48 ÐÐÊÜÓ°Ïì)
ÏûÏ¢ 208£¬¼¶±ð 16£¬×´Ì¬ 0£¬µÚ 4 ÐÐ
¶ÔÏóÃû '#aaa' ÎÞЧ¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ