Thank you.

Thank you for a quick reply. I donot have any custom extended stored procedures or in process linked servers.

So do this kind of errors impact data inserts into a...

spectra (7/21/2009)

---

i want to make a question bank database for my web application.

i am doing the table structure.

i have come upto this..

Table Subject{subject_id(pk),subject_name}

Table Question {subject_id(fk),question_id(pk),question_description}

Table Quiz{subject_id(fk),question_id(fk),choice1,choice2,choice3,choice4}

TableAnswer{subject_id(fk),question_id(fk),answer_choice,answer_description}

but this is not correct...

nigelevenden (11/26/2008)

---

Hi, Please forgive me sounding silly but I am a bit of a novice...

I am getting the follwoing errors. Are these as a result of my copying and pasting...

Hello hsitas953

I found that when I copy and paste the code...

EK (11/20/2008)

---

I have a SQL Server 2000 database that is poorly designed. I barely know what I am doing, this is not my normal job. I am trying...

Are you using the initial script or the modified script? Would you mind posting your table structure please.

Thanks

Is Your MailNO a unique column or does it allow duplicates. If your MailNo is a unique column and you want to build a primary key on the column it...

gwque (6/5/2008)

---

I'm debating whether or not to store formatted or unformatted phone numbers and/or postal codes in the database.

Advantages

User controls formatting, including complex international formats.

No need to dynamically set input...

Basically its going to be a quite a bit of performance hit as in your stored procedure where you used dynamic sql, the plans are not used its a better...

This is straight forward. We were trying to re-invent the wheel 🙂

Even with SET QUOTED_IDENTIFIER ON, it doesnot compile. The query analyzer returns the following error message.

Server: Msg 207, Level 16, State 3, Procedure sp_DataAsInsCommand, Line 27

Invalid column name 'SELECT 'INSERT...

Please post your table structure and the columns based on which you want to drive deleting the duplicates.

Thanks

You can find slides on UDF at this location for download.

http://support.microsoft.com/kb/325105

Thanks

You may want to use the convert function based on how you want to save the output of GETDATE() function in your DateUpdated Column.