Re: Query two databases with asp

let's make sure I have this straight:

DB1..School
ID numeric (precision and scale please?)
All the rest of the fields are nvarchar? What are the defined lengths?

DB2..Users
ID numeric (precision and scale please?)
firstname varchar (length?)
lastname bit ???
address int ???
city numeric???
CompanyName datetime ???

Huh???


dusty wrote:
DB1\school table
int
nvarchar

DB2\Users
numeric
varchar
bit
int
numeric
datetime


"Bob Barrows [MVP]" wrote:

dusty wrote:
I'm trying to create an asp page that will allow users to generate
search results by querying mssql databases.
I inherited these databases and did not build them. Here's the
scenario.

I have two databases: DB1 and DB2. School is a table of DB1 that
consists of the fields:
ID, Parish, School, Principal, address, city, zip, etc.

Users is a table of DB2 that consists of the following fields:
ID, firstname, lastname, address, city, CompanyName, etc.

What are the datatypes of these fields, please?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: SQL Statement and Grouping for VB/Excel Project
    ... increase the precision of the decimal type to get around. ... > Bob Barrows ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Statement and Grouping for VB/Excel Project
    ... increase the precision of the decimal type to get around. ... > Bob Barrows ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.vb.database)
  • Re: SQL Statement and Grouping for VB/Excel Project
    ... increase the precision of the decimal type to get around. ... > Bob Barrows ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Statement and Grouping for VB/Excel Project
    ... increase the precision of the decimal type to get around. ... > Bob Barrows ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.vb.general.discussion)
  • Re: Insert pictutes
    ... Using the following should accomplish the same thing: ... Please reply to the newsgroup unless you wish to avail yourself of my ... myrange.InlineShapes.AddPicture photoPath, False, True ... but scale width and scaleheight don't have any effect on the picture size ...
    (microsoft.public.word.vba.general)
Loading