Please help me in sorting out my Problem Providing me the solution . My Problem is I have a master table with Primary key on ID field (PatientID-(Patient-Table)) and it is an Identity field And My child table has the same ID field(PatientID-(PatientDetails-Table)) and it has the relationship set And...

I have a SP that I can run from QA, and command line with no issue. But for some reason it hangs when it's called from the APP. At first we thought it was a cache issue so I put WITH RECOMPILE in the SP. so we started a trace in it. We found the part that was having the issue. The issue is at a Link...

I know may be it will seem a newbie question, but i facing this problem. I have created a table users where i have 3 columns CREATE TABLE USERS (ID INT IDENITITY(1,1), USERNAME VARCHAR(10), USERID INT) Now every time there is new requirement to create a user i call a procedure to check if requested USERID...

We are transferring about 400 records from a table in a remote database on our web server to a database on our local server using a .Net program. The program reflects that the number of records transferred as 400 and also the message that transfer was successful. But when we use SELECT statement to view...

You can take help of WORKTABLEs and use bulk load features in SQL Server such as using DTS, if you have control over the process that creates the text files, it might be better to create two files—one with inserts and another with updates only. This way you can bulk insert the new rows using bulk copy...