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...
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)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.