Hi Group
I like in the field with i.e. "ISRAEL ARTURO IÑIGUEZ PADILLA" separate this in
First Name in a Column
Middle Name in a Column

I have an application in which i need to get the foreign key fields
from a table and then get all the foreign keys primary key field from
the linking table. Could some one tell me how i do this using
INFORMATION_SCHEMA. I have tried and can get the foreign keys but not

Thank you for reading this question.
Any ideas on how to determine if the relationship between two fields in a
table?  As  1:1, 1:M or M:M?  I'm spinning my wheels on how to get started
with this.

Hi groups,
"select exam_date from  cam_applicant [ here i want to show '0' if any particular date was there ..say 01/01/1900 ]"
  I want to show '0' if any datefield is having this particular date 01/01/1900
Im searching like Isnull...type of keyword to replace this 01/01/1900 to ...

I have received SFKC_DATA.mdf with no log file. While trying to attach, EM
ask for location of log file. How can I create log file
Regards
SF

MOM contains its own Block Analysis script. It is a script written on
VB, that looks for the monitored servers, creates for each one
MomCreateObject("SQLDMO.SQLServer"), afterwards connects to each
database on each server and executes SELECT GETDATE() query. If MOM

Hello, any help is appreciated
Here is what I’m trying.  I want a month to date total of booking
based on a fiscal month
I can isolate my records for the month and sum up the days so I win

I've spent hours trying to find the error in the following SQL 2000
command:
ALTER TABLE [ClientList] ADD CONSTRAINT [PK_ClientList] PRIMARY KEY
CLUSTERED ([PhoneNo]) On [PRIMARY]

I have MFC VC++7.1 program which has the following code segment:
// Specify the colums and format to copy
retcode = bcp_columns(hdbc1, 6 );
if ( (retcode != SUCCEED) )

If you have several entities that have many common properties but a few
have a few unique fields to them how do you design your tables?
DO you make a seperate table for each entity even though they have many
common fields or is there a way to do an OO type thing where you have a

Here is the situation:
Tables:
Account
AccountDocument

Is there somebody ho can tell me how to import a '.dat' file in Microsoft
SQL Server 2000 Developer?
The '.dat' file contain a fully database, with many different tables. Each
of them contain many different rows.

I have found the Common Table Expressions described in SQL 2005 and I
am not sure if it applies to this situation.
Here are the tables
<PRE>

This is the first time i am tryin to write a sql server 2000 function.
I need to clean up some of my stored procedures..
Can any one please give me  skeleton for a userdefined function or
correct my function. I get the following error.

 I have an application that's running fine on development servers (web
and database-sql server 2000). I'm updating a record through a third
party component but I don't think the component is the problem. What's
happening is that I'm updating fields that are part of view. I'm only