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

What are the key configuration files for sql server reporting services ?

171

---

What are the steps to insert a table?

991

---

How to use old values to define new values in update statements in ms sql server?

1330

---

Explain the use of containers in ssis and also their types?

1015

---

how can you check the level of fragmentation on a table? : Sql server administration

1036

---

Is BCNF better than 2NF & 3NF? Why?

1102

---

what protocol both networks use? : Sql server database administration

1016

---

Can I delete event logs?

977

---

What are the advantages of passing name-value pairs as parameters?

1215

---

Tell me extended events in sql server 2008?

1052

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1100

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1167

---

What is self join in sql server joins?

1115

---

How do I find the sql server database version?

1051

---

what are the core components of SSRS?

135

---