![]()
3 problem regarding .NET & SQL
Reply
![]() |
|
|
From:
VISHNAT
|
Hi Raghvendra
The first question is not suite clear can you provide more details , and
how have you implemented error handling in Stored procedures ? The better
practise i would suggest would be raise error in you proc and catch the
error in client.
Answering your second question
SQLServer does not have an alternate to SPOOL of oracle but the good things
is there are several ways in which you can implement the same
here are a few ways
Using XP_cmdshell and BCP
xp_cmdshell "@ECHO test >> C:\Test.abc"
or
xp_cmdshell "bcp <dbname>..<tablename> out c:\Test.abc -Usa -P<password> -c"
with BCP command also besides this BCP command can also be used read out of
a FLAT file
Use Result to Text option in QueryAnalyser (Ensure your max character in
the results tab is 8192)
There is a free utility that available at
http://www.dbmaint.com/download/util_proc/sp_dbm_query_to_file.sql would
suggest you look at it..
the Third i dont know ..
Regards
Viswanath
Viswanath
>From: "dotnetGUI" <[EMAIL PROTECTED]>
>Reply-To: "dotNET User Group Hyd" <[EMAIL PROTECTED]>
>To: "dotNET User Group Hyd" <[EMAIL PROTECTED]>
>Subject: Re: 3 problem regarding .NET & SQL
>Date: Mon, 15 Mar 2004 19:54:30 -0800
>
>-----------------------------------------------------------
>
>New Message on dotNET User Group Hyd
>
>-----------------------------------------------------------
>From: dotnetGUI
>Message 2 in Discussion
>
>
>Hi, You can save your query results to a
>file
>the only thing you have to do is press CTRL +
>SHIFT + F
>----- Original Message -----
>
> From:
> raghuwanshi
> To: dotNET User Group Hyd
>
> Sent: 15 March, 2004 7:34 AM
> Subject: 3 problem regarding NET &
> SQL
>
>
>
>
>
> New Message on dotNET User Group
> Hyd
>
>
>
> 3 problem
> regarding .NET & SQL
>
>
>
>
>
> Reply
>
>
>
>
>
>
> Reply to Sender Recommend
> Message 1 in
> Discussion
>
>
>
>
>
> From: raghuwanshi
>
>
>
> Hi Friends
>
> I am working in VB.NET. I have three problems
>
> (1) I want to get error of SQL procedure in
> VB .NET form.
>
> Let we have SQL procedure & call it from front
> hand . I want to get error of this procedure in VB. NET
> forms.
>
>
> (2) Alternet of ORACLE' SPOOL command in
> SQL SERVER
> Actually i want to store my all
> sql query result in txt file.How can do it in SQL
> Server.
>
> (3) I want to change my SYS's Display
> Properities at runtime through VB.NET.
> I made change in Registry hkey_CurrentUser\Control
>panel\Appearance
> (and Colors) Settint through VB.NET .But Still i did not
>get
> result
>
> PLZ . solve my all problem
>
> THANKS -----
> THANKS-----
>
> THANKS----
>
> Raghvendra
> 9892687036
>View other groups in this
> category.
>
>
>
>-----------------------------------------------------------
>
>To stop getting this e-mail, or change how often it arrives, go to your
>E-mail Settings.
>http://groups.msn.com/dotNETUserGroupHyd/_emailsettings.msnw
>
>Need help? If you've forgotten your password, please go to Passport Member
>Services.
>http://groups.msn.com/_passportredir.msnw?ppmprop=help
>
>For other questions or feedback, go to our Contact Us page.
>http://groups.msn.com/contact
>
>If you do not want to receive future e-mail from this MSN group, or if you
>received this message by mistake, please click the "Remove" link below. On
>the pre-addressed e-mail message that opens, simply click "Send". Your
>e-mail address will be deleted from this group's mailing list.
>mailto:[EMAIL PROTECTED]
_________________________________________________________________
Join BharatMatrimony.com.
http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?72 Unmarried? Join
Free.
|
|
View other groups in this category.
![Click here!]()
![]() |
To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.
Need help? If you've forgotten your password, please go to Passport Member Services.
For other questions or feedback, go to our Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list.
Remove my e-mail address from dotNET User Group Hyd.
|
|
