Recent content by masterchicker

When I use EXISTS, it will execute: SELECT col1, col2, col3, col4 FROM Table_1 You are right, only one record from (SELECT col1 FROM Table2) will make it true. But only the records that are retrieved from (SELECT col1 FROM Table2) should be retrieved by (SELECT col1, col2, col3, col4 FROM...

Hmmm.... This is the original code: SELECT col1, col2, col3, col4 FROM Table_1 WHERE co1 IN ( SELECT col1 FROM Table2 ) -- Only col1 records that were returned from the query of Table2 will be returned. When I do this: SELECT col1, col2, col3, col4 FROM Table_1 WHERE EXISTS ( SELECT...

What is the difference between the IN and EXISTS keywords. What kind of situations should I use each keyword to attain optimal performance? thanks.

How do you configure Outlook 2003 to send and received msn hotmail email messages. thanks.

DECLARE Employee_Cursor CURSOR FOR SELECT LastName, FirstName FROM Northwind.dbo.Employees OPEN Employee_Cursor FETCH NEXT FROM Employee_Cursor WHILE @@FETCH_STATUS = 0 BEGIN FETCH NEXT FROM Employee_Cursor END CLOSE Employee_Cursor DEALLOCATE Employee_Cursor What does @@Fetch_Status do? In...

How do I prevent others from installing programs in Windows 98 SE?

check your cpu fan or any accessory fans for that matter if its working the way it should. System slow downs such as what is happening to your machine occurs because of overheating cpu. And in addition, overheating will destroy your computer.

I own a machine that has windows 98 se. Is there a way to create a guest user account for windows 98 se? I want to prevent that guest user account from installing programs and altering my settings. Any idea would be great. Thanks.

1. Create a Win98 boot disk. You can do this by going to Add/Remove Programs in the Control Panel. Look for the tab that creates a Win98 boot disk. 2. After creating the boot disk. Reboot your machine. As the machine reboots, make sure the Win98 boot disk is inserted in the floppy drive. 3. When...

I have 768mb sdram on my machine. I used to have a 5.5 gig partition for my Windows XP Pro. When I purchased a new hard drive, the new partition for my Windows XP Pro is now 15 gig. I noticed that my computer slowed down. It would take 30 secs for an application to be invoked. After doing all...

sound like you have a hard drive with bad sectors. I would suggest purchasing a new one now before it goes real bad that you may lost your data. Sometimes I run Norton Disk Doctor and set it to automatically fix problems. It fixes hard drive integrity problems.

How do you make two desktop computers share 1 dial up internet connection?

Delete the partition then re-create it. Remember to format after creating the partition.

I own a personal computer but there are other people in my house that use the PC. The problem is that they install programs that are downloaded from the net that contains spyware. I want this to be prevented right from the start. Is there a way to prevent other users to install programs in...

Can both spybot and adware run on the same system? Aren't there going to be any conflicts? How about the integrity of other installed programs?