SQL SERVER 中 GO 的用法2

use db_CSharp

go

select*,

备注=case

whenGrade>=90then'成绩优秀'

whenGrade<90andGrade>=80then'成绩良好'

whenGrade<80andGrade>=70then'成绩及格'

else'不及格'

end

fromtb_Grade

select*fromsysobjectswhereid=a

selectgetdate()

select*fromsysobjectswhereid=a

go

selectgetdate()

go

use master

go

if exists (select*fromsysdatabaseswherename='kejianDB')

dropdatabasekejianDB

go

createdatabasekejianDB

go

use kejianDB

go

--(行业表)

createtableTrade

(

tra_Idintprimarykeyidentity(1,1)notnull,--行业ID (主键、自增长)

tra_Namevarchar(50)notnull--行业名称

)

go