Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_data',
filename='d:\sales_data.mdf',
size=10,
maxsize=50,
filegrowth=5
)
log on
(
name='sales_log',
filename='d:\sales_log.ldf',
size=10,
maxsize=50,
filegrowth=5
)
drop database sales --ɾ³ýËù´´½¨µÄÊý¾Ý¿â
sp_helpdb sales --²é¿´Êý¾Ý¿âµÄÏà¹ØÐÅÏ¢
sp_helpfile --²é¿´µ±Ç°Êý¾Ý¿âÊý¾ÝÎļþÓëÈÕÖ¾ÎļþµÄÏà¹ØÐÅÏ¢
sp_detach_db sales --×ªÒÆÊý¾Ý¿âʱ·ÖÀëÊý¾Ý¿â
sp_attach_db sales,@filename1='Êý¾ÝÎļþ·¾¶Ãû' --ÕûºÏ·ÖÀëµÄÊý¾Ý¿â
,@filename2='ÈÕÖ¾Îļþ·¾¶Ãû'
--(ÈçºÎ¼õСÊý¾Ý¿âÈÕÖ¾ÎļþµÄ´óС: a.·ÖÀëÊý¾Ý¿â b.×ªÒÆÈÕÖ¾Îļþ c .ÕûºÏÊý¾Ý¿âµ«²»Ö¸¶¨ÈÕÖ¾Îļþ)
--Êý¾Ý¿âµÄ±¸·Ý
sp_addumpdevice 'disk','mydisk','d:\sales.bak' --Ìí¼ÓÉ豸¡£disk±íʾĿ±êÉ豸ÀàÐÍ,mydisk±íʾĿ±êÉ豸Âß¼­Ãû³Æ,d:\sales.bak±íʾĿ±êÉ豸ÎïÀíÃû³Æ
backup database sales to mydisk --ÏòÉ豸дÈëÊý¾Ý.ÆäÖеÄsalesÖ¸Êý¾Ý¿âÃû,mydiskΪ×Ô¶¨µÄÉ豸±êʾ·û
restore database sales from mydisk --»Ö¸´Êý¾Ý¿â
sp_dropdevice mydisk --ɾ³ýÉ豸
EXEC sp_dboption 'sales','read only','true' --ÉèÊý¾Ý¿âΪֻ¶Á
EXEC sp_dboption 'sales',autoshrink,true --ÉèÊý¾Ý¿âΪ×Ô¶¯Ñ¹Ëõ
EXEC sp_dboption 'sales','single user' --ÉèÊý¾Ý¿âΪµ¥Óû§
--(ÒÔÉÏÃüÁîÖе¥ÒýºÅ¿É¼Ó¿É²»¼Ó,µ«Ãû×ÖÖгöÏÖ¿Õ¸ñµÄÒ»¶¨Òª¼Ó.´óСд²»·Ö)
DBCC shrinkdatabase (sales,10) --½«Êý¾Ý¿âÖеÄÎļþ¼õС,ʹÊý¾Ý¿âÖÐÓÐ10%µÄ¿ÉÓÿռä
---------------------------------------------------------------------------------------------------------------
create table goods --½¨±íµÄµÚÒ»ÖÖÔ¼ÊøÓï·¨
(
gid int primary key,
gname varch


Ïà¹ØÎĵµ£º

SQLServer»ñÈ¡ExcelÖÐËùÓÐSheet

EÅ̸ùĿ¼Ð½¨Ò»¸öExcelÎļþaa.xlsºó²âÊÔÈçÏ´úÂë
use tempdb
go
if (object_id ('udf_getExcelTableNames' ) is not null )
    drop function dbo .udf_getExcelTableNames
go
create function udf_getExcelTableNames (@filename varchar (1000 ))
returns @t table (id int , name varchar ( ......

×ܽáÒ»µãAccessÓëSqlserverµÄsqlµÄ²îÒì

×î½üÕûÀí³öÀ´µÄ.Èç¹û²»ÍêÈ«µÄ»°Ï£Íû´ó¼Ò²¹³ä.
ÔÚaccessÖУ¬×ª»»Îª´óдµÄsqlº¯ÊýÊÇucase£¬ÔÚsqlserverÖУ¬×ª»»Îª´óдµÄº¯ÊýÊÇupper£»ÔÚaccessÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlcase£¬ÔÚsqlserverÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlower£»ÔÚaccessÖУ¬È¡µ±Ç°Ê±¼äµÄº¯ÊýÊÇnow£¬ÁíÍ⻹ÓÐÒ»¸öÈ¡ÈÕÆÚº¯Êýdate£¬ÔÚsqlserverÖУ¬È¡µ±Ç°µÄº¯ÊýÊÇgetdate ......

Ëø³õ̽(sqlserver 2005)

HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡ÖÐ¼ä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
 PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......

18¾ä»°ÈëÃÅSQLServer XML

18¾ä»°ÈëÃÅSQLServer XML ÊÕ²Ø
/*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath: ......

¹ØÓÚSQLServer2005µÄѧϰ±Ê¼Ç——XMLµÄ´¦Àí

ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ