SQL Question

Question 1:

create table trans

(

[TID] INT NOT NULL IDENTITY(1,1),

[NO] varchar(10),

[Time] DATETIME DEFAULT('1900/01/01'),

[TAmt] MONEY

)

 

INSERT INTO trans([TID],[NO],[Time],[TAmt]) VALUES('0124-98',DEFAULT,1000)

INSERT INTO trans([TID],[NO],[Time],[TAmt]) VALUES('0124-98',GETDATE(),1000)

INSERT INTO trans([TID],[NO],[Time],[TAmt]) VALUES(SCOPE_IDENTITY(),'0124-98',DEFAULT,1000)

INSERT INTO trans([TID],[NO],[Time],[TAmt]) VALUES(SCOPE_IDENTITY(),'0124-98',GETDATE(),1000)

 

Question 2:

select round(689.89,-1,1)

 

Question 3:

create function tomoro

returns datetime

as

begin

        declare @td datetime

        set @td = getdate()

        set @td = dateadd(DD, datediff(DD, 0, @td), 0)

        return dateadd(DD, 1, @td)

end

 

 

Question 4:

SET ARITHABORT OFF

SET ANSI_WARNINGS OFF

select 200/0

 

 

Question 5:

create table champs

(

[team] nvarchar(10),

[title] int

)

 

insert into champs values('a',27)

insert into champs values('b',7)

insert into champs values('c',10)

insert into champs values('aa',5)

insert into champs values('aa5',5)

insert into champs values('aa4',5)

insert into champs values('aa3',5)

insert into champs values('aa2',5)

insert into champs values('bb',3)

insert into champs values('bb4',4)

insert into champs values('cc',3)

 

select [team], [title], rank() over(order by [title] desc) from champs

select [team], [title], dense_rank() over(order by [title] desc) from champs

 

Question 6:

select round(123.89,0)

 

Question 7:

SELECT * FROM sys.dm_db_missing_index_details

select object_id, name, index_id, type_desc from sys.indexes where type_desc = 'SPATIAL'