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

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

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


{{--


Ïà¹ØÎÊ´ð£º

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 2005 Êý¾Ý¿âÁ¬½Ó½â¾öÎÊÌâ¡£

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

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

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

³õѧÕß¡£Sqlserver nullµÄÎÊÌâ

´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......

´ò¿ª SQLServer VC

´ò¿ªSQL SERVERµÄÊý¾Ý¿âºÍ´ò¿ªACCESSÓÐÊ²Ã´Çø±ð£¿

Äܲ»ÄܱȽÏϵͳµÄ˵Ï´ò¿ªSQL SERVERÊý¾Ý¿âµÄ¹ý³Ì£¡
ÀýÈ磺SQL·þÎñÆ÷ hls_1,Êý¾Ý¿âÃû zwda,±íÃû data

²ËÄñÎÊÌ⣬лл¸÷λ£¡
¶¼¿ÉÒÔÓÃADOµÈÀ´´ò¿ª ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ