Viewing 15 posts - 32,791 through 32,805 (of 39,740 total)
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
Do the new ids need to be unique?
Is this more complicated than:
insert b select * from A
insert b select * from A
insert b select * from A
...
?
November 28, 2006 at 11:11 am
The easiest way is the advice above using the sp_ms procedures. These aren't supported, but they will likely be continued since some MS procs use them.
November 28, 2006 at 11:10 am
It was created at the request of a member for discussions about employers and issues working for them.
The original thread is here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=325486
November 28, 2006 at 9:48 am
Viewing 15 posts - 32,791 through 32,805 (of 39,740 total)