Answer Posted / karthick.r

the query to display a particular record for the emp'v4290'
is given below

select * from employee where empid="v4290";

in this eg employee is the table-name and v4290 is the value
for the attribute empid. where is the clause to fetch the
record from the backend database table

Can we write a distributed query and get some data which is located on other server and oracle database?

1175

---

What is resource governor?

926

---

Do you know the different ddl commands in sql?

994

---

How to disable a login name in ms sql server?

1060

---

Explain powershell included in sql server 2008?

998

---

How to get @@error and @@rowcount at the same time?

983

---

Can we call stored procedure in trigger?

906

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1146

---

Explain the steps to use transact-sql cursor?

957

---

Define tool Manage Statistics in SQL Server 2000 query ?

1022

---

What are statistics?

952

---

How do I edit a procedure in sql server?

897

---

What are the 2 types of classifications of constraints in the sql server?

1044

---

List some major differences between triggers and stored procedures?

854

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

947

---