| Recent Answers |
 |
|
2008-08-29 SQL performance: OK... some progress, maybe. We are also laboring under the handicap of me not being familiar with MS OA. If I'm reading your replies right, this is a totally self contained situation. That is, your...
|
2008-08-28 SQL performance: Gentle? No way... HAVE AT YOU!!! Just kidding. Wow, this is probably going to take several back-and-forths, so feel free to post follow-ups as needed. First, have you done ANY internet research...
|
2008-08-18 triggers: Dear Oliver, You can create trigger on insert or update to update the result value in the records being inserted/updated. The query can be done using CASE keyword. For example: To update value of result...
|
2008-08-18 trigger: Oliver, First, my apologies for the delay. I thought I'd answered this, but the AllExperts system just informed me that I had not... I must have forgotten to hit the Submit button or something. Anyway...
|
2008-08-12 How to retrieve only the date part: Dear R. J. Premnath, The datepart is the in-built function that can be used to retrieve the part of the supplied date. The part can be day, month or year or even a time related item like seconds, milliseconds...
|
| More Answers for "MS SQL Server" |