Take a look at message 474053 which describes our method.

http://www.sqlservercentral.com/Forums/FindPost474053.aspx

I describe how we store each object as a separate file in the source code control system (currently Perforce, but Visual...

SA (4/14/2009)

---

You can delete the data from the table which has the foreign key or you can disable constraint checks and then delete.

So it really depends on your database...

A few things to solve your problem. All are in the BOL.

1. to search for plurals, word variants, etc. see FORMSOF and INFLECTION.

http://technet.microsoft.com/en-us/library/ms142566(SQL.90).aspx

Example:

WHERE CONTAINS(curriculum_vite, 'FORMSOF (INFLECTIONAL, skate)')This matches curriculum_vite...

In SQL Server 2005, "Noise Words", also known as "Stop Words", are global to each instance. So to have a different noise word list for a database, you'll have...

Best explanation yet for the correct, er, incorrect answer!:-D

Don't use OPENXML! Use XQuery.

See: http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

You can pass the data to the stored procedure as an XML document. You should use the XML data type for the parameter.

Then the stored procedure can perform a...

Related to "parameter sniffing", query optimization, OPTION (RECOMPILE) and this type of "catch-all" query parameterization, check out Erland Sommarskog's "connect" entry at: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=244298

Another good reason to upgrade to SQL Server...

Vijaya Kadiyala (4/1/2009)

---

My Asnwer is perfectly valid i.e will display 1..6.. if we execute this query in 2000.

We should have this question specific to the SQL Server version.

Thanks -- Vijaya...

Your example is exactly what the Thesaurus is for. There is no quick way to populate it. You'll have to add the terms to the Thesaurus as per...

While it is nice to post links it would be nice if you would:

1. Put the proper URL tags around your...

See related thread: http://www.sqlservercentral.com/Forums/Topic685529-145-1.aspx

kavi (3/29/2009)

---

The thesaurus files are in XML format with a global file (tsGLOBAL.xml) and then 18 language specific files. By default all of the files have sample XML that...

I don't think that you want every synonym for every word in every language to be added to the thesaurus file(s).

The thesaurus file is used for alternate names and/or spellings...

Sure, no problem. Glad that I could be of assistance.

Side bar (or why I had to...