Answer Posted / monty

i have other idea if there is no duplicate record in the
table you can use this


select top 7 *from employee
except
select top 4 *from employee

How can a database be repaired?

1034

---

What to check if a User database is locked?

1117

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2416

---

Write a code to select distinct records without using the DISTINCT keyword.

1186

---

Can we take the full database backup in log shipping?

997

---

What is a transact-sql statement?

1131

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2168

---

what are the types of indexes? : Sql server database administration

1183

---

Find first and last day of current month in sql server

1082

---

what happens on checkpoint? : Sql server database administration

1158

---

What encryption security is available in sql azure?

101

---

How can you insert null values in a column while inserting the data?

1343

---

What are horizontal and vertical scaling?

172

---

What is the security principal at the database level that represents your session?

994

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

974

---