.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

exec sqlcmd and bat files in a single bat fiel . How can I do it?

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server
 

Hi all

I cannot seem to work out how to put it together I get all sorts of errors

 I would like to create a single bat file that execute 3 bat files and runs 10 sql scripts.

Any examples? help thanks a lot


Thanks for your help


View Complete Post


More Related Resource Links

Open .txt and tiff Files on A single Form

  
hai all of u
" code for windows forms Application using C#dotnet....."
i have one folder in sytem
in that folder  no of tiff images with no of .Text files
i.e means each tiff image contain .text file
like
1.tiffimage, 1.txt
2.tiffimage,2.txt
3.tiffimage,3.text...........................n of tiff and textfiles
now i wnat ..
1)open these through open filedailogbox
2) first part of  form show "1. tiff "file and second part of form show "1.text"
like 2tiff and 2.text.....
this loop continue untill the end of tiff andtextfilee
note when i press key board "shift+enter" key i want show one by one tiff and textfile on form of two parts  

plz help me 
Shravandotnet@gmail.com

Open .txt and tiff Files on A single Form

  
hai all of u
" code for windows forms Application using C#dotnet....."
i have one folder in sytem
in that folder  no of tiff images with no of .Text files
i.e means each tiff image contain .text file
like
1.tiffimage, 1.txt
2.tiffimage,2.txt
3.tiffimage,3.text...........................n of tiff and textfiles
now i wnat ..
1)open these through open filedailogbox
2) first part of  form show "1. tiff "file and second part of form show "1.text"
like 2tiff and 2.text.....
this loop continue untill the end of tiff andtextfilee
note when i press key board "shift+enter" key i want show one by one tiff and textfile on form of two parts  

plz help me 
Shravandotnet@gmail.com

upload multiple files from a single upload button i infopath form

  

Hi all

        My Infopath form contains an image upload button . Is it possible to upload multiple files at a time from the same upload button.

 

thnxs

shabadh 


Create multiple XML files from a single query

  

Hi,

I'm using this code for creating and xml file out of a SQL2005 table:

select (select 
    *
    from ProductsInfo_ZAP p
    for xml path('PRODUCT'),TYPE, ROOT('PRODUCTS')
) for xml path(''), ROOT('STORE')


Is there a way for me to create multiple xml files, one for every row, going by the primary key column, or do I have to create a separate query for each row?

I would also wondering what is the syntax for transforming this query into a stored procedure

thanks


SQLCMD.exe does not execute files sporadically

  

I use SQLcmd.exe to execute stored procedure on a target database (SQL version:10.0.2531.0 X64). This method has always been reliable. In the recent times I have observed that a few SQL files (sporadically) when executed through sqlcmd.exe seems to have never been executed on the database but sqlcmd.exe does not print any errors.

When I run them again through sqlcmd.exe they seem to succeed, there is nothing wrong with the sql scripts. Has someone seen this issue happen? Am I missing something?

I use the following options,

SQLCMD.exe -S <> -E -d <> -i <""> -I


Regards- Muralidhar | If my response helped, please help me by marking my response as the answer and voting as appropriate...

Max files in a single WSS 3.0 Database (SBS 2008 Server - Window Internal DB)

  

This site appears to indicate that the max documents per database is 32,767 :

http://blogs.msdn.com/b/joelo/archive/2006/08/01/how-large-for-a-single-sharepoint-content-database.aspx

This seems extremely small to me. Is that an accurate number? We have a customer with 300,000 documents and about 30 users. Is this going to be too much for a single DB?


Multiple manifest files for a single feature

  
How can I include multiple manifest files in a feature using visual studio 2010? I tried adding Empty element and it comes with a single elements.xml file. If I want to add one more, it does not seem to be recognizing the new manifest file that I created. Any pointers?

unable to run report.rdlc files in single reportviwer.

  

 

I want 2 report.rdlc files to display on a single reportviewer. Here is the code file will class file. pls do help me.

 

Default.aspx.vb Page Code :

 

Protected Sub btn_genrprt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_genrprt.Click

 

 

 

 

ReportViewer1.Visible =

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

  
.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET AJAX
.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

Application Architecture in Windows Forms 2.0-Single-MDI Applications

  
Consider an MDI application like Microsoft Excel; files opened from the file system (by double-clicking) are all opened as separate child windows within the parent Excel window.7 For the first instance of an MDI application to open a new child window to display the file that was passed to the second instance of the application, the second instance must be able to communicate with the initial instance.

SharePoint document migration challenges when migrating files and folders

  
There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Combine, minify and compress JavaScript files to load ASP.NET pages faster

  
Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

  
Version 3.560 (May 15, 2009):
bullet

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.
bullet

Adjusted PocketJet printer paper feed commands
bullet

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):
bullet

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):
bullet

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):
bullet

Fixed error in Canon printer support
bullet

Fixed COM0 port selection

Version 3.556 (June 15, 2008):
bullet

Added support for Brother MW-260
bullet

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):
bullet

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers
bullet

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):
bullet

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):
bullet

Added Panasonic JT-H200PR printer support
bullet

Added Pocket Spectrum printer support
bullet

Fixed problem with WM5.0 "inverted image" problem

Conversion of text files from ANSI to UTF-8

  
reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

How to transfer files between computer and mobile device using bluetooth

  
What is Bluetooth? How can I have it on my computer?

Bluetooth wireless technology is a communication technology that allows two devices to communicate wirelessly. Most of the notebooks are nowadays equipped with bluetooth. For those notebooks or computers that don't, you can use a bluetooth dongle to add the functionality and it just costs you around $5. Although higher price range bluetooth dongles are available but it makes no sense of buying them if you just plan to connect your mobile device to the computer. Look for one that has Bluetooth v2.0 + EDR (Enhance Data Rate) supporting speeds of upto 3Mbps and with Vista support. You can easily have one of that kind in just $5.

Setting up bluetooth to work on your computer

Just Insert the bluetooth dongle in the USB.
It should get detected by your Operating System and should be ready to use. In case it is just detected as a new hardware, you need to install drivers for it that came with your bluetooth dongle (You can try Google to find the drivers).
Once drivers are installed, a bluetooth notification icon will appear in your system tray.
Right Click on it to access Settings (This may vary with your bluetooth dongle).
Make sure you have turned Discovery On (It allow others to see your computer).
Switch On the bluetooth on the mobile device.

dynamically adding sql server columns based on number of files in fileuploader

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

 

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

 

Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

Printing resource files

  

Hello,

I have some resource files for localization and would like to print them. When I try to print them in Visual Studio (with File -> Print...) the button is disabled. Does anyone know how to print them? (Without copying each into word or excel)


Thanks and regards,
Chris 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend