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 ÅжÏÊÇ·ñ´æÔÚ
Ïà¹ØÎĵµ£º
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
CHECK Ô¼Êø(CHECK Ô¼Êø:¶¨ÒåÁÐÖпɽÓÊܵÄÊý¾ÝÖµ¡£¿ÉÒÔ½« CHECK Ô¼ÊøÓ¦ÓÃÓÚ¶à¸öÁУ¬Ò²¿ÉÒÔ½«¶à¸ö CHECK Ô¼ÊøÓ¦ÓÃÓÚµ¥¸öÁС£µ±³ýȥij¸ö±íʱ£¬Ò²½«³ýÈ¥ CHECK Ô¼Êø¡£)Ö¸¶¨¿ÉÓɱíÖÐÒ»Áлò¶àÁнÓÊܵÄÊý¾ÝÖµ»ò¸ñʽ¡£ÀýÈ磬¿ÉÒÔÒªÇó authors ±íµÄ zip ÁÐÖ»ÔÊÐíÊäÈëÎåλÊýµÄÊý×ÖÏî¡£
¡¡¡¡
¡¡¡¡¿ÉÒÔΪһ¸ö±í¶¨ÒåÐí¶à CHECK Ô¼Êø¡£¿ ......
×ö¿ª·¢¹ý³ÌÖУ¬¾³£»áÓõ½½«ExcelÖÐÊý¾Ýµ¼³öµ½SQL ServerÖеÄÇé¿ö£¬Äã¿ÉÒÔÀûÓÃSQL SERVER ÖÐ×Ô´øµÄµ¼ÈëÊý¾ÝµÄ·½Ê½£¬µ«ÕâÖÖ·½Ê½£¬ÓÐʱ»á·¢ÏÖÊý¾Ýµ¼Èëºó£¬¿ÉÄÜΪ¿Õ£¬¿ÉÄÜ¿ªÍ·ÉÙ¸öÁ㣬´ËÖÖÇé¿ö¶à³öÏÖÓÚÊýÖµÐ͵ÄÁУ¬½ñÌìÔÚCSDNÉÏÏй䣬ż¶û·¢ÏÖÁËÒ»¸öÌû×Ó£¬½éÉܵÄÒÔÏÂÕâÖÖ·½·¨£¬±¾ÈËÇ¡ÆßÒò×î½ü¹«Ë¾×¼±¸ÉÏÊУ¬É󼯾ÖÔÚ×öÉ󼯣¬¼¼ ......
1. SELECT
ʵÀý105
SELECT ID "±àºÅ",Name ÐÕÃû,
Math_Score 'Êýѧ³É¼¨', //ÔõôÓеÄÓÐAS,ÓеÄûÓÐ
Music_Score AS ÒôÀֳɼ¨,
English_Score AS Ó¢Îijɼ¨
f ......
l ÔÚ³ÌÐòÖÐÆ´½ÓSQLÃüÁî
¿ÉÊÇÈçºÎÔÚC#³ÌÐòÖÐÔËÐÐÄØ£¿ÎÒÃǼǵÃÔÚÆÕͨµÄSQL²éѯÖУ¬Ò»°ãÐèÒª°Ñ²éѯÓï¾ä¸³Öµ¸øSalCommand.CommandTextÊôÐÔ£¬ÕâÀïÒ²¾ÍÏñÆÕͨµÄSQL²éѯÓï¾äÒ»Ñù£¬½«ÕâЩÓï¾ä¸³¸øSqlCommand.CommandTextÊôÐÔ¼´¿É¡£Òª×¢ÒâµÄÒ»µãÊÇ£¬ÆäÖеÄ"GO"Óï¾ä±êÖ¾×ÅSQLÅú´¦ÀíµÄ½áÊø£¬±àдSQL½Å±¾ÊÇÐèÒªµÄ£¬µ«ÊÇÔÚÕâÀïÊDz ......