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 the sql equivaent of the dataset relation object ?

2039

---

How to create a dml trigger using create trigger statements?

1046

---

Explain following error properties?

1028

---

What is constraints and its types?

961

---

Please differentiate between a local and a global temporary table?

1017

---

How would you go about developing a ssrs report?

174

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1395

---

How to define output parameters in stored procedures?

1037

---

What is function of CUBE ?

1058

---

What are data resources?

929

---

How to return the date part only from a sql server datetime datatype?

1115

---

How to reaname table name without using sp_Rename in sql server..?

1006

---

How do you drop an index?

934

---

Can you pass expressions to stored procedure parameters?

1047

---

What is indexing in sql server with example?

1013

---