Viewing 15 posts - 241 through 255 (of 256 total)
Ok, I think I read it wrong, I thought the statement was only Adding one Row to a Table...sorry about that.
July 31, 2003 at 8:00 am
Yes, this is correct. If you are familiar with ADO.NET, then this makes sense.
A Command (or DataCommand) is any kind of SQL Statement in ADO.NET whether it's a Select,...
July 31, 2003 at 6:41 am
On the same Note, I need to use the "SCM" command line tool to determine if the Service Manager is started during an Installation program. For some reason, the...
July 31, 2003 at 6:37 am
Hmm, I've never seen an Insert statement like that...would someone enlighten me as to why you would need a Group By / Order By in an Insert Statement? I'm...
July 31, 2003 at 6:29 am
My God man, why would you ever let Crystal touch your DB!?? Kidding!
I never let Crystal touch the Database and the number one reason for this is for some...
July 31, 2003 at 6:26 am
Hmm, odd. I'm using VS.NET 2003. I imagine you are trying to use the IDE to make your connections?
Try doing straight code instead:
Dim sqlCon As New sqlClient.SQLConnection("Data Source=(local);Initial...
June 25, 2003 at 6:30 am
Probably not, I just wondered if it could be done. Most of the time, if possible, I like to create Generic routines...if it can't be done, so be it...
June 9, 2003 at 8:00 am
Sweet! Thanks, this worked! One more question...is it possible to make a Generic function for any Table that I might want to do this to?
Example:
CREATE FUNCTION GetDataList
...
June 9, 2003 at 6:41 am
Ok, here is a Stored Procedure I wrote based on the things in this Post. If someone would analyze this to see if I missed anything I'd appreciate it....
April 24, 2003 at 8:10 am
Hmm, that sounds good. The application I have developed should be able to be used "Stand-Alone" as well.
If I setup a DB that is Replicated, but then Script it...
March 17, 2003 at 3:33 pm
Ok, I think I understand. I must have read the Licensing wrong. It seemed like each MSDE machine needed a License if Replication was used. However, how...
March 17, 2003 at 3:12 pm
Thanks for the Reply tcartwright, I'll look into that more when I have a chance!
March 17, 2003 at 2:49 pm
All I really want to be able to do is Import an XML file into a (blank) Table as fast as possible. I would never want to Bulk Insert...
March 17, 2003 at 2:15 pm
My first impression is...you can't do this without some manual programming effort. I develop very large scale Synchronization programs that transfer data from one SQL Server to another. ...
March 13, 2003 at 6:49 am
Wait, I just thought of somethng! If you've recently installed SQL Server SP3, by default it sets up the Server Logins for Windows Authentication ONLY! What you need...
March 13, 2003 at 6:36 am
Viewing 15 posts - 241 through 255 (of 256 total)