MS SQL Reference

TABLE COMMANDS

create table <table-name>
(<column-name> <type>(length) Null|Not Null
<column...
)

Example
create table example
(column1 varchar(10) null
column2 text(15) not null
)

alter table <table-name> add <column-name> <type>(length) Null|Not Null
alter table <table-name> drop column <column-name>
alter table <table-name> alter column <fielname> <newdatatype(length)>

sp_help [<table name>]

INSERT, UPDATE AND DELETE

insert into <table name>
values('value1', 'value2', ....

insert into <tablename>(field1, field5, ...)
values('value1', 'value5',...

update <tablename>
set <fielname1>='value1', <fieldname2>='value2', etc
where <fieldname>=<Condition>

delete from <tablename>
where <fieldname>=<Condition>

PERMISSION COMMANDS

Access to SQL Server
Authentication Method	Add Login	Drop Login	View Login
Windows	SP_grantlogin	SP_revokelogin* SP_denylogin	SP_helplogin
SQL Server	SP_addlogin	SP_droplogin	SP_helplogin

* Revokes access when access is granted, unrevokes access when access is denied

SP_grantdbaccess 'domain\username'
SP_revokedbaccess 'domain\username'

DATABASE COMMANDS

use <databasename>

sp_databases

create database <database name>
on <filegroup>*
( NAME = <name>,
FILENAME = '<path to file>',
SIZE = <size>,
MAXSIZE = <maximum size>,
FILEGROWTH = <filegrowth in MB or %> )
LOG ON
( NAME = '<transaction log file name>',
FILENAME = '<path to transation log file>',
SIZE = <size>,
MAXSIZE = <Maximum size>,
FILEGROWTH = <filegrowth in MB or %> )

*The default is PRIMARY

SELECT COMMANDS

select <expression> from <tablename> where <fieldname>=<expresison> order by <fieldname>

Examples
select * from tablename
select * from tablename where testfield1='ok' order by testfield2