No announcements
Found 4094660 threads
-
0 Votescan't call SQL function from DAAB (SqlHelper)
The only problem with SQLHelper for UDFs is that it is not as flexible as it is with StoredProcedures. i.e. for stored procedures you can change the number of parameters without ...Answered | 3 Replies | 8807 Views | Created by Mike Otten - Sunday, June 1, 2008 9:08 PM | Last reply by Michael Nady - Monday, September 7, 2009 1:00 PM
-
0 Votes
how to put Transaction function if I use sqlHelper
User-635215137 posted Hi: I am using sqlHelper to communicate with database, very handy.Unanswered | 1 Replies | 44 Views | Created by Anonymous - Thursday, March 19, 2009 6:34 PM | Last reply by Anonymous - Friday, March 20, 2009 3:57 AM -
3 Votes
Using transaction in multiple functions
Cor, I didn't use transactions together with databases accessed by .NET, but I think it's pretty clear that there may be cases in which nesting ...Answered | 6 Replies | 4546 Views | Created by iCreator - Monday, May 24, 2010 11:40 AM | Last reply by Herfried K. Wagner - Thursday, May 27, 2010 12:33 AM -
0 Votes
About sqlhelper Class
Hello, I found some links about SQLhelper ...Answered | 1 Replies | 14044 Views | Created by Ramdas Mutkule - Monday, March 19, 2012 11:25 AM | Last reply by Papy Normand - Tuesday, March 20, 2012 6:52 PM -
3 Votes
May i use SqlHelper class in c# if oracle as a database.?
SQLHelper is only for SQL Server.Answered | 2 Replies | 2739 Views | Created by Sesuraj - Friday, February 14, 2014 4:28 AM | Last reply by Satheesh Variath - Friday, February 14, 2014 5:01 AM -
0 Votes
Finding decent SqlHelper class?
Hello, Using parameters may feel impractical but do the following (a few thoughts) Stongly type data for valuesDeals with apostrophes embedded ...Answered | 2 Replies | 2383 Views | Created by rbhatup - Monday, March 10, 2014 7:46 PM | Last reply by davidbaxterbrowne - Monday, March 10, 2014 9:56 PM -
0 Votes
How to use transaction in SSIS?
Here is a SSIS Transaction example: http://microsoft-ssis.blogspot.com/2011/01/ssis-transactions.htmlAnswered | 3 Replies | 3770 Views | Created by Winds Gao - Saturday, October 8, 2011 7:16 AM | Last reply by Zaim Raza - Sunday, October 9, 2011 11:24 AM -
2 Votes
How to use sql transactions
I meant one could ask for some code because he can't write to a file.Answered | 5 Replies | 2078 Views | Created by Er. Varinder - Monday, August 22, 2011 11:38 AM | Last reply by Er. Varinder - Saturday, August 27, 2011 4:57 AM -
0 Votes
How to use transaction?
If the transaction is not committed by the time it is disposed (leaves the using) then it rolls back automatically.Answered | 5 Replies | 636 Views | Created by TakeshiKitano - Monday, July 20, 2020 2:23 PM | Last reply by CoolDadTx - Monday, July 20, 2020 5:07 PM -
1 Votes
is there any way to put transactions, to find if some one is using the table.
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE https://msdn.microsoft.com/en-us/library/ms173763.aspx?Answered | 4 Replies | 657 Views | Created by rajemessage - Tuesday, November 22, 2016 3:45 PM | Last reply by Susantha Bathige - Wednesday, November 23, 2016 4:49 PM -
0 Votes
How Would I Convert EncodeDayOfWeekinMonth to Transact-SQL?
Also the calendar table is very useful for other datetime related queries.Answered | 3 Replies | 691 Views | Created by Debbie Erickson - Monday, October 19, 2015 3:23 PM | Last reply by Jingyang Li - Wednesday, October 21, 2015 2:12 PM -
0 Votes
how to use @@erro to rollback transactions
Something like: begin transaction; update ...Answered | 1 Replies | 5271 Views | Created by Leonardo A L Ferreira - Monday, March 2, 2009 1:39 PM | Last reply by Hunchback - Monday, March 2, 2009 1:57 PM -
1 Votes
i am not getting this collation in the out put this function .
You are using the wrong LIKE predicate: SELECT name, description FROM sys.fn_helpcollations() AS C WHERE ...Answered | 2 Replies | 868 Views | Created by rajemessage - Sunday, July 27, 2014 11:03 AM | Last reply by Kalman Toth - Sunday, July 27, 2014 12:20 PM -
0 Votes
How can use Transactions with Microsoft SqlHelper class?
I am using Microsoft SqlHelper.cs class with BLL and DAL.Answered | 1 Replies | 4664 Views | Created by Rana76 - Friday, June 29, 2012 10:54 AM | Last reply by Nair S - Friday, June 29, 2012 11:25 AM -
0 Votes
How to avoid deadlocks using locks on the transactions?
https://technet.microsoft.com/en-us/library/ms191242(v=sql.105).aspx i think in your case may be lower isolation level @ sql level may ...Answered | 2 Replies | 1097 Views | Created by Wedla Melo - Monday, September 21, 2015 6:23 PM | Last reply by UnknownisOcean - Monday, September 21, 2015 7:08 PM -
5 Votes
Using transactions
COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION SELECT @err = ERROR_NUMBER() , @err_msg=ERROR_MESSAGE() END ...Answered | 10 Replies | 5131 Views | Created by Kiwi Jonathan - Monday, June 6, 2011 9:24 PM | Last reply by Eslam Mahmoud Abd El-Zaher - Tuesday, June 14, 2011 7:58 AM -
0 Votes
HOW i can Perform Transaction rollback in SSIS ?
DFT Properties of Taransaction=Supported: Indicates that the container does not start a transaction, but joins any transaction started by its parent ...Answered | 1 Replies | 5847 Views | Created by RakeshKudumula - Thursday, May 25, 2017 4:50 AM | Last reply by Pirlo Zhang - Thursday, May 25, 2017 9:05 AM -
0 Votes
Is it possible to rollback a function using TransactionScope?
can I use it like this?Answered | 11 Replies | 3926 Views | Created by z0802361 - Thursday, September 19, 2013 4:17 AM | Last reply by z0802361 - Thursday, September 26, 2013 10:50 AM -
1 Votes
Transaction Log Re-Use ....
Hi JJKush, I am sorry that I am not express my idea clearly to you .Answered | 9 Replies | 4210 Views | Created by JJKusch - Monday, July 9, 2012 9:45 PM | Last reply by Chirag Shah - Friday, July 13, 2012 7:02 PM -
0 Votes
Using NOLOCK with in BEGIN TRANSACTION
Does NOLOCK hint work when used with in transaction?Answered | 4 Replies | 15775 Views | Created by Phaneendra Babu Subnivis - Thursday, March 4, 2010 9:32 AM | Last reply by Phaneendra Babu Subnivis - Thursday, March 4, 2010 10:56 AM - Items 1 to 20 of 4094660 Next ›
No announcements
