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

How to turn on the mssql api module in php?

1055

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

938

---

Explain having clause and where clause?

1038

---

What is co-related sub query?

1007

---

what stored procedure would you use to view lock information? : Sql server administration

954

---

Explain what is row_number function?

1004

---

Tell me can we use custom code in ssrs?

987

---

How to create function without parameter in sql server?

1040

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1892

---

Can you move the resources after pausing the node? : sql server database administration

1078

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1045

---

What is the fillfactor concept in indexes?

965

---

Is sql server free?

894

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

939

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

960

---