473,386 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

sql batches in vs.net

visual studio.net seems to default to single batch mode when running
sql scripts. does anyone know how to change this behavior? typical
batches will include object existence, drop, and create batches prior
to processing. i have attempted removing the graphical plan, using
batch separator 'go', and the vba trick using ';' to no avail.
tia
Jul 20 '05 #1
1 1517
datadev (da*****@fastmail.fm) writes:
visual studio.net seems to default to single batch mode when running
sql scripts. does anyone know how to change this behavior? typical
batches will include object existence, drop, and create batches prior
to processing. i have attempted removing the graphical plan, using
batch separator 'go', and the vba trick using ';' to no avail.


Sounds like a question for a Visual Studio newsgroup. I never use
VS to access SQL Server, so I don't have an idea.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Robin Tucker | last post by:
I have a query batch "update" script that upgrades my users database from, say version 0 to version 1, or from version 1 to version 2. I would like to know how I can wrap the entire script in a...
28
by: stu_gots | last post by:
I have been losing sleep over this puzzle, and I'm convinced my train of thought is heading in the wrong direction. It is difficult to explain my circumstances, so I will present an identical...
2
by: MLH | last post by:
This question, I apologize, is more of a math question than it is an Access question - I'm almost certain. The bell curve is another name for the normal distribution, which is a common type of...
1
by: Mark Harrison | last post by:
I can't seem to get PG into non-blocking mode. Here is the result I'm getting from the code attached below. I'm expecting to get multiple "PQntuples=" lines, but instead I'm getting just one...
3
by: John | last post by:
Hi I have a jobs table in which a client can be assigned to multiple jobs. Now I need to assign invoice numbers to jobs such that all jobs belonging to one client get the same first number, all...
3
by: shorti | last post by:
I know this subject has come up many times but I am not finding what I am looking for after a couple days of searching. I know some months ago I saw an indirect solution for this but I cant seem...
3
by: Henrik Juul | last post by:
I have the following 2 tables: (BATCHES) BatchID KEY ID OrderID Action1DateTime Action2DateTime Action3DateTime Action4DateTime
4
by: motherbee | last post by:
Hi, I'm trying to figure out a way to compare two versions of the same text file from a database and to highlight the changes when viewing the text? Can anyone help me with this?
20
by: kpfunf | last post by:
Hey all, I have a table of receipts used (Table Name: receipts, Field Name: receiptNumber) and a table with receipts issued (Table Name: Receipts Batches, Field Names: BatchID, BegRng, EndRng)....
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.