programmabilities

Getting .dll into Registry

noreply@blogger.com (Programmabilities.com) — Tue, 19 Jun 2007 17:56:57 PDT

Download the file (MSRDO20.zip) to your desktop Unzip the content of the file (a file called MSRDO20.DLL) to your desktop Right now you should have a new file called MSRDO20.DLL that resides on...

programmabilities.com ASP code

To export DTS package, do the following:

noreply@blogger.com (Programmabilities.com) — Wed, 18 Jul 2007 08:17:02 PDT

Open MS SQL Server Enterprise Manager Go to Local Packages Open some DTS Package In the DTS Package window from menu select item Package->Save As... In the Save DTS Package dialog in the Location...

programmabilities.com ASP code

Debug sproc in VS

noreply@blogger.com (Programmabilities.com) — Fri, 20 Jul 2007 07:39:21 PDT

In VS at the Sever Explorer pane I right-click on my data connection that I added and select Modify Connection. Then in the Modify Connection dialog I clicked Advanced... and then in the Advanced...

programmabilities.com ASP code

SQL: Bulk import

noreply@blogger.com (Programmabilities.com) — Mon, 03 Sep 2007 11:43:46 PDT

Bulk import (save file.txt as csv): LOAD DATA INFILE 'file.txt' INTO TABLE 'tblFoo' (col1, col2, col3) or BULK LOAD IMPORT ('c:\file.txt') INTO TABLE 'tblFoo' (col1, col2, col3)

programmabilities.com ASP code

Excel: compare two Worksheets

noreply@blogger.com (Programmabilities.com) — Fri, 12 Oct 2007 08:57:38 PDT

Excel Macro http://exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html Compares the 2 Worksheets and pops up a workbook with the differences: Steps: >Tools > Macro...

programmabilities.com ASP code

How to get a DB and send it....

noreply@blogger.com (Programmabilities.com) — Fri, 23 Nov 2007 19:55:07 PST

You can backup the DB from the server and then restore it on your local machine with installed MS SQL Server 2000. Then you can change or delete any pruned info from the DB on your local machine....

programmabilities.com ASP code

Create SSIS to copy tables

noreply@blogger.com (Programmabilities.com) — Fri, 07 Mar 2008 10:02:03 PST

An SSIS to copy tables from a Source to a Destination. Directions: From Start, select SQL Server Business Intelligence Development Studio File New Project… Project types:...

programmabilities.com ASP code

CASE: This way (3) NULLs get put in tbl if data is blank.

noreply@blogger.com (Programmabilities.com) — Fri, 07 Mar 2008 10:10:48 PST

command = New SqlCommand("INSERT INTO tblFoo (UIAcctNum, WorkZip, CheckRouteDesc, Agency, Division, RUN, Rpt_Unit_RUNDesc, StartDate,EndDate ,CheckRouteCode, Rpt_Unit_RUNDesc__old,NAICS) " & _ "...

programmabilities.com ASP code

Server 2000: Query Analyzer Tips & Tricks

noreply@blogger.com (Programmabilities.com) — Fri, 28 Mar 2008 18:31:34 PDT

You probably know that SQL Server stores metadata about all of the objects in a database. The system tables contain a wealth of information about column names, data types, identity seeds, and so on....

programmabilities.com ASP code

ReplaceCommasWithPipes.vbs

noreply@blogger.com (Programmabilities.com) — Fri, 18 Apr 2008 09:27:02 PDT

' Currently this VBScript is set to replace-commas-with-pipes for every file that is 'in the folder where this VBScript sits: ' Before run it do the following: ' 1. Open VBScript in text editor ' 2....

programmabilities.com ASP code

SSIS > VS Export wizard: table to Excel

noreply@blogger.com (Programmabilities.com) — Mon, 21 Apr 2008 18:24:49 PDT

After using the SSIS > VS Export wizard for table to Excel, you must add DROP TABLE Query to the Event Handlers tab or else it will error the second time it is reRun. SSIS > VS Import wizard for...

programmabilities.com ASP code

SQL Server 2005 Reports: tips

noreply@blogger.com (Programmabilities.com) — Mon, 23 Jun 2008 11:32:03 PDT

SSRS: Page Header: TextBox via Expression...: =Globals.ReportFolder & Globals.ReportName Page Footer: Page Footer: TextBox via Expression...: =Format(Globals!PageNumber) & " of " &...

programmabilities.com ASP code

Model View Controller

noreply@blogger.com (Programmabilities.com) — Thu, 03 Jul 2008 06:32:40 PDT

Primary goal is to separate the things that change from the things that do not. Model is the data representation. View is the presentation of the model. Controller responds to events and modifies the...

programmabilities.com ASP code

ASP .NET set focus to a control (javascript)

noreply@blogger.com (Programmabilities.com) — Fri, 11 Jul 2008 14:18:21 PDT

body onload="javascript:document.forms[0].txtFirst.focus();"

programmabilities.com ASP code

ASP confirm

noreply@blogger.com (Programmabilities.com) — Fri, 11 Jul 2008 14:23:04 PDT

gt-a-s-p:button id="ConfirmOnClick" runat="server" onclientclick="return confirm('You\'re sure you want to do this?');" text="Launch Airstrike"> lt/ a-s-p:button>

programmabilities.com ASP code

VB: Regular Expressions, etc...

noreply@blogger.com (Programmabilities.com) — Fri, 11 Jul 2008 14:48:43 PDT

Regex.IsMatch("subject", "regex") ' Checks if the regular expression ' matches the subject string. VB: using Controls collection ' Clears textbox controls' content on the form using ' Controls...

programmabilities.com ASP code

Search Stored Procedures

noreply@blogger.com (Programmabilities.com) — Tue, 15 Jul 2008 12:29:25 PDT

This searches all the Stored Procedures in 1 SQL Server database for the said string. I tested it in Query Analyzer and it found all the Stored Procedures that had occurrences of my "lq_Campaign" in...

programmabilities.com ASP code

Visual Studio Short-cuts

noreply@blogger.com (Programmabilities.com) — Fri, 05 Sep 2008 13:51:36 PDT

Most of the time, you will Step Into or Step Over commands in your stored procedures. The commands below apply to a single T-SQL line: Step Into (F11): Use to single step through your code. (Move...

programmabilities.com ASP code

SQL compare two tables

noreply@blogger.com (Programmabilities.com) — Mon, 08 Sep 2008 13:00:40 PDT

Difference in data stored in both tables (compare the difference between two tables)? You can use SQL to see rows which don't have a match in one table or the other: Select col_a,col_b from...

programmabilities.com ASP code

missing-menu-options-in-visual-studio-2005

noreply@blogger.com (Programmabilities.com) — Thu, 11 Sep 2008 09:33:55 PDT

http://blogs.vertigo.com/personal/keithc/Blog/archive/2007/07/20/missing-menu-options-in-visual-studio-2005.aspx

programmabilities.com ASP code

"Wireless-n pci Adaptor."

noreply@blogger.com (Programmabilities.com) — Mon, 15 Sep 2008 16:54:51 PDT

"Wireless-n pci Adaptor." Rangework 4X Speedwork 12X Model no WMP300N Made by Linksys

programmabilities.com ASP code

IIS hosting

noreply@blogger.com (Programmabilities.com) — Sun, 12 Oct 2008 01:59:06 PDT

TODO: From a PC use the Windows Professional's IIS to host an .aspx page that uses SQL Server Express 2005. boutell.com/newfaq/creating/hostmyown.html Include some notes & directions...

programmabilities.com ASP code

Remove phone's SIM lock online:

noreply@blogger.com (Programmabilities.com) — Thu, 01 Jan 2009 07:39:52 PST

http://simlock.gsmservice.pl Sellect-box choice: "Motorola W315" "USA / T-Mobile" Then type into the phone: *#06# IMEI: [then enter this into website] Put check in...

programmabilities.com ASP code

SQL notes

noreply@blogger.com (Programmabilities.com) — Mon, 05 Jan 2009 07:12:30 PST

SELECT * FROM ES202_RUN_LKP WHERE EndDate BETWEEN CAST('01/01/2005' AS DATETIME) AND CAST('01/11/2008' AS DATETIME) SELECT DISTINCT * INTO ##temp3 from ##temp2 --Use this if I want to INSERT rows...

programmabilities.com ASP code

check for DbNull

noreply@blogger.com (Programmabilities.com) — Mon, 05 Jan 2009 07:34:57 PST

Check for DbNull: ' /> or I am telling ASP to give the picture a height value only if the value in the database is not NULL. I could've done this in the SQL instruction, but I decided to do it...

programmabilities.com ASP code

Madskristensen.dk [del.icio.us]

programmabilities — Sat, 30 Dec 2006 18:08:08 PST

PetesBloggerama [del.icio.us]

programmabilities — Thu, 24 Aug 2006 14:41:45 PDT

asp.net/scottgu [del.icio.us]

programmabilities — Fri, 28 Jul 2006 11:42:04 PDT

ScottOnWriting.net [del.icio.us]

programmabilities — Wed, 19 Jul 2006 17:46:26 PDT

Blogoscoped [del.icio.us]

programmabilities — Wed, 16 Feb 2005 10:21:39 PST

Philip.Greenspun [del.icio.us]

programmabilities — Sun, 30 Jan 2005 21:08:50 PST

Programmabilities.com [del.icio.us]

programmabilities — Fri, 07 Jan 2005 12:12:04 PST

Programmabilities Blog [del.icio.us]

programmabilities — Thu, 06 Jan 2005 15:51:28 PST