I haven't any mention to Access ADP which by the way are supposed to support SQL Server in the Back end NATIVELY!

Just my 2 cents

You may not need to know if the year is leap or not:

You can always do the Following

1. Find next month number

2. create the First Day of that next month

3....

I Believe I have to join Frank Kalis club of new words persnickety

* About the Normalization Aspect of the problem I concur with it...

quote:

---

A minor refinement of noeld's excellent second suggestion:

SELECT

q1a, q1b, q1c, q1d

, q2a, q2b, q2c, q2d

FROM mytable

WHERE

CASE

WHEN ( q1a +...

That's a very good point. You should add constraints AFTER the table definion so that those can be named by yourself!

if you plan to rename the constraint you will have...

Disregard my previous answer, (I am tired )

Along as you don't have nulls you can:

SELECT * FROM MYTable

Where

( (q1a/3) + (q1b/3 )...

SELECT COLUMNPROPERTY( OBJECT_ID('TblName'),'Column_Name','IsIdentity')

HTH

I am little tired but this may get you started. Considering You Have NO NULL NEITHER 0 in the q's you can:

SELECT * FROM MYTable

Where

( q1a*q1b*q1c*q1d > 2)>1

OR

( q2a*q2b*q2c*q2d...

if You are using OLEDB Provider for ODBC Drivers to connect to the remote DB I believe you are out of luck on that one. It is very dependent on...

For a simple query you could also use bcp

This Search is something really good if you can somehow make it work. I believe you can do it

Go for it!!

If You don't have other constraints on the column like a default, etc

then

ALTER TABLE dbo.STATES 

ALTER COLUMN CountryID YOUR_TYPE NOT NULL

if you have other constraints,

1....

Your Answer is Today's QOD

ALTER TABLE MyTable DROP CONSTRAINT MyConstraint

GO



ALTER TABLE Mytable 

ALTER COLUMN Mycolumn varchar(100)

GO



ALTER TABLE MyTable ADD CONSTRAINT MyContraint DEFAULT 'New' FOR MyColumn

GO 

...

Have you tried?

 

sp_sproc_columns

I don't Use Access this Fashion. I prefer Adp Files but what I believe is Happening is that you have an EXECUTE Statement in the definition and you...