Viewing 15 posts - 91 through 105 (of 172 total)
Good point. If the files differ by some part of their name change the * in the parenthesies to a regular file pattern match. for instance if you have files...
June 21, 2006 at 9:03 am
Why not just script the stored procedures to a text file? Then as you move thru the procedures, you can add your own comments to the text file and easily find...
June 21, 2006 at 8:47 am
set up a batch file with a command similar to the following:
cd directory where files live
for %f in (*) do bcp <Yourdatabase.owner.yourdbtable> in %f -S <YourServerName> -U <UserName> -P <Password>
June 21, 2006 at 8:40 am
Two things you need, first the column has to be defined nullable in the database. Then you can save System.DBNull when you update the table.
June 21, 2006 at 8:20 am
Take a look at NAnt http://nant.sourceforge.net Its free and has a lively community.
Its intended as a build tool, but I am currently working with it to do my deployments too. ...
June 5, 2006 at 5:52 pm
There's always good old fashioned DOS Batch files. Use OSQL to fire up the script in SQL and MSTASK to run the batch file on schedule.
June 5, 2006 at 9:14 am
If all you want are the tables, there's BCP thats part of SQL server. It will give you a CSV file of a tables contents and allow you to put...
May 31, 2006 at 9:00 am
Sounds like you're running into the varchar size limit. Try writing the xml to a text blob and have the .net app fetch it from there.
May 31, 2006 at 8:50 am
Rudy, you forgot Documented.
I don't have to like the standard, but if its documented i will follow it.
Bill - evil developer and part time dba
May 26, 2006 at 11:42 am
The IIF function is really nice for testing values before a computation. It works much like an If/Then/Else statement in Visual Basic. The first parameter can be any expression that...
May 25, 2006 at 9:25 am
Something like this ought to set you on the right path. In your Web.Config or App.Config set up the ConnectionStrings that you want to iterate thru. You can get...
May 23, 2006 at 11:38 am
Don't forget that I can see those credit card numbers as they go across the wire too. All I need is a spot between the app and the database that I have access...
May 23, 2006 at 9:08 am
you're going to have to put in a machine name somewhere to fill in the connection string. it almost sounds like you are going to have the database for the...
May 23, 2006 at 8:59 am
after you create your connection object, start a loop
for each connection string in The_List
set the connection string to the connection object
open the connection object
do some work
close the...
May 23, 2006 at 8:50 am
It looks like you have a nasty job ahead of you. For those date formats that SQL recognizes you could do something like this, requires two columns in your new...
May 12, 2006 at 9:31 am
Viewing 15 posts - 91 through 105 (of 172 total)