Explain full-text query in sql server?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What are different types of join?

0 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

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,

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

Mention the differences between sql server and mysql.

0 Answers  

---

How does index makes search faster?

0 Answers   QuestPond,

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

What is the difference between a function and a stored procedure?

0 Answers  

---