sql×ܽá
1.´´½¨Êý¾Ý¿â
--exec xp_cmdshell 'mkdir d:\project'--µ÷ÓÃDOSÃüÁî´´½¨Îļþ¼Ð£¬Ê¹Óô˾äÐèÒªÆô¶¯SQLµÄÍâΧ¹¤¾ß
if exists(select * from sysdatabases where name='Êý¾Ý¿âÃû')
drop database Êý¾Ý¿âÃû
set nocount on --È¡ÏûÊÜÓ°ÏìÐÐÊý
create database Êý¾Ý¿âÃû
on
(
name='',
filename='',-- .mdf .ldf
size=10mb,
maxsize=
filename= --Êý¾Ý¿â´óСÔö³¤Á¿
)
log on
(
)
go
use Êý¾Ý¿âÃû
--´´½¨µÇ¼Óû§
exec sp_addlogin 'Óû§Ãû','ÃÜÂë'
--È¥µôÊÜÓ°ÏìÐÐÊý
set nocount on
exec sp_grantdbaccess 'adminMaster','adminMaster'
--ÉèÖÃÓû§¶Ô±íµÄȨÏÞ
grant select,delete,update on bbstopic to Óû§Ãû
2.´´½¨±í¼°Ìí¼ÓÔ¼Êø
create table ±í
(
)
alter table ±í add
constraint Ô¼ÊøÃû primary key(ÁÐÃû) --Ö÷¼üÔ¼Êø identity
constraint Ô¼ÊøÃû check(len(ÁÐÃû)) --checkÔ¼Êø
constraint Ô¼ÊøÃû unique(ÁÐÃû) --Î¨Ò»Ô¼Êø
constraint Ô¼ÊøÃû default(ĬÈÏÄÚÈÝ) for ÁÐÃû
constraint Ô¼ÊøÃû foreign key(Íâ¼üÃû)
references Ö÷¼üÊý¾Ý¿âÃû(Ö÷¼üÃû)
ck£ºcheckÔ¼Êø
fk£ºÍâ¼üÔ¼Êø
df£ºdefaultĬÈÏ
×¢£ºalter ¸Ä±ä, ¸ü¸Ä
add ¼ÓÈ룬 Ôö¼Ó, Ìí¼Ó
constraint Ç¿ÖÆ£¬ÏÞÖÆ, Ô¼Êø
foreign key Íâ¼ü
references ÒýÓÃ
3.sqlÖеĹؼü×Ö£º
sysdatabases ×Ü¿â
exists ÅжÏÊÇ·ñ´æÔÚ
Ïà¹ØÎĵµ£º
CHECK Ô¼Êø(CHECK Ô¼Êø:¶¨ÒåÁÐÖпɽÓÊܵÄÊý¾ÝÖµ¡£¿ÉÒÔ½« CHECK Ô¼ÊøÓ¦ÓÃÓÚ¶à¸öÁУ¬Ò²¿ÉÒÔ½«¶à¸ö CHECK Ô¼ÊøÓ¦ÓÃÓÚµ¥¸öÁС£µ±³ýȥij¸ö±íʱ£¬Ò²½«³ýÈ¥ CHECK Ô¼Êø¡£)Ö¸¶¨¿ÉÓɱíÖÐÒ»Áлò¶àÁнÓÊܵÄÊý¾ÝÖµ»ò¸ñʽ¡£ÀýÈ磬¿ÉÒÔÒªÇó authors ±íµÄ zip ÁÐÖ»ÔÊÐíÊäÈëÎåλÊýµÄÊý×ÖÏî¡£
¡¡¡¡
¡¡¡¡¿ÉÒÔΪһ¸ö±í¶¨ÒåÐí¶à CHECK Ô¼Êø¡£¿ ......
µÍЧ: (Ë÷ÒýʧЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE IS NOT NULL;
¸ßЧ: (Ë÷ÒýÓÐЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE >=0;
£¨27£©×ÜÊÇʹÓÃË÷ÒýµÄµÚÒ»¸öÁУº
Èç¹ûË÷ÒýÊǽ¨Á¢ÔÚ¶à ......
thunder:
1.MYSQLʵÏÖ
mysql> select * from user;
+----+----------+----------+-----------------+
| ID | username | password | email |
+----+----------+----------+-----------------+
| 1 | admin | admin &nb ......
l ÔÚ³ÌÐòÖÐÆ´½ÓSQLÃüÁî
¿ÉÊÇÈçºÎÔÚC#³ÌÐòÖÐÔËÐÐÄØ£¿ÎÒÃǼǵÃÔÚÆÕͨµÄSQL²éѯÖУ¬Ò»°ãÐèÒª°Ñ²éѯÓï¾ä¸³Öµ¸øSalCommand.CommandTextÊôÐÔ£¬ÕâÀïÒ²¾ÍÏñÆÕͨµÄSQL²éѯÓï¾äÒ»Ñù£¬½«ÕâЩÓï¾ä¸³¸øSqlCommand.CommandTextÊôÐÔ¼´¿É¡£Òª×¢ÒâµÄÒ»µãÊÇ£¬ÆäÖеÄ"GO"Óï¾ä±êÖ¾×ÅSQLÅú´¦ÀíµÄ½áÊø£¬±àдSQL½Å±¾ÊÇÐèÒªµÄ£¬µ«ÊÇÔÚÕâÀïÊDz ......