Search results for query: *

Hello, Lets say I have a table that looks like this: ID | DisplayOrder | UserName --------------------------- 1 | 3 | Bob 2 | 1 | Tom 3 | 6 | Claire 4 | 5 | Sally 5 | 2 | John 6 | 4 | Tim And I query the table and...

Hello, I want to be able to query a table so that the results MUST contain a phrase, for example "This is my house" but must also include one or more of the following: "this is my dog" or "this is my cat" or "this is my goat" So, MUST include "This is my house" and MUST include AT LEAST...

OK - Getting the ID of the record I just inserted is fine but I need to insert a user record where the username is made up of the record id: MyCompany012 Or something like that. I could insert the record, grab the ID and then update the username but then I have to figure out a unique username...

Hello, Here's a table (TableA): ------------ id | name | ------------ 1 | bob | 2 | john| 3 | tom | 4 | tim | and here's another table (TableB): --------------------- personId | language | --------------------- 1 | Eng | 2 | Eng | 3 | Eng | 4...

Hi - I need to delete a foreign key programatically but, obviously, only if it exists. I'm in MS SQL Server 2005. I need to delete a Foreign called fkUserRoleID on a table called tblUsers. Any ideas? Thanks.

Hi, Let's say my table looks like this id | groupName | pNumber ------------------------ 1 | 1 | 1 2 | 1 | 1 3 | 1 | 1 4 | 2 | 1 5 | 2 | 1 6 | 3 | 1 7 | 3 | 1 8 | 3 | 1 I want to update pNumber so...

Hi - lets say I have a table of people. Each person has a description. I have set up a full text index on the description column. Now - I want to search that column. How do I search using a phrase alowing for slight variations in what the user might enter? Bearing in mind that the results MUST...

Hi - I've got 2005 developer edition. I installed it a while ago but now want to intall full text indexing. How do I actually install that? I go through the set up and select to install it but it then goes on to say that I can't install it.. How do I install full text indexing as an aditional...

Yes - thanks for your help, I know it's not ideal but unfortunately it's the only data I have to play with.. You solutions worked... thanks..

Hello - I have 2 tables. table1 contains a list of people. Table2 contains a list of poeple made up of SOME of the people from table1.. (So table1 has more records than table2). I need to select all the people from table1 that ARE NOT in table2.. I will be selecting using FirstName and...

Hello, I've built a recruitment site, new jobs can be added by authorised users, job seekers can search the database and submit there cv's etc. I need to create a system where any new jobs entered into the database are matched against cv's and details of the jobs (a link to the job detail page)...

Hello, I'm trying to create a connection to a database on a remote server. The hosting company has created the dsn on their server but when I try to create a connection in ultradev I get the following message: Unable to create remote folder_mmDB Scripts. 550 Access denied. The connection works...