sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ
sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®·Ö¸Ðл£¡£¡£¡
´íÎóÈçÏ£º
Unable to list the users.
[Microsoft][ODBC SQL Server Driver][SQL Server]δÄÜ×¼±¸Óï¾ä¡£
SQLSTATE=37000.
{{--
Ïà¹ØÎÊ´ð£º
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 ......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
´ò¿ªSQL SERVERµÄÊý¾Ý¿âºÍ´ò¿ªACCESSÓÐÊ²Ã´Çø±ð£¿
Äܲ»ÄܱȽÏϵͳµÄ˵Ï´ò¿ªSQL SERVERÊý¾Ý¿âµÄ¹ý³Ì£¡
ÀýÈ磺SQL·þÎñÆ÷ hls_1,Êý¾Ý¿âÃû zwda,±íÃû data
²ËÄñÎÊÌ⣬лл¸÷λ£¡
¶¼¿ÉÒÔÓÃADOµÈÀ´´ò¿ª ......