SQL server×Ó²éѯ
exec xp_cmdshell 'md E:\project'
--ÏÈÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚÈç¹û´æÔÚ¾Íɾ³ý
if exists(select * from sysdatabases where name='bbsDB')
drop database bbsDB
--´´½¨Êý¾Ý¿âÎļþ
create database bbsDB
--Ö÷Êý¾Ý¿âÎļþ
on primary
(
name='bbsDB_data',--ΪÖ÷ÒªÊý¾Ý¿âÎļþÃüÃû
filename='E:\project\bbsDB_data.mdf',--Ö÷Êý¾Ý¿âÎļþµÄ·¾¶
size=10mb--³õʼ´óС
)
log on(
--ÈÕÖ¾Îļþ
name='bbsDB_log',
filename='E:\project\bbsDB_log.ldf',
size=3mb,
maxsize=20mb--×î´óÔö³¤Á¿Îª
)
go
use bbsDB
drop table BBSUsers
create table BBSUsers(
UID int identity(1,1) primary key not null,--±êʶÁÐ×ÔÔö³¤
UName varchar(15) not null,--Óû§Ãû£¬êdzÆ
UPassword varchar(16) not null,--ÃÜÂë²»ÄÜÉÙÓÚ6λÊýĬÈÏΪ£¨888888£©
USex bit not null,--ÐÔ±ð1´ú±íÄÐ
UEmail varchar(20) null, --µç×ÓÓʼþ±ØÐë°üº¬@ĬÈÏֵΪ£¨P@P.com£©
UClass int not null,--Óû§µÄµÈ¼¶(1)
UregDate datetime null,--×¢²áÈÕÆÚ£¨×¢²áʱϵͳʱ¼ä£©
Uremark varchar(255) null, --±¸×¢ÐÅÏ¢£¨±¸×¢£©
Upoint int not null,--Óû§µÄ»ý·Ö£¬µãÊý£¨20£©
UBirthday datetime null,--Óû§ÉúÈÕ
Ustate int null--״̬£¨0ĬÈÏΪÀëÏߣ©
)
go
select UPassword from BBSUsers
alter table BBSUsers-- ΪÃÜÂëÌí¼Ó¼ì²éÔ¼Êø³¤¶È´óÓÚ=6µÄ³¤¶È
add constraint CK_upassword check(len(UPassword)>=6)
alter table BBSUsers--ΪÃÜÂëÌí¼ÓĬÈÏÔ¼Êø(888888)
add constraint DE_upassword default ('888888') for UPassword
alter table BBSUsers--Email¼ì²éÔ¼Êø@
add constraint CK_uemail check (UEmail like '%@%')
alter table BBSUsers--ΪE-mailÌí¼ÓĬÈÏÔ¼ÊøP@P.com
add constraint DE_uemail default('P@P.co
Ïà¹ØÎĵµ£º
ʹÓÃ×Ô¶¨Òå±íÀàÐÍ£¨SQL Server 2008£©
http://tech.ddvip.com 2009Äê09ÔÂ19ÈÕ À´Ô´£º²©¿ÍÔ° ×÷Õߣº³ÂÏ£ÕÂ
¡¡¡¡ÔÚ SQL Server 2008 ÖУ¬Óû§¶¨Òå±íÀàÐÍÊÇÖ¸Óû§Ëù¶¨ÒåµÄ±íʾ±í½á¹¹¶¨ÒåµÄÀàÐÍ¡£Äú¿ÉÒÔʹÓÃÓû§¶¨Òå±íÀàÐÍΪ´æ´¢¹ý³Ì»òº¯ÊýÉùÃ÷±íÖµ²ÎÊý£¬»òÕßÉùÃ÷ÄúÒªÔÚ ......
¸ÅÊö
Microsoft SQL Server 2008 ÈÃÄúÄܹ»Í¨¹ýÖ±¹ÛµÄÊý¾ÝÍÚ¾òµÄÔ¤²âÐÔ·ÖÎöÀ´×ö³öÃ÷ÖǺÏÀíµÄ¾ö²ß£¬ÎÞ·ìµØÕûºÏ Microsoft ÉÌÒµÖÇÄÜÆ½Ì¨²¢¿ÉÀ©Õ¹ÖÁÉÌÒµÓ¦ÓóÌÐò¡£
ÖØ´óµÄй¦ÄÜ
ͬʱÀûÓôíÎóºÍ¾«È·¶ÈµÄͳ¼Æ·ÖÊýÀ´²âÊÔ¶à¸öÊý¾ÝÍÚ¾òÄ£ÐÍ£¬²¢ÀûÓý»²æÑéÖ¤À´È·ÈÏÆäÎȶ¨ÐÔ
ÔÚµ¥Ò»½á¹¹Öн¨Á¢¶à¸ö²»¼æÈݵÄÍÚ¾òÄ£ÐÍ¡¢ÔÚɸѡ¹ýµÄÊ ......
--------------------------------------------------------------------------
-- Author : ÔÖø£º²»Ïê ¸Ä±à£ºhtl258(Tony)
-- Subject: ÍêÉÆSQLÅ©Àúת»»º¯Êý£¨ÏÔʾÖÐÎĸñʽ£¬¼ÓÈëÈóÔµÄÏÔʾ£©
-------------------------------------------------------------------------- ......
Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±í
SELECT * from table WITH (HOLDLOCK)
×¢Òâ: Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±íµÄÇø±ð
SELECT * from table WITH (HOLDLOCK)
ÆäËûÊÂÎñ¿ÉÒÔ¶ÁÈ¡±í£¬µ«²»ÄܸüÐÂɾ³ý
SELECT * from table WITH (TABLOCKX)
ÆäËûÊÂÎñ²»ÄܶÁÈ¡±í,¸üкÍɾ³ý
SELECT Óï¾äÖГ¼ÓËøÑ¡ÏŦÄÜ˵Ã÷
SQL ServerÌṩÁËÇ¿´ó¶øÍ ......
дSQLµÄ±Èд.NET³ÌÐòµÄÌåÑéÉϲîÒ»µÈ£¬Ã»ÓÐÖÇÄÜÌáʾ£¬ÐèÒª¼Çס¹Ø¼ü×Ö£¬º¯Êý»òÕß²»¶ÏµØCopy±í×Ö¶ÎÃû£¬×Ô¶¨Ò庯Êý£¬´æ´¢¹ý³ÌÖ®ÀàµÄ¡£²»¹ýÔÚ
VS2010ÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃÖÇÄÜÌáʾÁË£¬ÈçÏÂÃæ¼¸·ùͼËùʾ£º
ÔÚ±à¼Æ÷ÖУ¬ ÊäÈë Shift + J
£¨Ìáʾ£º VS2010 ¿ª·¢¹¤¾ßÖбêµÄÊÇ Ctrl +J ÆäʵӦ¸ÃÊÇ Shift + J £©¾Í¿ÉÒÔ×Ô¶¯´ò¿ªÕâ¸öÖÇ ......