Interested to Buy Any Domain ? << Click Here >> for more details...
which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
- 5 Answers
- 11798 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 use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is difference between order by and group by?
Tell me what is sql profiler?
what are user defined datatypes? : Sql server database administration
What are the differences between lost updates and uncommitted dependencies?
What is the process of normalising?
What is database dimension? : sql server analysis services, ssas
What is 2nf example?
What are the default system databases in sql server 2000?
what is a join and explain different types of joins? : Sql server database administration
What is awe?
What is difference between standardization and normalization?
What is after dml trigger?
Explain various On-Delete options in a DB table. Which is the default option?
What types of Joins are possible with Sql Server?
