SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Try the following: UPDATE table SET field = substr(FIELD,1,3)|| replace(substr(FIELD,4,2),'15','08')|| substr(FIELD,6,4);
View Answer
| April 19, 2013 12:07 PM
Data/Application Integration, Database, DB2, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, SQL
Try the following: UPDATE table SET field = substr(FIELD,1,3)|| replace(substr(FIELD,4,2),'15','08')|| substr(FIELD,6,4);
View Answer
| April 19, 2013 12:07 PM
Data/Application Integration, Database, DB2, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, SQL
How use NTBackup command in Windows Server 2008 r2
If you have used the Windows Backup application before in other Windows Server versions, you know that it is called NTBACKUP and you can run it, using that command, from the command line. If you attempt the same command in Windows Server 2008, you will find that you get an error. This is because the [...]
View Answer
| April 19, 2013 7:53 AM
NTBackup, NTBackup Configuration, Windows Server 2008, Windows Server 2008 R2
If you have used the Windows Backup application before in other Windows Server versions, you know that it is called NTBACKUP and you can run it, using that command, from the command line. If you attempt the same command in Windows Server 2008, you will find that you get an error. This is because the [...]
View Answer
| April 19, 2013 7:53 AM
NTBackup, NTBackup Configuration, Windows Server 2008, Windows Server 2008 R2
How to redirect the start menu using Windows Server 2008 R2 & Windows 7
Many causes are creating problems….. Redirection, Start Menu and one Desktop to Windows Server 2008 file server with Access-based enumeration installed and configured. On Share u would set read and execute rights and permissions for users and Full Control rights to administrators, then create groups in Active Directory with meaningful names for Applications or groups [...]
View Answer
| April 19, 2013 5:09 AM
Windows 7 Administration, Windows 7 Professional, Windows Server 2008, Windows Server 2008 R2
Many causes are creating problems….. Redirection, Start Menu and one Desktop to Windows Server 2008 file server with Access-based enumeration installed and configured. On Share u would set read and execute rights and permissions for users and Full Control rights to administrators, then create groups in Active Directory with meaningful names for Applications or groups [...]
View Answer
| April 19, 2013 5:09 AM
Windows 7 Administration, Windows 7 Professional, Windows Server 2008, Windows Server 2008 R2
How to port forward and map IP on SonicWALL TZ 180?
Hi Ricardo, Go to the ‘Network > One-to-One NAT’ page. Check the box next to ‘Enable One-to-One NAT’, and click on the ‘Apply’ button. Click on the ‘Add…’ button. Enter the address of your server in the ‘Private Range Start:’ box. Enter the Public IP address in the ‘Public Range Start’ box. Enter ’1′ in [...]
View Answer
| April 19, 2013 7:37 AM
Firewalls, Network security, Port forwarding, SonicWALL TZ 180
Hi Ricardo, Go to the ‘Network > One-to-One NAT’ page. Check the box next to ‘Enable One-to-One NAT’, and click on the ‘Apply’ button. Click on the ‘Add…’ button. Enter the address of your server in the ‘Private Range Start:’ box. Enter the Public IP address in the ‘Public Range Start’ box. Enter ’1′ in [...]
View Answer
| April 19, 2013 7:37 AM
Firewalls, Network security, Port forwarding, SonicWALL TZ 180
Difference between ODBC and JDBC?
ODBC is for microsoft and JDBC is for Java. JBDC is portable across platforms where ODBC is not. See the following for more information: Also, a quick Google search shows 32,900 hits for “Difference between ODBC and JDBC”. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Thank you. I have seen all of those in my search already. I guess I was [...]
View Answer
| April 19, 2013 1:45 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
ODBC is for microsoft and JDBC is for Java. JBDC is portable across platforms where ODBC is not. See the following for more information: Also, a quick Google search shows 32,900 hits for “Difference between ODBC and JDBC”. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Thank you. I have seen all of those in my search already. I guess I was [...]
View Answer
| April 19, 2013 1:45 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
Count distinct rows on multiple columns
If you just wanted a count of the student IDs present, you could use COUNT(DISTINCT id). However, you want a running tally-mark. This involves sorting the file to temporary storage, then looking for changes, and putting a 1 in the slot where you have the changes: WITH sorted AS( SELECT * FROM sampleData ORDER BY [...]
View Answer
| April 19, 2013 11:35 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
If you just wanted a count of the student IDs present, you could use COUNT(DISTINCT id). However, you want a running tally-mark. This involves sorting the file to temporary storage, then looking for changes, and putting a 1 in the slot where you have the changes: WITH sorted AS( SELECT * FROM sampleData ORDER BY [...]
View Answer
| April 19, 2013 11:35 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
How does IPSec Passthrough enable packet transfer through a router?
From the description, I suspect that the router is capable of terminating a VPN itself, so by default it will intercept any VPN packets and process them. The passthrough option allows these packets to be passed through as they are ignored by the router and processed like any other packet destined for a host on [...]
View Answer
| April 19, 2013 4:02 PM
IPsec, IPsec Passthrough, IPsec VPN, Network security, Networking, VPN
From the description, I suspect that the router is capable of terminating a VPN itself, so by default it will intercept any VPN packets and process them. The passthrough option allows these packets to be passed through as they are ignored by the router and processed like any other packet destined for a host on [...]
View Answer
| April 19, 2013 4:02 PM
IPsec, IPsec Passthrough, IPsec VPN, Network security, Networking, VPN
Runtime Error 3001 – Arguments are of the wrong type or out of acceptable range or are in conflict with one another
Try replacing that line with this: Rs2.Open "Select * from bill where invoice_no<b>=" &</b> Rs1("Bill_Sno"), Cn, adOpenDynamic, adLockOptimistic
View Answer
| April 19, 2013 2:17 AM
Error 3001, Runtime Error 3001 - Arguments are of the Wrong Type or out of acceptable range or are in conflict with one another, Runtime Errors, VB 6, Visual Basic 6
Try replacing that line with this: Rs2.Open "Select * from bill where invoice_no<b>=" &</b> Rs1("Bill_Sno"), Cn, adOpenDynamic, adLockOptimistic
View Answer
| April 19, 2013 2:17 AM
Error 3001, Runtime Error 3001 - Arguments are of the Wrong Type or out of acceptable range or are in conflict with one another, Runtime Errors, VB 6, Visual Basic 6
Need to create a bootable server 2003 CD
Be sure not to use illegal copy of windows, you can download evaluation version of Windows bootable ISO from Microsoft download site. S Anand Kumar You could also risk the wrath of Microsoft and follow the instructions here to create a bootable disk. It’s pretty easy if you have Nero or a similar program, but [...]
View Answer
| April 19, 2013 3:46 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Be sure not to use illegal copy of windows, you can download evaluation version of Windows bootable ISO from Microsoft download site. S Anand Kumar You could also risk the wrath of Microsoft and follow the instructions here to create a bootable disk. It’s pretty easy if you have Nero or a similar program, but [...]
View Answer
| April 19, 2013 3:46 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Cisco IPsec VPN: VPN up but no traffic/ping
You will need to have routes across the tunnel at both ends to be able to return traffic. If you see ICMP traffic going in and nothing on the other side, then it is possible that the return route is missing. ====================== Use traceroute to find out where the connection is stopping or if the [...]
View Answer
| April 19, 2013 10:07 PM
Cisco, Cisco 871, Cisco Routers, draytek, draytek vigor 2200E+, IPsec, IPsec VPN, Routers, VPN
You will need to have routes across the tunnel at both ends to be able to return traffic. If you see ICMP traffic going in and nothing on the other side, then it is possible that the return route is missing. ====================== Use traceroute to find out where the connection is stopping or if the [...]
View Answer
| April 19, 2013 10:07 PM
Cisco, Cisco 871, Cisco Routers, draytek, draytek vigor 2200E+, IPsec, IPsec VPN, Routers, VPN
BULK COLLECT and FORALL in PL/SQL
I found the answer on my own and here is the code I wrote: -- ts_to_td.sql -- -- This script is called by Q3.sql -- and runs after the scripts: -- 1.) ts_insert_table.sql - creates the TS_INSERT_TABLE -- and its index; -- 2.) ts_update_table.sql - creates the TS_UPDATE_TABLE -- and its index. -- create or [...]
View Answer
| April 19, 2013 8:04 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL
I found the answer on my own and here is the code I wrote: -- ts_to_td.sql -- -- This script is called by Q3.sql -- and runs after the scripts: -- 1.) ts_insert_table.sql - creates the TS_INSERT_TABLE -- and its index; -- 2.) ts_update_table.sql - creates the TS_UPDATE_TABLE -- and its index. -- create or [...]
View Answer
| April 19, 2013 8:04 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL
Install SQL server client tools
Hi, you can download and install Microsoft SQL Management Studio Express for free. If you have purchased any edition of SQL Server you can use the SQL Server CD/DVD that you purchased to install the full client tools on your workstation. Simply put in the CD/DVD and run through the installer. When you get to [...]
View Answer
| April 19, 2013 9:08 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server Agent
Hi, you can download and install Microsoft SQL Management Studio Express for free. If you have purchased any edition of SQL Server you can use the SQL Server CD/DVD that you purchased to install the full client tools on your workstation. Simply put in the CD/DVD and run through the installer. When you get to [...]
View Answer
| April 19, 2013 9:08 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server Agent
How to restore a SQL Server 2000 database using a backup
You can do this via the Microsoft console (look under programs/Microsoft SQL server) or via SQL command. I suggest you using the graphical way, that’s to say: <ul> Open the management console Provide login information Right click the database that you need to restore and choose restore If the database name isn’t listed right click [...]
View Answer
| April 19, 2013 9:18 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
You can do this via the Microsoft console (look under programs/Microsoft SQL server) or via SQL command. I suggest you using the graphical way, that’s to say: <ul> Open the management console Provide login information Right click the database that you need to restore and choose restore If the database name isn’t listed right click [...]
View Answer
| April 19, 2013 9:18 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
Cannot open a .OST file in Outlook 2007
You need a OST to PST converter tool to convert offline .OST file to .PST file then you can access PST file with Outlook email client. Check out the free trial version of software. Thanks Alfa Tech
View Answer
| April 19, 2013 6:56 AM
.pst, OST, Outlook 2007
You need a OST to PST converter tool to convert offline .OST file to .PST file then you can access PST file with Outlook email client. Check out the free trial version of software. Thanks Alfa Tech
View Answer
| April 19, 2013 6:56 AM
.pst, OST, Outlook 2007
Easier way to Insert image to SharePoint
You are right, SharePoint does not support directly insert picture into Rich Text Editor. I stumble on this solution called SharePoint Rich Text Boost, which can let user insert images and Flash directly.
View Answer
| April 19, 2013 6:23 AM
SharePoint, SharePoint 2007, SharePoint 2007 insert picture, SharePoint Rich Text Editor
You are right, SharePoint does not support directly insert picture into Rich Text Editor. I stumble on this solution called SharePoint Rich Text Boost, which can let user insert images and Flash directly.
View Answer
| April 19, 2013 6:23 AM
SharePoint, SharePoint 2007, SharePoint 2007 insert picture, SharePoint Rich Text Editor
Create an add to calendar button
You already have that button in your calendar!
View Answer
| April 19, 2013 2:34 PM
Lotus Notes, Lotus Notes Calendar, Lotus notes Calendar Button
You already have that button in your calendar!
View Answer
| April 19, 2013 2:34 PM
Lotus Notes, Lotus Notes Calendar, Lotus notes Calendar Button
Command for auto reboot – Windows 7
The SHUTDOWN command does not have the capability to tell applications to save data and close. You can use “/r” for reboot which will trigger open applications to prompt to save data and not reboot if the applications remain open. Adding the “/f” will force a reboot but cause potential data loss because it forces [...]
View Answer
| April 19, 2013 7:22 PM
Reboot, Windows 7, Windows 7 Administration, Windows 7 reboot, Windows scripting
The SHUTDOWN command does not have the capability to tell applications to save data and close. You can use “/r” for reboot which will trigger open applications to prompt to save data and not reboot if the applications remain open. Adding the “/f” will force a reboot but cause potential data loss because it forces [...]
View Answer
| April 19, 2013 7:22 PM
Reboot, Windows 7, Windows 7 Administration, Windows 7 reboot, Windows scripting
Running system restore from command line on Windows Server 2003?
You can boot to safe mode with command prompt to launch the system restore gui. You have to type the following commands cd windowssystem32 cd restore rstrui.exe Select the date you want to roll back top Start your restore You can also read the post I wrote up on doing just that over here. This [...]
View Answer
| April 19, 2013 3:35 PM
Command line, System Restore, Windows Server 2003, Windows Server 2003 Backup
You can boot to safe mode with command prompt to launch the system restore gui. You have to type the following commands cd windowssystem32 cd restore rstrui.exe Select the date you want to roll back top Start your restore You can also read the post I wrote up on doing just that over here. This [...]
View Answer
| April 19, 2013 3:35 PM
Command line, System Restore, Windows Server 2003, Windows Server 2003 Backup
Multiple subnets on one physical network
If you just want to communicate with the radios, the easiest way would be to add another ip address to the network adapter that is going to your AP. You can put any number of addresses on one adapter, simulating multiple network cards sharing the same wire. To do this, you’ll have to ensure the [...]
View Answer
| April 19, 2013 5:11 AM
Access Points, Network design, Routers, Routing and switching, Routing table protocols, Subnet mask, Subnets, Switches, Wireless networks
If you just want to communicate with the radios, the easiest way would be to add another ip address to the network adapter that is going to your AP. You can put any number of addresses on one adapter, simulating multiple network cards sharing the same wire. To do this, you’ll have to ensure the [...]
View Answer
| April 19, 2013 5:11 AM
Access Points, Network design, Routers, Routing and switching, Routing table protocols, Subnet mask, Subnets, Switches, Wireless networks
Configuring VLAN’s on two HP procurve switches
You do not need to put any IP addresses on the VLAN 2 interfaces on either switch, that actually does what you don’t want and allows traffic to pass from vlan1 to vlan2, if you don’t put an IP address on vlan2 this can not happen. What you also need to do is add the [...]
View Answer
| April 19, 2013 10:26 PM
HP, HP ProCurve, Switches, VLAN, VLAN configuration
You do not need to put any IP addresses on the VLAN 2 interfaces on either switch, that actually does what you don’t want and allows traffic to pass from vlan1 to vlan2, if you don’t put an IP address on vlan2 this can not happen. What you also need to do is add the [...]
View Answer
| April 19, 2013 10:26 PM
HP, HP ProCurve, Switches, VLAN, VLAN configuration
