DKelley
Last Activity: Jun 20 '07, 03:56 PM
Joined: Jun 14 '07
Location:
-
Thanks, Motoma, I was afraid that might be the case. I was hoping to avoid having to build a new tool to take care of this "simple" task outside the normal procedures we use to upgrade our customers....... -
I wouldn't think it would matter what you "put into a varchar" as long as when you "pull" the text back out you DISPLAY it in the same manner from where you saved it. That is, if you used a simple text box for a line of entry then it likely won't matter. But if you use a Rich Text Box for input, then you should use a Rich Text Box for output once the data is retrieved from the database, Newline characters and all. Even a single-quote...Leave a comment:
-
I believe the max size is however big the available hard drive space is - I've seen them over 2 GB because our customers don't always do the maintenance they should do. But in reality, the database should be backed up and the Trans. log shrunk before that theoretical maximum is reached.Leave a comment:
-
So should I take the lack of response to mean that there is no way to trap this kind of error?Leave a comment:
-
Error handling with CREATE INDEX
I'm receiving a "severe" error that I can't seem to trap and evaluate in SQL Server 2000 (and no, I can't switch to 2005, this is on our customers' machines). And I've not been able to find info on this specific problem.
This is essentially the statement I'd like to catch and gracefully quit if it occurs:
CREATE UNIQUE NONCLUSTERED INDEX UQ_First_Key_Se condField_Third Field
ON [dbo].[DetailTable] ( Prime_Key,... -
The SQL Server Books Online is an excellent reference in my experience. Just open the Start menu and drill into the Microsoft SQL Server menu to open Books Online. Once open, click on the Index tab and type in "functions" and you'll find that is a great reference point to work from.
If you're new to database programming in general then the Books Online barely be sufficient so you'll probably want to start somewhere else...Leave a comment:
-
Isn't SCOPE_IDENTITY( ) the better function to use? @@Identity just returns the last primary key which may have been in a different scope.
That is, if a another user called a stored procedure that ALSO created a new record my understanding is that the newest primary key would be returned - even it if was created for a different user in another scoped instance of that same stored procedure.Leave a comment:
No activity results to display
Leave a comment: