which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 19 Yes | 0 No |
select * from urTable
Where urDateColumn
Between '2007-10-20 17:00:00 PM'
and '2007-10-21 09:00:00 AM'
Is This Answer Correct ? | 14 Yes | 17 No |
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
Is This Answer Correct ? | 2 Yes | 5 No |
select * from table where columndata not in(select
columndata from table where date between '' and '')
Is This Answer Correct ? | 0 Yes | 4 No |
What is a db view?
What does top operator do?
Is a primary key unique?
Why is normalisation important?
Why is replication required on the sql server?
What is ACID Property of Transaction?
What is bit data type? What's the information that can be stored inside a bit column?
What is 2nf in normalization?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
Mention the differences between sql server and mysql.
When do we use the UPDATE_STATISTICS command?
4 Answers Deutsche Telekom AG,