Dear .NET is there a way to produce a (text) script using SQL Server or Query Analyzer that will have the data of some table ? or maybe some program to do it ? for example - data script will look like this:
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 10)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (10, 'Error: PostID Parameter Not Specified', 'You have attempted to visit the Web page to display a forum''s post, but, for some reason, the PostID was not successfully passed in.')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 11)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (11, 'Error: There was a Problem Posting your Message', 'There was a problem posting your message. This is most likely due to the fact that while you were replying to a message, it has been deleted by the administrator. We apologize for any inconvenience.')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 12)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (12, 'Error: The post you are attempting to view has not been approved', 'You are unable to view this message due to the fact that it has not been approved. Most likely this is because you are trying to view a post that was posted to a moderated forum and has not yet been approved by one of the forum administrators.
Once this post has been approved, it will appear in the forum list and you will be able to view its contents.')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 13)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (13, 'Your user profile has been successfully updated', 'Your user information has been updated and will be reflected immediately.
Please return to the ')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 14)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (14, 'Error: User Does Not Exist', 'The user you attempted to view does not exist.')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 15)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (15, 'User Password Updated', 'Your user password has been updated and mailed to you.')
IF NOT EXISTS (SELECT MessageID FROM Forum00_Messages WHERE MessageID = 16)
INSERT INTO Forum00_Messages (MessageId, Title, Body) VALUES (16, 'Error: User Password Update Failed', 'Your password update operation failed - your password has not been changed.')
Yovav
Member
702 Points
181 Posts
How 2 produce a script out of my DATA (from table) ?
Sep 03, 2003 08:06 PM|LINK
Best Regards
YovavG@GMail.com