Interview Questions Answers in SQL Server

sumesh

{ City } thrissur
< Country > india
* Profession * developer
User No # 21722

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 16
Users Marked my Answers as Wrong # 3

Questions / { sumesh }

Questions Answers Category Views Company eMail

Answers / { sumesh }

Question { Microsoft, 7057 }

If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database.

Answer

SELECT syscomments.text AS text
FROM sysobjects INNER JOIN
syscomments ON sysobjects.id =
syscomments.id where sysobjects.name=(stored procedure name)

Is This Answer Correct ?

5 Yes

0 No

Question { Wipro, 11574 }

which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM

Answer

Declare @hour varchar(100)
set @time=convert(varchar,getdate(),114)
set @hour=SUBSTRING(@time,1,2)
if(convert(int,@hour)>8 and convert(int,@hour)<19)
begin
print @time
print @hour
end

Is This Answer Correct ?

11 Yes

3 No