Viewing 15 posts - 32,866 through 32,880 (of 39,818 total)
Thanks everyone for the comments and glad you liked the article. I'm kind of stunned by the response.
My apologies on the counting. I wrote the list and then started to...
November 30, 2006 at 3:47 pm
I think working in a small town has to be something you want to do, or because you want to go back home where you grew up. Moving somewhere small...
November 30, 2006 at 11:08 am
Jennifer's a friend who works for NetApp.
She's probably got a swimsuit, but I don't think she'd do a layout for us ![]()
November 29, 2006 at 8:36 am
Usually it's filtering if you aren't getting it. Or maybe some rule that snags it since the content changes daily.
They're always here: http://www.sqlservercentral.com/newsletter
November 29, 2006 at 8:34 am
DTS is the easiest way to do this. Open a new package, add a connection to SQL Server and one to your access db. specify your view and destination table,...
November 29, 2006 at 8:34 am
You can add "print" or select statements inside for testing as well.
create procedure mytest
@myvar int, @myvar2
as
select @myvar, @myvar2, 'parameters'
declare @mysum int
select @mysum = @myvar + @myvar2
print @mysum
select @mysum
return
This should return...
November 29, 2006 at 7:59 am
What is the ASP page trying to do? You have something that's read-only and if you're trying to update it, you might get an error.
November 29, 2006 at 7:59 am
Thanks for the update and not deleting the post.
November 29, 2006 at 7:56 am
I'd make each of these a separate procedure just for readability. But I'm not sure it's more than personal preference.
November 29, 2006 at 7:55 am
I think you can continue with it. At first glance I don't see any other 2005 features in there.
November 29, 2006 at 7:46 am
As I see above, they're bit maps. So if you set the 4th bit, leaving, 1, 2, 3 at zero, you have 1000 in binary, or 8.
Since you're dealing with...
November 29, 2006 at 7:39 am
I believe only Database Mail (as mentioned above) works in 64-bit. SQLMail is a leftover from SQL 2000 and only runs on 32-bit.
November 29, 2006 at 7:37 am
SQL Server gets time from the OS, which gets it from the hardware clock. An update, like the DST we have in the US, is slightly delayed (a second or...
November 29, 2006 at 7:36 am
I'm looking forward to Simon's post and a recursive reference as well ![]()
If you haven't checked out his blog (we link it in Database...
November 28, 2006 at 6:22 pm
Viewing 15 posts - 32,866 through 32,880 (of 39,818 total)