which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
Answer Posted / sumesh
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 |
Post New Answer View All Answers
Explain about analysis services?
What is compression - row-level and page-level compression?
Explain index in sql server?
What is model database? : SQL Server Architecture
How do you troubleshoot errors in a SQL Server Agent Job?
What do you mean by an execution plan?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
In which tcp/ip port does sql server run? Can it be changed?
how to trace the traffic hitting a sql server? : Sql server database administration
What is difference between index seek vs. Index scan?
What is proper subset of candidate key?
what's sql server? : Sql server database administration
What is field in algebra?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Mention what are the core components of ssrs?