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
- 11567 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is history table in sql server?
What is a partition key?
Explain primary key and foreign key constraints?
What is instead of trigger sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How retrieve field names from the table in SQL through JAVA code?
What are the different index configurations a table can have?
Define cross join in sql server joins?
What are the differences between user defined functions and stored procedures?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is query processing?
What is difference between equi join and inner join?
What is resultset concur_updatable?
Define Wed Edition in SQL Azure?
How do you delete a trigger?
