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

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

How to enter comments in transact-sql statements?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

---

What is primary key index?

0 Answers  

---

System requirements for sql server 2005 express edition?

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---