Blog Home 
Scott Yokiel MOSS 2007 & .NET blog (and some bad spelling) - Tuesday, January 22, 2008

RSS 2.0 Atom 1.0 CDF  
 
Sign In
 
 Tuesday, January 22, 2008
Heres's a simple way to pass in a xml chunk that you can easiy put int  atemp table to join to.

DECLARE @X xml
SET @X = '<root><value id=''12196825'' /></root>'

SELECT List.c.value('.','int')
FROM @X.nodes('/root/value/@id') List(c)

1/22/2008 10:04:15 AM (Central Standard Time, UTC-06:00)  #    Comments [0]    |  Trackback
 Friday, January 04, 2008
I wrote a simple page to test my database on a remote server.  Since i can't connect remotly this little page lets me run sql commands via a web browser and tst the conn string.

TestDB.zip (2.46 KB)
1/4/2008 9:46:48 AM (Central Standard Time, UTC-06:00)  #    Comments [0]    |  Trackback
 Tuesday, November 13, 2007
I thought this would be useful in the future so i'm adding it...

DECLARE @LoadList as VARCHAR(MAX)
SET @LoadList = '9681549,9681554'

CREATE TABLE #LoadNumbers
(
    LoadNum int
)

DECLARE @LoadNum varchar(10), @Pos int

SET @LoadList = LTRIM(RTRIM(@LoadList))+ ','
SET @Pos = CHARINDEX(',', @LoadList, 1)

IF REPLACE(@LoadList, ',', '') <> ''
BEGIN
    WHILE @Pos > 0
    BEGIN
        SET @LoadNum = LTRIM(RTRIM(LEFT(@LoadList, @Pos - 1)))
        IF @LoadNum <> ''
        BEGIN
            INSERT INTO #LoadNumbers (LoadNum) VALUES (CAST(@LoadNum AS int)) --Use Appropriate conversion
        END
        SET @LoadList = RIGHT(@LoadList, LEN(@LoadList) - @Pos)
        SET @Pos = CHARINDEX(',', @LoadList, 1)

    END
END

SELECT * FROM #LoadNumbers

DROP TABLE #LoadNumbers

11/13/2007 9:16:20 AM (Central Standard Time, UTC-06:00)  #    Comments [0]    |  Trackback
 Saturday, October 27, 2007

So i just finished my code camp presentation and wanted to post my slide deck and any code i used to show how to start creating sharepoint webparts.  I did a little embedded web site demo, a classic web part demo and also showed a bit of smart part.  There should also be a rough script of how to go about each of these.  If you have any question please feel free to drop me an email.  Have a good one.

scott

 

Wheres the code you say?  Sorry forgot to press that silly upload button... here it is

 

Fall2007CodeCamp.zip (1.45 MB)
10/27/2007 9:43:31 AM (Central Standard Time, UTC-06:00)  #    Comments [1]    |  Trackback
 Wednesday, August 22, 2007

Here are two links for simple ways to access XP resources via the run command.

http://erik.thauvin.net/wiki/display/Tips/XP+Run+Commands

Here is the content in case the above link disappears.
Here is a list of commands you can execute from the Run command prompt in XP:

Accessibility Controls

access.cpl

Add Hardware Wizard

hdwwiz.cpl

Add/Remove Programs

appwiz.cpl

Administrative Tools

certmgr.msc

Character Map

charmap

Check Disk Utility

chkdsk

Clipboard Viewer

clipbrd

Command Prompt

cmd

Component Services

dcomcnfg

Computer Management

compmgmt.msc

Date and Time Properties

timedate.cpl

DDE Shares

ddeshare

Device Manager

devmgmt.msc

Direct X Control Panel (If Installed)

directx.cpl

Direct X Troubleshooter

dxdiag

Disk Cleanup Utility

cleanmgr

Disk Defragment

dfrg.msc

Disk Management

diskmgmt.msc

Disk Partition Manager

diskpart

Display Properties

control desktop

Display Properties

desk.cpl

Display Properties (w/Appearance Tab Preselected)

control color

Dr. Watson System Troubleshooting Utility

drwtsn32

Driver Verifier Utility

verifier

Event Viewer

eventvwr.msc

File Signature Verification Tool

sigverif

Findfast

findfast.cpl

Folders Properties

control folders

Fonts

control fonts

Fonts Folder

fonts

Free Cell Card Game

freecell

Game Controllers

joy.cpl

Group Policy Editor (XP Prof)

gpedit.msc

Hearts Card Game

mshearts

Iexpress Wizard

iexpress

Indexing Service

ciadv.msc

Internet Properties

inetcpl.cpl

IP Configuration (Display Connection Configuration)

ipconfig /all

IP Configuration (Display DNS Cache Contents)

ipconfig /displaydns

IP Configuration (Delete DNS Cache Contents)

ipconfig /flushdns

IP Configuration (Release All Connections)

ipconfig /release

IP Configuration (Renew All Connections)

ipconfig /renew

IP Configuration (Refreshes DHCP & Re-Registers DNS)

ipconfig /registerdns

IP Configuration (Display DHCP Class ID)

ipconfig /showclassid

IP Configuration (Modifies DHCP Class ID)

ipconfig /setclassid

Java Control Panel (If Installed)

javaws

Keyboard Properties

control keyboard

Local Security Settings

secpol.msc

Local Users and Groups

lusrmgr.msc

Logs You Out Of Windows

logoff

Microsoft Chat

winchat

Minesweeper Game

winmine

Mouse Properties

control mouse

Mouse Properties

main.cpl

Netstat

netstat 

Network Connections

control netconnections

Network Connections

ncpa.cpl

Network Setup Wizard

netsetup.cpl

Notepad

notepad

Nview Desktop Manager (If Installed)

nvtuicpl.cpl

Object Packager

packager

ODBC Data Source Administrator

odbccp32.cpl

On Screen Keyboard

osk

Opens AC3 Filter (If Installed)

ac3filter.cpl

Password Properties

password.cpl

Performance Monitor

perfmon.msc

Performance Monitor

perfmon

Phone and Modem Options

telephon.cpl

Power Configuration

powercfg.cpl

Printers and Faxes

control printers

Printers Folder

printers

Private Character Editor

eudcedit

Quicktime (If Installed)

QuickTime.cpl

Regional Settings

intl.cpl

Registry Editor

regedit

Remote Desktop

mstsc

Removable Storage

ntmsmgr.msc

Removable Storage Operator Requests

ntmsoprq.msc

Resultant Set of Policy (XP Prof)

rsop.msc

Scanners and Cameras

sticpl.cpl

Scheduled Tasks

control schedtasks

Security Center

wscui.cpl

Services

services.msc

Shared Folders

fsmgmt.msc

Shuts Down Windows

shutdown

Sounds and Audio

mmsys.cpl

Spider Solitare Card Game

spider

SQL Client Configuration

cliconfg

System Configuration Editor

sysedit

System Configuration Utility

msconfig

System File Checker Utility (Scan Immediately)

sfc /scannow

System File Checker Utility (Scan Once At Next Boot)

sfc /scanonce

System File Checker Utility (Scan On Every Boot)

sfc /scanboot

System File Checker Utility (Return to Default Setting)

sfc /revert

System File Checker Utility (Purge File Cache)

sfc /purgecache

System File Checker Utility (Set Cache Size to size x)

sfc /cachesize=x

System Properties

sysdm.cpl

Task Manager

taskmgr

Telnet Client

telnet

Traceroute 

tracert <hostname or IP>

User Account Management

nusrmgr.cpl

Utility Manager

utilman

Windows Firewall

firewall.cpl

Windows Magnifier

magnify

Windows Management Infrastructure

wmimgmt.msc

Windows System Security Tool

syskey

Windows Update Launches

wupdmgr

Windows XP Tour Wizard

tourstart

Wordpad

write
 
 
Another good link is here....

http://www.ss64.com/nt/

8/22/2007 8:25:12 AM (Central Standard Time, UTC-06:00)  #    Comments [0]    |  Trackback
Copyright © 2008 RBA Consulting.