Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

What are trace flags?

0 Answers  

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

What do mean by xml datatype?

0 Answers  

---