创建存储过程、视图、触发器、表、游标

• 1存储过程

create procedure dbo.Test
(
@BeginDate datetime,

)
as
begin tran 
select * 
from dbo.Table 
where ColumnDate=@BeginDate

end

• 2视图

create view V_Test
as
select 
convert(varchar(20),column1)
from 
dbo.Table

go

• 3触发器

create trigger Trg_UpdateTable_Update
on Table
after for Update/insert/delete
as
if Update(column1)
begin 

Update dbo.Table 
set column2=value 
from dbo.Table a,inserted b
where a.column3=b.column3

end

• 4表

create table dbo.Table
(
column varchar(32) Not null primary Key, --主键不为空
column1 varchar(50) null,
column2 varchar(50) null,
...
)

• 5游标

 http://www.cnblogs.com/yuan-jun/p/6505083.html

declare @column1 varchar(20),@column2 int

declare Table cursor 
for 
select Id,Name 
from dbo.Table1 

Open Table 
Fetch first from Table into @column1,@column2
while @@Fetch_Status=0

begin
Update Table set Name=@column2 where Id=@column1
Fetch next from Table into @column1,@column2
end

close Table
deallocate