Viewing 15 posts - 16 through 30 (of 39 total)
You can put a short message inside the name of CK. When a user reads a violation message, he will see that message too. I do it like this:
CK_Table_1_[_Field_length_must_be_6_]
-where CK=...
November 19, 2003 at 1:33 am
If everything else fails, try MSSQLRecovery tool. I accidentally found this tool, but when I really needed it I didn't know about it. Maybe it will be just right for...
November 14, 2003 at 4:27 am
I've tried several tools that could automate gathering of data from Internet, but each does things differently and requres you to learn to use it efficiently:
- iOpus Internet Macros (run...
November 5, 2003 at 7:26 am
When I was listening to a good XML lecture by a really knowlegable XML guru, there are some things I remembered that are seldomly emphasized:
XML = DOM (Document Object Model)
XML...
October 22, 2003 at 1:34 am
Here's what I do. I give the constraint a meaningful name, like in your case:
CK_grade_[Grade_field_expects_a_valid_grade].
The user will get a check constraint violation message and also the constraint name, which...
October 15, 2003 at 5:45 am
Not much help here, right?
Unfortunately cross-database connections are all hard-coded in SQL Server because it can't do double evaluation. That would be to use a variable for object name. In...
October 3, 2003 at 2:58 am
quote:
Information Schema Views were introduced in Microsoft SQL Server 2000
No, no, no, INFORMATION_SCHEMA views...
September 18, 2003 at 7:15 am
quote:
We have found Visual Studio .NET a great way to do SQL coding. SourceSafe is built-in to .NET and it is...
August 25, 2003 at 4:17 am
quote:
Is there a restriction on how you use Input Parameters? The following code tells me I have to declare the input variables...alter...
July 14, 2003 at 5:42 am
I use identity as a primary key of a table for easier handling of records that is strictly local for a table. Example: triggers (joining inserted and deleted),...
July 14, 2003 at 5:18 am
quote:
Hi alicejwz,from what you have sent me off-forum, could it be you have a bit field in one of your tables without...
July 10, 2003 at 3:25 am
Look like you ran into a loop. Trigger triggers itself until 32-level nesting limit is exceeeded. Have a look at "TRIGGER_NESTLEVEL" in BOL, check out the sample and set trigger...
June 23, 2003 at 1:07 am
Read the Service Pack 3 Readme.htm. I also had a problem with SP3 because it disables ad-hock queries. I used OPENQUERY.
Hope that helps,
Jani.
June 23, 2003 at 12:39 am
In SQL Server you have to switch thinking from cursor to set oriented actions. Virtual table [inserted] contains what is in the table after event, [deleted] contains data that was...
June 12, 2003 at 1:50 am
Slow EM opening of the database tree is a known problem (at least to people in my company). The problem is isolated to workstation and it gets worse in time...
June 4, 2003 at 1:58 am
Viewing 15 posts - 16 through 30 (of 39 total)