Hi,

As mentioned...

Derek (3/17/2009)

---

There is one table which has a foreign key constraint.. I have to delete all the data in this and while adding new data the primary key should start...

Hi,

Could you tell me what authentication you have used to connect to the server. It seems to be that you are using windows authentication to connect to...

Hi,

Check whether mysqld.exe or mysqld_nt.exe is running in the server machine or not. If not start this exe and try connecting to it.

Regards,

Ashok S

Hi Guys,

This is really a nice topic to discuss. Let me add my experience about the error. I have created a SSIS Package 2005, and in...

polo_sport9 (3/18/2009)

---

i have only insert this on lonekat

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)

VALUES ('Ingångslön',10000,0.10)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)

VALUES ('Junior säljare',15000,0.40)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)

VALUES ('Säljare',20000,0.60)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)

VALUES ('Senior säljare',25000,0.80)

INSERT INTO LONEKAT (beskrivning,manadslon,provisionsandel)

VALUES ('Grupp...

Hi Thompson,

Hope this code will help you in getting the result.

CREATE TABLE #TEMPCHAPTER

(

CHAPTERID INT

,CHAPTERNAME VARCHAR(100)

,NO_OF_PAGES INT

)

INSERT INTO #TEMPCHAPTER

SELECT 1,'CHAPTER1',2

UNION ALL

SELECT 2,'CHAPTER2',4

UNION ALL

SELECT 3,'CHAPTER3',1

UNION ALL

SELECT...

Also look this link,

http://www.sql-server-performance.com/tips/blocking_p1.aspx

Regards,

Ashok S

Hi,

Read the arguments section of this link,

http://msdn.microsoft.com/en-us/library/ms189470.aspx

Regards,

AshoK S

Hi Roy,

I may be bit late for your query, but hope even this code gives you the result you are expecting :).

...