Answer / bhaskar

Function can excute by the SELECT statement
ex SELECT Functionname(parameters), select *from
functionname

select s_func(Parameters)

We cant execute the trigger ,
When we perform a DML(DELETE,INSERT,UPDATE) operation
Trigger will fire automatically

Do you know what is a with(nolock)?

1 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

1 Answers  

---

What is the difference between varchar and nvarchar?

1 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

How would you add a section to a table?

1 Answers  

---

What is create command?

1 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

1 Answers  

---

How to download and install microsoft .net framework version 2.0?

1 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1 Answers  

---