Viewing 15 posts - 16,561 through 16,575 (of 18,926 total)
This works for me : Select * from dbo.SysObjects for XML auto
June 20, 2005 at 6:47 am
June 20, 2005 at 6:44 am
Just make sure you get the minimum rowcount from the remote server. This will help a lot because it'll be less work for sql server.
Also test a few versions...
June 20, 2005 at 6:39 am
This is something that is easier done at the client.
Just do : Select fruit from dbo.Fruits order by Fruit
Then when you read the recordset, just use the bookmark number or...
June 19, 2005 at 7:28 pm
http://www.microsoft.com/sql/msde/downloads/default.asp
There's also an express version of sql server 2005 that's gonna come out in november without the 5 users limit.
The 5 users is actually 5 simultaneous process. But...
June 19, 2005 at 7:23 pm
I would have to go with Kathy on this one. The fact is that if a 1 first user modifies a record while the 2nd user in using it,...
June 19, 2005 at 1:40 pm
Can't provide one without seeing the whole code, sorry.
June 19, 2005 at 1:25 pm
I don't think you can do this. Go is the batch terminator.
Can you post the code so we can provide suggestions?
June 19, 2005 at 8:00 am
I've never done anything like this, but I still don't see that code hapenning without dynamic sql. You just can do select ? from @TableNameVar.
Sorry if I can't provide...
June 18, 2005 at 6:44 pm
Sounds like you have two problems. First you cannot use @TableVar.column. You must assign an alias to the table variable to be able to do something like TV.Col=...
June 18, 2005 at 12:43 pm
SSN and CCODE are the primary key, and are therefore always included as a refference in the index.
Also if autonumber and ModifiedDate are not used in the same where condition...
June 18, 2005 at 12:38 pm
Yes, sp_oa are notoriously slow. They cause a lot of overhead (in memory/cpu mostly). If you could batch import the files, then in 1 select statement, validate/split, then...
June 18, 2005 at 12:35 pm
Oops... at least he got the idea
.
June 18, 2005 at 12:33 pm
I haven't experienced with it yet... But I guess it can help if you've written class in .net that you need to use on the server. But I don't...
June 18, 2005 at 12:29 pm
Make sure you call the proc in this manner:
Declare @OutParam datetime
--not mandatory
--set @OutParam = 'somedate'
exec dbo.twrsp_ModifyLastDownloadTimestamp @OutParam output, 'UserName'
Select @OutParam
June 17, 2005 at 8:37 pm
Viewing 15 posts - 16,561 through 16,575 (of 18,926 total)