Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mobile@digitaltrendz.co.z
Starting Member
25 Posts |
 Posted - 2009-02-03 : 07:56:03
|
| Hi I have an application, which uses an sql express database. I need to be able to send my client a single file which they can execute without user intervention to update or even append data to a specific table. Is there a way of doing this using sql?. if so what would be the best method?Thanks |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-03 : 08:07:01
|
| Read up on the sqlcmd utility. It lets you write command line sql server code. If you put this in a .bat file your client would be able to run the .bat file and that should handle the work. Make sure you consider your file name and path. For ease of use on your client side they should probably remain fixed so all they have to do is put the file in a given directory and make sure the name matches what you specify for them. I'm assuming you're using 2005 or higher for this. Steer clear of isql and osql. isql is no longer supported and osql will be depricated in a future release. isql is not available in 2005.Mike"oh, that monkey is going to pay" |
 |
|
|
mobile@digitaltrendz.co.z
Starting Member
25 Posts |
Posted - 2009-02-04 : 03:03:15
|
| Hi mfemenelThanks I will do some research sqlcmd utility however I think this might not serve my purpose. I think I will write a function built into my application. Something like a import export function as I require the file be secure. I don't believe that using legacy bat files would be wize.Thanks for your response I appreciate it. I will let you know if I find another solution.If anybody else has any ideas I would like to here about them |
|
|
|
|
|
|
Import using self executable