Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Monday, February 22, 2010
Added Microsoft Access as linked server SQL Server
›
SQL Server > Linked Server > Add sp_addlinkedserver Creates a linked server. A linked server allows for access to distributed, ...
Thursday, February 4, 2010
First, last day of the month Oracle
›
Oracle > Date & Time > First day and last day of the month Oracle SELECT ( trunc ( sysdate , 'mm' )) first_day FR...
Tuesday, January 26, 2010
Duplicate rows SQL Server
›
SQL Server > Scripts > Duplicate rows SQL Server Here is a script to find number of duplicate rows in SQL Server IF OBJECT_ID ...
Wednesday, January 20, 2010
send fax C#
›
Send fax C# using using FAXCOMLib; public void SendFax( string DocumentName, string FileName, string RecipientName, string FaxNumbe...
Tuesday, January 19, 2010
Get windows temporary path c#
›
C# > Files > GetTempPath GetTempPath retrieves the path of the directory designated for temporary files. Order to check for the...
FRM-40654: Record has been updated by another user
›
Oracle > dml_data_target_name FRM-40654: Record has been updated by another user The case that I had was i changed the query of 1 d...
Friday, January 15, 2010
Rename Microsoft Access Table
›
VB 6 > DAO > Rename table (Used DAO 3.6 as reference.) Public Sub rentbl() Dim dbSS As Database Dim strDbName As Strin...
‹
›
Home
View web version