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 is filestream?

945

---

What is schemabinding a view?

865

---

Explain “row_number()” in sql server with an example?

950

---

Explain the architecture of ms sql reporting service?

873

---

What is the primary use of the model database?

1020

---

Where do you find the default Index fill factor and how to change it?

1016

---

How to change the ownership of a schema in ms sql server?

1094

---

How to select some specific columns from a table in a query in ms sql server?

946

---

Define msdb database?

974

---

What are the new data types are introduced in sql 2000?

862

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

980

---

What are logical/boolean operations in ms sql server?

982

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

950

---

how you can configure a running aggregate in SSRS?

184

---

What are filegroups in sql server?

1014

---