In SQL sever managment studio, go to server property-->connection, check the option "Allow remote connections to this server".

The returned data type is the same as the first parameter in the Power function. So you cannot pass integer 10  as the first paramter. Try this:

SELECT

...

That's not the issue. The issue is you have -x as part of the file name. As I said, if you use quotes around the file name, it will work....

You have -f-n-x in the format file name. Use quotes around the file name:

bcp AdventureWorks.HumanResources.Department format nul -x -f "Department-f-n-x.Xml" -n -T

Or use a simple file name:

bcp...

Yes, you can use BULK INSERT to load the csv into a temp table. Then update or insert to your table like this:

UPDATE A

SET valueCol1=B.valueCol1, valueCOl2=B.valueCol2,... 

FROM yourTable A, yourTempTable B

WHERE A.Key=B.Key

INSERT...

Why not drop and recreate the constraint?

You can define a linked server to that excel file, and T-SQL SELECT statement to do the join etc.

Calculate the summary data and join with the detail table:

SELECT @PArentID AS PArentID, Parent.TotalAmount,D.Amount

FROM Ch_detail D, Ch_PlaceMaster E, Ch_PlaceMaster F, 

(SELECT SUM(Ch_Amount) AS TotalAmount FROM Ch_detail A, Ch_PlaceMaster B, Ch_PlaceMaster C

WHERE...

What SQL release are you talking about? SQL 2000 or 2005?

@f1 - cast(@f1/@f2 as int)*@f2

Express edition does not support import/export. Check BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm under SQL Server 2005 Integration Services Features.

1) Yes. if you have system admin rights you can change the password without needing the former one.

2) The sql registeration window is to define the credential SSMS used to...

If you create index on column varchar(1000), you can never insert data to that column bigger than 900 bytes becuase this will break the index. You will get an error...

It is  supported to run both instances of SQL Server 2000 and 2005 on the same PC. But you need to install 2000 first and then install a named instance of...

Bcp does not have this property.

You can try osql.

osql -E -Q"SELECT * FROM view" -o "outputfile"