sqlÓï¾ä»ù±¾²Ù×÷
1.½¨±íÓï¾ä£ºcreate table
Ó÷¨: create table ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£)
¾ÙÀý£ºÀýÈç´´½¨Ò»¸öѧÉú³É¼¨±í£¬°üº¬µÄ×Ö¶ÎÓУ¬Ñ§Éúid£¬ÐÕÃû£¬ÐԱ𣬰༶£¬³É¼¨create table score(
create table score(
sid nvarchar(10) primary key,
sname nvarchar(10) not null,
sex nvarchar(2),
sclass nvarchar(5),
score int,
check(sex in('ÄÐ','Å®'))
);
2.²åÈëÓï¾ä£ºinsert into
Ó÷¨:insert into ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£) values (Öµ1£¬Öµ2£¬¡£¡£¡£¡£)
Èç¹û×Ö¶ÎÊDZíÖÐËùÓÐ×Ö¶Î×Ö¶ÎÁбí¿Éʡȥ£¬Ö±½Óд±íÃû¾ÍÐÐÁË
¾ÙÀý:Íù±íscoreÖвåÈë7ÌõÊý¾Ý
insert into score values('95002','СÀî','ÄÐ','01',82)
insert into score values('95003','СÀö','Å®','01',83)
insert into score values('95004','СÕÔ','ÄÐ','01',67)
insert into score values('95005','СÃÀ','Å®','01',78)
insert into score values('95006','СÌï','ÄÐ','01',88)
insert into score values('95007','СÐì','Å®','01',85)
insert into score values('95008','СÍõ','ÄÐ','01',86)
3.²éѯÓï¾ä£ºselect
Ó÷¨£ºselect ×Ö¶Î from ±íÃû where Ìõ¼þ
×ֶμäÓÃ','·Ö¿ª£¬Í¬ÑùÈç¹ûÑ¡Ôñ±íµÄËùÓÐ×ֶΣ¬¿ÉÓÃͨÅä·û*
¾ÙÀý£ºÊä³öscore±íÖгɼ¨ÔÚ60µ½80µÄͬѧµÄËùÓÐÐÅÏ¢
select * from score where score>=60 and score<=80
Êä³öscore ±íÖгɼ¨Îª85»ò86»ò87µÄѧÉúÐÅÏ¢
select * from score where score=85 or score=86 or score=87
Êä³öscore ±íÖа༶Ϊ95001»òÕßÐÔ±ðΪŮÐÔµÄѧÉúµÄÃû×Ö
select sname from score where sclass='95001' or sec='Å®'
4.ɾ³ýÓï¾ä:delete
Ó÷¨£ºdelete from ±íµÄÃû×Ö where Ìõ¼þ
¾ÙÀý£ºÉ¾³ýscore±íÖзÖÊýµÍÓÚ70·ÖµÄ¼Ç¼
delete from score where score<70
Ïà¹ØÎĵµ£º
ÕªÒª£ºSQL Server 2008ÖÐÌṩÁË9ÖÖ³£ÓõÄÊý¾ÝÍÚ¾òËã·¨£¬ÕâЩËã·¨ÓÃÔÚ²»Í¬Êý¾ÝÍÚ¾òµÄÓ¦Óó¡¾°Ï£¬±¾Îľ͸÷¸öËã·¨Öð¸ö·ÖÎöÌÖÂÛ¡£
±êÇ©£ºÊý¾ÝÍÚ¾òËã·¨ SQL Server 2008
1.¾ö²ßÊ÷Ëã·¨
¾ö²ßÊ÷£¬ÓÖ³ÆÅж¨Ê÷£¬ÊÇÒ»ÖÖÀàËÆ¶þ²æÊ÷»ò¶à²æÊ÷µÄÊ÷½á¹¹¡£¾ö²ßÊ÷ÊÇÓÃÑù±¾µÄÊôÐÔ×÷Ϊ½áµã£¬ÓÃÊôÐÔµÄȡֵ×÷Ϊ·ÖÖ§£¬Ò²¾ÍÊÇÀàËÆÁ ......
CyberSavvy ¼áÐÅÈí¼þ×Ô¶¯»¯¿ÉÒÔÈÿͻ§ÇáËÉÏíÊÜÉú»î¡£DataPlace ÊǸù«Ë¾µÄÈí¼þ¼´·þÎñ½â¾ö·½°¸£¬Ò²¿É³ÆÖ®Îª“Êý¾Ý¿â¹¤³§”£¬ËüÄܹ»ÈÃÃæÏò¼¼ÊõÒÔ¼°ÃæÏòÉÌÎñµÄÓû§´´½¨²¢ÐÞ¸Ä×Ô¼ºµÄÊý¾Ý¿â£¬¶øCyberSavvy ¹«Ë¾½«Îª¸ÃÊý¾Ý¿âÌṩÍйܷþÎñ¡£Òò´ËCyberSavvy ¹«Ë¾ÐèÒªÅÍʯ°ã¼á¹ÌµÄÊý¾Ý¿â£¬²¢Í¨¹ýÍòÎÞһʧµÄÊý¾Ý´«Êä»úÖÆÀ´Ö ......
“¾¹ý²âÊÔÎÒÃÇ·¢ÏÖSQL Server 2008µ±Öеı¸·ÝѹËõ¹¦ÄÜ¿ÉÒÔ1-3±¶µÄѹËõ±È£¬´Ó¶ø¼«´óµÄ¼õÉÙ±¸·ÝËùÐèµÄ´ÅÅ̿ռ䡣”Alexey Yeltsov, ΢Èíϵͳ¹ÜÀíÔ±Ö÷¹Ü¡£
΢ÈíÔÚÈ«ÊÀ½ç¹²ÓÐ6Íò¶àÃûÔ±¹¤£¬ÔÚ2006ÄêµÄ²ÆÕþÊÕÈ볬¹ýÁË500ÒÚÃÀ½ð£¬Óë´ËͬʱҲ²úÉúÁË´óÁ¿ÄÚ²¿Êý¾Ý£¬¹«Ë¾Ï£Íû¶ÔÕâЩÊý¾Ý½øÐм¯ÖÐÒÔ±ãÌṩ¿Í»§µÄ¼¯³É»¯ÊÓͼ¡£ ......
-->Title:Generating test data
-->Author:wufeng4552
-->Date :2009-09-25 09:56:07
if object_id('tb')is not null drop table tb
go
create table tb(ID int,name text)
insert tb select 1,'test'
go
--·½·¨1
select sql_variant_property(ID,'BaseType') from tb
--·½·¨2
select object_name(ID)± ......
ÔõôÔö¼ÓSQL ServerÁ¬½ÓÊý
1. ¿´²Ù×÷ƽ̨µÄ連½Ó數ÊǶàÉÙ
¿ØÖÆÌ¨µÄÊÚ權¿´¿´
2. 進GENERAL¿´¿´SQL SERVER USERS CONNECTIONS
Ôö´ó¼´¿É
sp_configure 'number of connection'
go ......