which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
- 5 Answers
- 9842 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 are click through reports?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Can sql server be linked with other servers like oracle?
Different types of keys in SQL?
Describe in brief system database.
What is plan freezing?
explain different types of cursors? : Sql server database administration
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What are the underflow and overflow behaviors on float literals?
How you provide security to cube? : sql server analysis services, ssas
What are scheduled tasks in sql server?
List types of tables in SQL Azure?
What is the new security features added in sql server 2016? : sql server security
What is query optimization process?
Explain primary key in sql server?
