State the difference between local and global temporary tables?

0 Answers  

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

How to find table changes in sql server?

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

What is log shipping?

0 Answers  

---

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

What is 1nf 2nf and 3nf?

0 Answers  

---

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---