ÁøÓÀ·¨³£ÓÃSQLÓï¾ä±¸Íü

--------------------------Êý¾Ý¿â²Ù×÷--------------------------  
--½¨Êý¾Ý¿â  
create database yongfa365_com  
on 
( name = yongfa365_comt,  
  filename = 'd:\yongfa365_com.mdf',  
  size = 4,  
  maxsize = 10,  
  filegrowth = 1  
)  
 
 
--ɾÊý¾Ý¿â  
drop database yongfa365_com  
 
--±¸·ÝÊý¾Ý¿â  
backup database yongfa365_com to disk='d:\yongfa365_com.bak' 
 
--ÅúÁ¿ÊÕËõËùÓÐÊý¾Ý¿â  
declare cur cursor for select name from Master..SysDatabases where name not in ('master','model','msdb','Northwind','pubs')  
declare @tb sysname   
 
open cur   
fetch next from cur into @tb   
while @@fetch_status=0   
begin   
 exec ('dump transaction ['+@tb+'] with no_log')   
 exec ('backup log ['+@tb+'] with no_log')   
 exec ('dbcc shrinkdatabase(['+@tb+'])')   
 fetch next from cur into @tb   
end   
close cur   
deallocate cur  
--------------------------Êý¾Ý¿â²Ù×÷--------------------------  
 
 
----------------------------±í²Ù×÷----------------------------  
--ɾ³ý±í  
drop table movies  
 
--ͨÓý¨±í½á¹¹  
Create Table [dbo].[±íÃû] (  
  [Id] int primary key identity(1,1),--ID£¬Ö÷¼ü£¬×Ô¶¯ºÅ  
  [txtTitle] varchar(255),--±êÌâ  
  [txtContent] varchar(MAX),--ÄÚÈÝ  
  [AddTime] datetime Default (getdate()),--Ìύʱ¼ä  
  [ModiTime] datetime Default (getdate()),--ÐÞ¸Äʱ¼ä  
  [Hits] int Default (0),--µã»÷Êý  
  [Flags] int Default (0) ,