Search results for query: *

You're the best, thanks.

There is a server that has a potentially bad (beta?) dll and I cannot run sql server management on it w/o a MSCORLIB error when remoting in. I installed SQL 2005 Express on a diff workstation and had it connect to the main one. Now the user wants to see "Server Agent" so they can schedule jobs...

Thanks again Mr. Borissov

Thank you sir, I found a typo in the delete from query where category was spelled cateogory, so the 2nd query worked! The first LEFT JOIN query however did not work. If you can see why, I'd love to know. Thanks!

hmm here is some more info for you: I ran your first query with the LEFT JOIN: DELETE FROM FavCategory FROM FavCategory LEFT JOIN MemberDetails ON FavCategory.MemberId = MemberDetails.MemberId WHERE MemberDetails.MemberId = NULL gets me "0 rows affected" DELETE FROM FavCategory WHERE...

Thanks a lot Borislav! That helped me understand how it works.

I have a "Favourite Category" Table w/ a MemberID (it had a foreign key relationship to the MemberDetails MemberId field but i deleted it a few mins ago) and a MemberDetails Table with a Memberid Primary Key. I updated the Favourite Category table with MemberIds that do not exist in the...

http://tinyurl.com/258cnx I created a test database with 3 tables which is viewable in the screenshot listed above: CUSTOMERS INVOICES EMPLOYEES Sure a Customers to Invoices primary to foreign key relationship is obvious that it's a 1 to many to us, but how did MS-SQL know to create it as a 1...

Hello everyone, first I'd like to thank everyone here since you guys have answered my questions to a high degree of technical knowledge w/o jargon. I was hoping some of you would know a very good SQL tutorial on running queries using the various commands. Here is the problem I am running...

Phew, thanks. I was getting pretty confused. ^.^

Using the CBT Nuggets SQL 2000 training video, we created a constraint to limit the "State" field in a "Orders" Database to be limited to only PA, NY, and NY. Looking at the constraint through Enterprise Manager, I see this listed: ([State] = 'PA' or ([State] = 'NJ' or [State] = 'NY')) Could...

Wow did I totally join the right forum or what (that was a rhetorical question)! Thanks for all the answers! Explanations, links, and friendly advice all rolled into one. Thanks again ~

I know you have to specify from so the server knows where you are trying to pull this information from, and it's the first thing the server looks at, but look at the following (or any join statement) example: http://www.tizag.com/sqlTutorial/sqljoin.php SELECT employees.Lastname...