Search results for query: *

Thank you. I updated the post. Does it work for you now? I still can not get it to work correctly though. Thank you.

...background-color: yellow; } .highlight { background-color: #fff34d; -moz-border-radius: 5px; /* FF1+ */ -webkit-border-radius: 5px; /* Saf3-4 */ border-radius: 5px; /* Opera 10.5, IE 9, Saf5, Chrome */...

Thank you Jpadie.

Hello Can anyone write a MYSQL query that is somewhat equivalent to the following? CREATE PROCEDURE CountPhoneNumbers AS DECLARE @count INTEGER SELECT @count = COUNT (*) FROM Customer WHERE HomePhone IS NOT NULL Print @count Thank you!

Good advice. Thank you. Chillay

Hello I am testing my query to ensure that it rolls back to the first insert statement. It does not seem to be working correctly. In the following query I do not understand why the first insert statement does not insert a record into the ServicePlans table when I cause a syntax error in the...

This is great information. Although they return the same result I was wondering why the syntaz was upgraded. Thanks! Chillay

Hello Does anyone know why is it best to use the new SQL92 INNER join syntax rather than the SQL89 INNER join syntax? I know it gives the same output and is processed the same but does anyone know why this syntax was created over using a simple WHERE clause in inner join queries? Thanks Chillay

Thank you genomon! Chillay

Is there a basic SQL command to insert an image using Jet SQL. I tried the following in Access 2007: ---- CREATE TABLE Experiment ( Field1 COUNTER (40), Field2 IMAGE ); ----- INSERT INTO Experiment (Field2) Values ('C:\Users\Cecelia Allison\Desktop\Addy.bmp'); ---- The field comes up...

Thank you. Sounds good. Chillay

If I'm creating a Customer table that includes contact info and I require either a phone number or an email address, how can I ensure that both fields cannot be left blank? In other words, a customer's record can have an entry in the Phone column or in the Email column or in both, but it must...

Thank you very much RivetHed. That was so very helpful. I appreciate it. Chillay

I work with Access and have a database that was created by someone else that I now work with. I ran across this in a subform for one of the databases we use and was curious about [form]![combo107]. I use it to select a specific event someone is participating in but don't understand how it...

Thanks. I will look into it. I am looking for a version of SQL Server that is free with no expiration date since I am only using it to debug script. CE seemed to be what I was looking for yet I have errors with nested subqueries. Thanks again! Chillay

I was using SQL Server 7.0. Vista does not support it or the normal SQL Express. I can not tell you how much software I had to repurchase due to Vista not supporting the software. My printer does not work with the current drivers and at one point I could not connect to the Internet until I...

I teach a course that supports several different DBMSs platforms. I often debug script for the students. After buying a new computer with Vista my version of SQL Server no longer runs. I was able to download SQL Compact Edition and now I am in the process of testing all of the SQL script...

- When I run SELECT @@VERSION I get the following: Major Error 0x80040E14, Minor Error 25623 > SELECT @@VERSION The global variable name is not valid. [ Global variable Name = @@VERSION ] - Following is my version information: SQL Server Compact Edition Microsoft SQL Server Management Studio...

Following is the original qualified query that gives me the error: SELECT Customer.FirstName, Customer.LastName, Customer.HomePhone, (SELECT MAX(Orders.OrderDate) FROM Orders WHERE Orders.CustomerID = Customer.CustomerID) AS LastOrderDate FROM Customer Error: There was an error parsing the...

For some reason I get the same error when I run your query Alex. Thx Chillay