Viewing 15 posts - 38,806 through 38,820 (of 39,803 total)
I try to avoid dyanmic sql whre possible. I choose case statements to call stored procedures for various queries.
It avoids the problems with owernship chains.
Steve Jones
January 3, 2002 at 11:31 am
The for xml is built to return a stream, not really a result set.
You could probably built something, but can the middle tier not handle a stream? They can also...
January 3, 2002 at 11:18 am
Wes, thanks for the info.
I've used DELL Compaq, Adaptec, Mylar. No issues with any but some are easier than others to setup and work with. I have had SCSI backplace...
January 3, 2002 at 11:07 am
I extensively use the CTRL-SHIFT-C and CTRL-SHIFT-R extensively in QA to comment and uncomment a series of lines when making queries (as well as begin tran).
Why?
Too often I've typed the...
January 3, 2002 at 11:04 am
Try this:
declare @d datetime
select @d = '01/03/02'
-- first day of month
-- select cast( convert( char(6), @d, 112) + '01' as datetime)
-- last day of month
-- select dateadd( day, -1, dateadd(...
January 3, 2002 at 10:47 am
January 3, 2002 at 10:33 am
You will have problems because the limit for a parameter is varchar( 8000) and an XML doc can easily exceed this.
Form BOL, Generally, FOR XML cannot be used for any...
January 3, 2002 at 10:32 am
We use FTS for your search on this site and there are more than 200 records. Can you provide more info?
SQL Version? SP?
NT/2000? SP?
Event Log errors? SQL Log Errors?
Steve Jones
January 3, 2002 at 10:10 am
Also, what does the job do? Use network resources? connect to another SQL Server?
I agree with Brian.
Steve Jones
January 3, 2002 at 10:05 am
January 3, 2002 at 9:45 am
Yikes, yes somehow our data got crossed.
this should be fixed shortly.
OK, so encryption doesn't easily work. Here's what I recommend for something like Credit cards.
1. DO NOT connect the db...
January 2, 2002 at 5:02 pm
January 2, 2002 at 4:52 pm
January 2, 2002 at 4:44 pm
Funny, but my group and boss have the same belief that I am too busy to be bothered with many things. I consider myself approachable and usually can fix issues...
January 2, 2002 at 3:18 pm
January 2, 2002 at 3:15 pm
Viewing 15 posts - 38,806 through 38,820 (of 39,803 total)