Viewing 15 posts - 1 through 15 (of 23 total)
Could it be modified to search for patterns? Like trying to find Social Security Numbers as long as they were formatted
where pattern= 'xxx-xx-xxxx'
SQL has very limited support for patterns...
March 14, 2013 at 7:10 am
Alexander Kuznetsov (10/22/2008)
I can use something like SQL Compare which has been around for a while, has been thoroughly tested out by thousands of users, and probably does all (or...
October 22, 2008 at 2:53 pm
How do you handle objects (especially tables or columns) that were removed as part of a deployment? How does the rollback script get them back? Do you never actually delete...
October 22, 2008 at 6:59 am
The weakest piece of any security technology is the human component. Effective security requires people with integrity who take pride in their work.
Integrity and pride are learned behaviors. Let's teach...
July 26, 2007 at 6:13 am
I know my music collection is a little different from the norm. Here's the first five that came to my mind.
Tokyo Kosei Wind Orchestra - Guest Conductor Series #4
Eastman Wind...
February 9, 2007 at 6:17 am
When choosing dynamic, parameterized SQL statements versus stored procedures, there are no technical advantages of one over the other.
Performance was mentioned. However, dynamic, parameterized SQL statements are just as efficient...
September 19, 2006 at 6:29 am
If you quit "working", you stop living. If you're not living, you end up dying. My father just retired two years ago. He is as busy now as he was...
July 7, 2006 at 6:11 am
The first substantive program I wrote on my own was an emulation of a board game called Kensington. This was done on a TRS-80 Color Computer with 16K of RAM...
April 28, 2006 at 6:33 am
I looked at tsqlunit. With VS2005, I think it is easier to use NUnit to test our stored procedures. Here's what we've done (VB.NET code)...
1) Created an NUnit test fixture...
February 9, 2006 at 7:04 am
I'm with you 100% on the need for an automated method to change management. I agree with you completely on how the automated process should work.
The key to making all...
August 11, 2004 at 8:00 am
I think your sample data in the artice has a typo. Should the last two entries use values of (1,2,4) instead of (1,1,4).
Additionally, how do you intend to represent bonus...
July 22, 2004 at 6:23 am
quote:
With the limited data in the example, the above statement gives me the data I'm looking for, but when I uncomment the...
August 26, 2003 at 6:59 am
I'd like to confirm that using the return value to return error messages is an excellent use of the return value. It makes stored procedures much like functions. In our...
August 5, 2003 at 7:07 am
We've had the nested insert problem in a number of places in our stored procedures. Here's our solution. Perhaps somebody has a better one...
The first procedure does not perform an...
June 27, 2003 at 7:09 am
quote:
Thanks all for valuable suggestion,Actually i want to install sql server 2000 first,thanmy database and after that my application which is a...
June 27, 2003 at 6:25 am
Viewing 15 posts - 1 through 15 (of 23 total)