I have a project in Borland C in which i need to Connect with SQL server 2000 plz give me the code for that.

Assuming you have a 32-bit version of the compiler, google for ODBC and you will get lots of information. ODBC is the most common way to access any database. There are several free c++ classes on MySql web site and www.codeproject.com. You can access ODBC from either C or C++, but I don't know how much information there is for just C.

You also need to study the SQL language -- google for that too.

Assuming you have a 32-bit version of the compiler, google for ODBC and you will get lots of information. ODBC is the most common way to access any database. There are several free c++ classes on MySql web site and www.codeproject.com. You can access ODBC from either C or C++, but I don't know how much information there is for just C.

You also need to study the SQL language -- google for that too.

I just need the code for connecting the sql server 2000 using borland c

I just need the code for connecting the sql server 2000 using borland c

No one will write code for you...
Here is library for accessing SQL...Link
it contains lot of examples...modify it according to your needs