-
Is there are any way to get stored procedure status to .net form.? Think that sp_abc will take 10 minutes to execute. During that time it will process 100000 records using server side cursor. So is there any way to get current progress from sp ? if so we can show it using progress bar. For example if...
-
Hi all, I've tried SQL injection for a normal SQL query and it workd fine but when i tried to do the same with a Stored Procedure it's not working. The reason i found was i coundn't avoid single quoate. This is the procedure create procedure login @email varchar(50), @pwd varchar(30) as select...
-
Hi amila, Simply use t-sql DATEADD function. http://msdn.microsoft.com/en-us/library/ms186819.aspx Cheers!
-
This Link will help you.... http://www.freekingdom.yolasite.com/helping-hand.php If you get any help from that site please click one advertisement.. Thank You
-
Hi chikulanikader, Though I'm not much into MySql, I think the grave accent ( ` ) should work. Note that don't confuse this with the single quote ( ' ). Btw, you cannot use either / or \ charactors, as they are illegal in MySQL. Eg: create table `some table name` (col INT); Unfortunately...
-
hi Melick, Thank you very much, it worked for me. Now I have another problem, is there something special on INSERT statement when inserting these values, or same as varchar values....?
-
As I know; You don't have to lock tables manually, you just need to use a SqlTransaction in C# as below, SqlTransaction tran; SqlConnection con = new SqlConnection("<connectionString>"); SqlCommand com = new SqlCommand(con,""); try { tran = con.BeginTransaction(); com.Transaction...
-
please go through the picture in the first post. getting error 32 and 40.
-
please go through, i implemented some error handling to find out the occurence of error. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; // added by me using System.Data.SqlClient; namespace...
-
i was trying to connect sql db(for example master.mdf and sql express). could not get the connection suceeded. vs2005<---> sql express 2005 help me please.