SqlServerÖÐÐбäÁÐ
ÀýÈç´´½¨Ò»¸ö±í
create table stz
(
stuNO int primary key ,
subject nvarchar(20) not null,
score int not null
)
insert into stz values(1000 ,'Êýѧ',90)
insert into stz values(1001,'ÓïÎÄ',90)
insert into stz values(1002,'Ó¢Óï',90)
insert into stz values(1001 ,'Êýѧ',90)
insert into stz values(1002,'ÓïÎÄ',90)
insert into stz values(1000,'Ó¢Óï',90)
insert into stz values(1002 ,'Êýѧ',90)
insert into stz values(1000,'ÓïÎÄ',90)
insert into stz values(1001,'Ó¢Óï',90)
-- ÏÖÔÚµÄÇé¿öÊÇ
select * from stz;
&n
Ïà¹ØÎĵµ£º
sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST
Õë¶Ô»á»°·µ»Ø
S ......
-- ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
¼ÓÄê·Ý——print dateadd(year, 5, getdate()) ¼ÓÔ·ݗ—print dateadd(month, 5, getdate())
¼ÓÌìÊý——print dateadd(day, 5, getdate()) ¼ÓСʱ——print dat ......
ÒÔǰ¾³£Óöµ½Êý¾Ý¿âÈÕÖ¾ÎļþËð»µ,»òÕß¶ªÊ§µÄÇé¿ö,½ñÌ콫½â¾ö·½°¸Ð´ÏÂÀ´,ÒÔºó±ðÈËÔÙÎÊÆð¾Í¸øËû¸öÁ´½Ó,¶à·½±ã°¡.
ºÇºÇ:
1.н¨Ò»¸öͬÃûµÄÊý¾Ý¿â
2.ÔÙÍ£µôsql server(×¢Òâ²»Òª·ÖÀëÊý¾Ý¿â)
3.ÓÃÒª¸½¼ÓµÄÊý¾ÝÎļþ¸²¸ÇµôÕâ¸öн¨µÄÊý¾Ý¿â
4.ÔÙÖØÆôsql server
5.´Ëʱ´ò¿ªÆóÒµ¹ÜÀíÆ÷ʱ»á³öÏÖÖÃÒÉ£¬ÏȲ»¹Ü£¬Ö´ÐÐÏÂÃæµÄÓï¾ä£¨×¢ ......
mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......
»·¾³£ºvs2005+sqlserver2005+PowerDesigner 12
´ò¿ªPowerDesigner 12(ÒÔϼò³Æpd)£¬Ð½¨pdm¹¤³Ì£¬ÈçͼËùʾ£º
×¢£ºdbmsÑ¡ÔñÄúĿǰÐèҪת»»µÄÀà±ð£¬ÎÒÓõÄÊÇsqlserver2005¡£
È»ºóÑ¡Ôñ²Ëµ¥¡¶Êý¾Ý¿â¡·¡¶ÏµÍ³DSN¡·£¬Ñ¡Ôñ»òÕßÌí¼ÓÄúÐèÒªµÄÊý¾Ý¿â£¬ÎÒÕâÀïÑ¡ÔñµÄÊÇsql server¡£ÈçͼËùʾ£º
½¨ºÃ ......