Viewing 15 posts - 10,621 through 10,635 (of 13,469 total)
my pleasure; something like this is much easier to understand visually like that. glad i could help.
August 18, 2009 at 8:27 am
here's something to help visualize it:

August 18, 2009 at 7:55 am
Dave Ballentine showed you step by step how the conversion is going to work; but if you use the final answer, you don't get the timne portion, just the correct...
August 18, 2009 at 6:11 am
Yes = You meant something else?
or
Yes = That was the solution i was looking for?
August 17, 2009 at 10:49 am
ok if there could be multiple spaces before the period,
here's how i would do it: i thought about STUFFing it, but relized there's a simpler solution:
i would simply grab the...
August 17, 2009 at 10:46 am
if you mean when you copy and paste from Management Studio to Excel, it's an option you'll want to turn on:


did you mean something else?
August 17, 2009 at 10:37 am
conversions like this are a pain; obviously, whenever possible, this kind of data should be placed in a datatime filed, instead of a varchar/char; if you can, convert your original...
August 17, 2009 at 8:19 am
ajith.ranjan (8/17/2009)
Your code worked for me. Next step is I have to workout how to pickup one file at a time from the directory.
It is great if...
August 17, 2009 at 5:47 am
why does it fail though? I'm speculating that the constraint is merging the INSERTED and the DELETED rows to get the count or [INSERTED] and [tbl], so it finds...
August 14, 2009 at 10:59 am
your example was interesting!
I see how that fails, when I'd obviously think that was jsut fine...That's what you mean about having to test the business condition in the trigger instead,...
August 14, 2009 at 10:40 am
I saw mine jump up; thanks!
I got promoted as a result and I'm in the "Hall of Fame" now. only 17,000 more posts and I can be like
Steve Jones...
August 14, 2009 at 10:24 am
here's a simple example I whipped up to show the table constraint preventing more than three items checked out per student id:
Create Table tblStudent (
StudentID int identity(1,1)...
August 14, 2009 at 10:18 am
David Portas (8/14/2009)[hr
SQL Server unfortunately has quite poor support for referential integrity and other declarative constraints in the database. Such rules often have to be implemented in procedural code either...
August 14, 2009 at 9:55 am
recursive triggers is a per-database option; it is usually rare that you really need to call a trigger recursively, so it's disabled by default.
right click...properties for the database in quesiton...Options...

August 14, 2009 at 9:28 am
another thing you can try to change is this:
WHERE searchstring like '%@search1%' AND searchstring like '%@search2%' searchstring like '%@search3%'...
if you search for LIKE '%something%' , then it requires a...
August 14, 2009 at 9:02 am
Viewing 15 posts - 10,621 through 10,635 (of 13,469 total)