which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
- 5 Answers
- 10253 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vimala
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 ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the downside of using udf?
Describe the left outer join & right outer join. : sql server database administration
Why do we backup Active Directory ?
What is molap and its advantage? : sql server analysis services, ssas
How to update multiple rows with one update statement in ms sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is update locks?
Explain how you can deploy an SSRS report?
What is the process of normalization?
Explain different types of collation sensitivity?
How to search for a string in all stored procedure in sql server?
What is use of dbcc commands?
What is difference between view and materialized view?
What are some examples of schemas?
How except clause is differs from not in clause?
