Search results for query: *

Excellent idea, thanks very much!

I have a web search facility that Brings back and displays records matching a keyword. Depending on the keyword entered This can bring back over a 1000 results. These are divided into pages of 50 with links to other pages - pretty much like these forums do or any search engine does. My...

I am currently working on a message board system. The messages are in a hierarchical arrangement so that each message can have 1 or no Parents and an unlimited number of Child Messages (replies). I tried using the following query to bring back the details of a particular message and it's...

Thanks very much for your explanation and advice.

I came across some pretty useful sample code to insert a new record and retrieve the identity but I am not sure how it works! Dim new_identity 'Doing an insert Query = "INSERT INTO ComDirMOTD " & _ "(title, sender_text, message_body, Hyperlink, body_backcol, " & _...

Well what is the link? (Or what syntax would you use if they were both in the same database?) If it is PartsID then you would use SELECT * FROM M2MData06.dbo.job, Engineering.dbo.Parts WHERE (M2MData06.dbo.job.PartsID = Engineering.dbo.Parts.PartsID) (assuming dbo owns both tables)

That's working great now, Thanks very much!

Does any one know how to do this? I am currently trying the following SELECT * FROM DB1.Table1, DB2.Table1 WHERE (DB1.Table1.NT_Login = DB2.Table1.NT_domain_login) And getting this error Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'DB1.Table1'. Server: Msg 208, Level 16...

OK I think I have figured out how to do it now, but any comments on efficiency/better ways would be appreciated! Create Trigger Update_Users For Insert as Declare @SKey int Declare @GKey int Declare @UKey int Select @UKey=UKey, @SKey=SKey, @GKey=GKey From Inserted If Exists(Select 1 From...

My SQL knowledge is currently pretty limited so I would really appreciate some help with the following: I have 2 tables (say table1 and table2) table1 is a list of users and contains the fields: UKey, SKey, and GKey (all int) table2 contains a running total of members with a particular...

I am currently writing an app which must have a free text search facility on a database field it also must allow wild card searches. But I am struggling on the most efficient way of doing this. So if someone searches a Title Field for "*elcom* *To* *Taf*" I am splitting this into...