I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the...

I have some tables that i have created in SQL Server and i want to write a stored Procedure that will insert data on to one of my tables AND also be able to update say if i select record

CREATE...

Thanks sknake i have now managed to solve it. Once again Thanks

Thanks. Yeah! I would like to add a parameter to the stored proc, and also for now if possible I would like to be able to do the whole process of generating the DocIds without a frontend.

In simple terms

If DocID on <TABLE B>
Select Surname, Initials, and Sex from <TABLE A>
Select DocID,AllocationDate from <TABLE B>

If DocID not on <TABLE B>
Create new DocID (insert on...

Right thanks, I m sorry if I wasn’t clear. I have 3 tables (structured as below) and all are in SQL Server. what I want to do is have a front-end like .Net or any other but the backend is SQL.
...

I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say...

i am not very sure is it different as in SQL where yu can go to the database that you want and then you go to the table and then you click the right side of yur mouse and go to design table and...

Yea i am trying to produce a page which is data sourced from several tables, so if create a 'view' of that data and select from the view in my ASP page.How do i connect the database [i mean the...

I have managed to join the OBDC to the database and I need to know how to join several tables in stored procedures so that the end form will be from a number of different tables. I have just...

I have now installed IIS. The reason I wanted to use ODBC was because I have seen it was on the machine I had used JDBC before and it wasn’t installed on the machine so I wanted to use ASP.

If I...

I intent to use ASP although i cannot get IIS on the machine which is window 2000 proffessional.now i do not know the step by step of doing this because i want to use ODBC as the middleware and ASP...

Please help !!!
I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized...