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, 5982 }

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, 9786 }

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