1 显示数据库所有信息

sp_helpdb;

2 在 school 数据库下查找姓名为“李军”的学生记录。

select * from student where sname='李军';

3 创建数据库（简单）

create database test;

4

CREATE DATABASE database_name     [ ON         [ PRIMARY ] [ 
    
      [ ,...n ]         [ , 
     
       [ ,...n ] ]     [ LOG ON { 
      
        [ ,...n ] } ]     ]     [ COLLATE collation_name ]    [ WITH 
       
         ]][;]To attach a databaseCREATE DATABASE database_name     ON 
        
          [ ,...n ]     FOR { ATTACH [ WITH 
         
           ] | ATTACH_REBUILD_LOG }[;]
          
            ::= {( NAME = logical_file_name , FILENAME = 'os_file_name' [ , SIZE = size [ KB | MB | GB | TB ] ] [ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ] [ , FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]) [ ,...n ]}
           
             ::= {FILEGROUP filegroup_name [ DEFAULT ] 
            
              [ ,...n ]}
             
               ::={ DB_CHAINING { ON | OFF } | TRUSTWORTHY { ON | OFF }}
              
                ::={ ENABLE_BROKER | NEW_BROKER | ERROR_BROKER_CONVERSATIONS}Create a database snapshotCREATE DATABASE database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' ) [ ,...n ] AS SNAPSHOT OF source_database_name[;]
              
             
            
           
          
         
        
       
      
     
    

待续ing。。。