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

How to create and drop temp table in sql server?

591

---

How is a full-text index updated?

544

---

Explain nested trigger in sql?

597

---

what is sql server? : Sql server database administration

542

---

What is faster join or union?

602

---

---

Explain magic tables in sql server?

555

---

What is a field in a table?

582

---

what purpose does the model database serve? : Sql server database administration

509

---

Difference between group by clause and having clause in SQL?

570

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5506

---

Which Model uses the SET concept

586

---

Tell me what is use of except clause? How it differs from not in clause?

518

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

613

---

What is data source object?

557

---

What is the difference RDBMS and Graph Database?

631

---