which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
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 filestream?
What is schemabinding a view?
Explain “row_number()” in sql server with an example?
Explain the architecture of ms sql reporting service?
What is the primary use of the model database?
Where do you find the default Index fill factor and how to change it?
How to change the ownership of a schema in ms sql server?
How to select some specific columns from a table in a query in ms sql server?
Define msdb database?
What are the new data types are introduced in sql 2000?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What are logical/boolean operations in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
how you can configure a running aggregate in SSRS?
What are filegroups in sql server?