-
Hi, I had created a Linked Server on SQL Server 2005 to communicate with Oracle DB (8i). Using that Linked Server I can execute the SELECT, INSERT, UPADTE , DELETE queries for ORACLE DB from SQL DB side. My requirement is to update some ORCLE DB table, when some update happen on a SQL DB table. For that...
-
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...
-
pls, can some one of you tell me how to recover deleted records from related log file? nusair.
-
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 All, Any one know how to write a code for sqlclientpermission in windows application. ( exe file and database in server machine, after that i create a shortcut to client machine. when am click the shortcut, sqlclientpermission msg will appear on that machine, so how to solvethis problem). Thanks
-
Hi Nuwan, I remember that this error comes up when SQL Mail is not configured or not configured properly. SQL Mail requires an IMAP profile such as an Outlook profile to work. SQL Mail is deprecated and will be removed in a future SQL Server release. SQL Server 2005 introduces Database Mail which can...
-
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...
-
SP: http://www.hasmeer.blogspot.com/
-
Dear All, Which one is best for development, i.e Stored Procedure OR SQL Statement . Pl Consider timing & reliability. Thnaks Hasraj