Answer / sarvesh

CREATE PROCEDURE usp_StartStop_services

AS
Begin
Declare @date as varchar(100)
SET @date = convert(varchar, getdate(), 114)
Print @date

if @date >= '19:00:00.000'
exec MASTER.DBO.xp_cmdshell 'NET Stop SQLSERVER'
Else if

@date >= '09:00:00.00' and @date < '19:00:00.000'

exec MASTER.DBO.xp_cmdshell 'NET START SQLSERVER'
END
GO

Answer / 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

Answer / muhammadrashidmughal

select * from urTable
Where urDateColumn
Between '2007-10-20 17:00:00 PM'
and '2007-10-21 09:00:00 AM'

Answer / 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

Answer / sandeep rana

select * from table where columndata not in(select
columndata from table where date between '' and '')

Explain Different types of Projects?

1 Answers  

syntax and example for bitmap index in sql???

1 Answers  

How to modify existing triggers using "alter trigger"?

0 Answers  

What is normalization?

9 Answers  

tell me the disaster recovery plan

0 Answers   Microsoft,

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

Why the trigger fires multiple times in single login?

0 Answers  

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

How do I completely remove sql server instance?

0 Answers