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
- 11818 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 trigger in salesforce?
Why we use the openxml clause?
How to delete a login name in ms sql server?
Can we perform backup restore operation on tempdb?
Explain the different types of backups available in sql server? : sql server database administration
What happens if you add a new index to large table?
What is tabulation?
When to use null data driven subscription?
What is check constraint in sql server?
What are ddl (data definition language) statements for tables in ms sql server?
What is named query? : sql server analysis services, ssas
What is ms sql server triggers?
What is the difference between count () and rowcount ()?
How do you test your database? : sql server database administration
How to use union to merge outputs from two queries together in ms sql server?
