Inserting data into a vargraphic data type field
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES(‘TEST’) This gives a SQL error Please let me know how I can acheive it.
Answer Question
| May 4, 2005 9:44 AM
Application software, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, Development, Hardware, Help Desk, IT architecture, Migration, Modeling, Operating system platforms, Services, Tech support, Third-party services, UDB for iSeries/i5, Vendor support
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES(‘TEST’) This gives a SQL error Please let me know how I can acheive it.
Answer Question
| May 4, 2005 9:44 AM
Application software, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, Development, Hardware, Help Desk, IT architecture, Migration, Modeling, Operating system platforms, Services, Tech support, Third-party services, UDB for iSeries/i5, Vendor support
Reference book for JCL
What is the best reference book for JCL ?
Answer Question
| May 5, 2011 6:14 AM
DB2 Implementation
What is the best reference book for JCL ?
Answer Question
| May 5, 2011 6:14 AM
DB2 Implementation
Locate databases on an AS400
Greetings. I recently “inherited” an AS400 model 720 after another staff member left. I’m a “newbie” with this system, but have been tasked to find the active DB2 databases still in use on the system. I can check my BRMS logs and see which libraries have changed from day to day, but I am unsure [...]
Answer Question
| April 25, 2005 3:45 PM
Database, DB2, Oracle, Tech support
Greetings. I recently “inherited” an AS400 model 720 after another staff member left. I’m a “newbie” with this system, but have been tasked to find the active DB2 databases still in use on the system. I can check my BRMS logs and see which libraries have changed from day to day, but I am unsure [...]
Answer Question
| April 25, 2005 3:45 PM
Database, DB2, Oracle, Tech support
Is Windows security an afterthought?
As the editor of SearchWindowsSecurity.com, I often speak with users about their Windows security responsibilities. One senior systems analyst in particular sent me an interesting note recently… To give you some background, he’s in charge of configuring and administering desktop systems (primarily Win2000 and XP)for a large company, and he developed many of the security [...]
Answer Question
| April 21, 2005 3:00 PM
Administration, Application security, Architecture/Design, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, IDS/IPS management, Incident response, Installation, Instant Messaging, Intrusion management, Managed security services, Management, Network security, patching, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Remote users, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, Security tokens, Service and support, Signature updating/Management, Single sign-on, Spam, Spyware, Trojans, Viruses, VPN, Vulnerability Assessment & Audit, vulnerability management, Wireless, worms
As the editor of SearchWindowsSecurity.com, I often speak with users about their Windows security responsibilities. One senior systems analyst in particular sent me an interesting note recently… To give you some background, he’s in charge of configuring and administering desktop systems (primarily Win2000 and XP)for a large company, and he developed many of the security [...]
Answer Question
| April 21, 2005 3:00 PM
Administration, Application security, Architecture/Design, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, IDS/IPS management, Incident response, Installation, Instant Messaging, Intrusion management, Managed security services, Management, Network security, patching, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Remote users, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, Security tokens, Service and support, Signature updating/Management, Single sign-on, Spam, Spyware, Trojans, Viruses, VPN, Vulnerability Assessment & Audit, vulnerability management, Wireless, worms
Service.exe Process
I have a w2k pro computer that is experiencing an incredible slowness, when I check the runing processes, I find service.exe is eating up over 90% of the cpu, starving out any other application/process. Has anybody come accross this problem and knows how to fix it? any suggestion would be appreciated. thanks.
Answer Question
| June 8, 2005 1:02 PM
Application security, Database, DataCenter, Development, Encryption, Exchange, Incident response, Instant Messaging, Secure Coding, Security, Vulnerability Assessment & Audit
I have a w2k pro computer that is experiencing an incredible slowness, when I check the runing processes, I find service.exe is eating up over 90% of the cpu, starving out any other application/process. Has anybody come accross this problem and knows how to fix it? any suggestion would be appreciated. thanks.
Answer Question
| June 8, 2005 1:02 PM
Application security, Database, DataCenter, Development, Encryption, Exchange, Incident response, Instant Messaging, Secure Coding, Security, Vulnerability Assessment & Audit
Internet Explorer vs. Firefox
Hello, I’m the Assistant Editor on SearchWindowsSecurity.com. I’m looking to start a discussion about what browser people are using and why. Also, is anyone considering switching from IE to Firefox, or are your plans to stay with IE? Here’s some food for thought… As of Feb. 2005, an estimated 35 million users had switched from [...]
Answer Question
| June 29, 2012 2:14 PM
Addamark, Administration, Aladdin Knowledge Systems, Application security, AppSec, Architecture/Design, ArcSight, Bindview, Biometrics, Caymas, CipherTrust, Compliance, Computer Associates, configuration, Courion, CRM, Cylant, Database, DataCenter, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Documentation, e-Security, Emerging technologies, Encryption, Enterasys Networks, Entrust, Exchange, Features/Functionality, GuardedNet, Hardware, Host-based IDS/IPS, IBM/Tivoli, Identity & Access Management, IDS vs IPS, IDS/IPS management, Imprivata, Installation, Instant Messaging, Intellitactics, Internet Security Systems, Intrusion management, Juniper Networks, KavaDo, M-Tech, Magnifire, Managed security services, Management, Maxware, Microsoft Windows, Netegrity, NetForensics, NetIQ, Network Associates, Network-based IDS/IPS, NFR Security, NGS Software, Novell, Ounce Labs, Outsourcing, Outsourcing/Managed services, Passlogix, patching, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Risk management, RSA Security, Sana Security, Secure Coding, Security, Security management, Security Program Management, Security tokens, Servers, Service and support, Service contracts, Service evaluation, Single sign-on, Snort/Sourcefire, SPI Dynamics, StillSecure, Tech support, Teros, Thor, Tripwire, TruSecure, Vendors, VeriSign, VPN, VSecure, Vulnerability Assessment & Audit, vulnerability management, Watchfire, Waveset/Sun Micro, Windows, Windows XP
Hello, I’m the Assistant Editor on SearchWindowsSecurity.com. I’m looking to start a discussion about what browser people are using and why. Also, is anyone considering switching from IE to Firefox, or are your plans to stay with IE? Here’s some food for thought… As of Feb. 2005, an estimated 35 million users had switched from [...]
Answer Question
| June 29, 2012 2:14 PM
Addamark, Administration, Aladdin Knowledge Systems, Application security, AppSec, Architecture/Design, ArcSight, Bindview, Biometrics, Caymas, CipherTrust, Compliance, Computer Associates, configuration, Courion, CRM, Cylant, Database, DataCenter, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Documentation, e-Security, Emerging technologies, Encryption, Enterasys Networks, Entrust, Exchange, Features/Functionality, GuardedNet, Hardware, Host-based IDS/IPS, IBM/Tivoli, Identity & Access Management, IDS vs IPS, IDS/IPS management, Imprivata, Installation, Instant Messaging, Intellitactics, Internet Security Systems, Intrusion management, Juniper Networks, KavaDo, M-Tech, Magnifire, Managed security services, Management, Maxware, Microsoft Windows, Netegrity, NetForensics, NetIQ, Network Associates, Network-based IDS/IPS, NFR Security, NGS Software, Novell, Ounce Labs, Outsourcing, Outsourcing/Managed services, Passlogix, patching, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Risk management, RSA Security, Sana Security, Secure Coding, Security, Security management, Security Program Management, Security tokens, Servers, Service and support, Service contracts, Service evaluation, Single sign-on, Snort/Sourcefire, SPI Dynamics, StillSecure, Tech support, Teros, Thor, Tripwire, TruSecure, Vendors, VeriSign, VPN, VSecure, Vulnerability Assessment & Audit, vulnerability management, Watchfire, Waveset/Sun Micro, Windows, Windows XP
Removing spaces between two words in SQL
Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname ‘space’ lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function “substring” but since the firstname can be of VARIABLE length, I do not know [...]
Answer Question
| April 26, 2005 4:40 PM
DataCenter, MySQL, Oracle, SQL Server
Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname ‘space’ lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function “substring” but since the firstname can be of VARIABLE length, I do not know [...]
Answer Question
| April 26, 2005 4:40 PM
DataCenter, MySQL, Oracle, SQL Server
- DB2 – RPG
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
Database Admin.
I’m currently in my 6th qutr. at ITT tech studying cns i’m interested in database admin. what skills or cert. will I need to get an entry level job? Where can I obtain such skills?
Answer Question
| April 13, 2005 9:08 PM
Database, DataCenter, DB2, Oracle
I’m currently in my 6th qutr. at ITT tech studying cns i’m interested in database admin. what skills or cert. will I need to get an entry level job? Where can I obtain such skills?
Answer Question
| April 13, 2005 9:08 PM
Database, DataCenter, DB2, Oracle
Safe user sandbox?
*This question is from a SearchWindowsSecurity.com reader: I’m in a position to redesign our IT systems (network, servers, PCs, software, etc.) this summer, and I am undecided on which path to take. I’d like to disconnect our systems from the Internet so that we don’t have to deal with all of the garbage that comes [...]
Answer Question
| April 13, 2005 2:15 PM
Application security, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Hacking, human factors, Identity & Access Management, Instant Messaging, Intrusion management, Management, patching, PEN testing, Platform Security, Policies, Product evaluation, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Vendors, Viruses, vulnerability management, worms
*This question is from a SearchWindowsSecurity.com reader: I’m in a position to redesign our IT systems (network, servers, PCs, software, etc.) this summer, and I am undecided on which path to take. I’d like to disconnect our systems from the Internet so that we don’t have to deal with all of the garbage that comes [...]
Answer Question
| April 13, 2005 2:15 PM
Application security, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Hacking, human factors, Identity & Access Management, Instant Messaging, Intrusion management, Management, patching, PEN testing, Platform Security, Policies, Product evaluation, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Vendors, Viruses, vulnerability management, worms
I’ve been hacked — I think….
I’m an IT administrator with a little over 500 end users, running Windows 2000 and XP. One of our users is experiencing a problem with her Internet connection suddenly dropping for no apparent reason. When she restarts her computer, everything works fine for awhile, but then the connection drops again. The funny thing is, she’s [...]
Answer Question
| August 2, 2009 9:52 AM
Administration, Application security, Architecture/Design, Bigfix, Biometrics, Cisco, Citadel, Compliance, Computer Associates, configuration, Configuresoft, CRM, Cylant, Database, DataCenter, Desktop antivirus, Desktop management applications, Digital certificates, Disaster Recovery, Documentation, Ecora, Encryption, Enterasys Networks, Exchange, Features/Functionality, Firewalls, Forensics, GFI, Hewlett-Packard, Host-based IDS/IPS, Identity & Access Management, IDS vs IPS, IDS/IPS management, Incident response, Installation, Instant Messaging, Internet Security Systems, Intrusion management, Juniper Networks, Managed security services, Management, Microsoft Windows, Network Associates, Network Elements, Network security, Network-based IDS/IPS, NFR Security, Outsourcing, Outsourcing/Managed services, patching, Patchlink, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Redundancy, Risk management, Sana Security, Secure Coding, Security, Security Program Management, Security tokens, Service and support, Service contracts, Service evaluation, Shavlink Technologies, Single sign-on, Snort/Sourcefire, St. Bernard Software, StillSecure, Symantec, Tripwire, Vendors, VPN, VSecure, Vulnerability Assessment & Audit, vulnerability management, Wireless
I’m an IT administrator with a little over 500 end users, running Windows 2000 and XP. One of our users is experiencing a problem with her Internet connection suddenly dropping for no apparent reason. When she restarts her computer, everything works fine for awhile, but then the connection drops again. The funny thing is, she’s [...]
Answer Question
| August 2, 2009 9:52 AM
Administration, Application security, Architecture/Design, Bigfix, Biometrics, Cisco, Citadel, Compliance, Computer Associates, configuration, Configuresoft, CRM, Cylant, Database, DataCenter, Desktop antivirus, Desktop management applications, Digital certificates, Disaster Recovery, Documentation, Ecora, Encryption, Enterasys Networks, Exchange, Features/Functionality, Firewalls, Forensics, GFI, Hewlett-Packard, Host-based IDS/IPS, Identity & Access Management, IDS vs IPS, IDS/IPS management, Incident response, Installation, Instant Messaging, Internet Security Systems, Intrusion management, Juniper Networks, Managed security services, Management, Microsoft Windows, Network Associates, Network Elements, Network security, Network-based IDS/IPS, NFR Security, Outsourcing, Outsourcing/Managed services, patching, Patchlink, PEN testing, Platform Security, Policies, Product evaluation, Product/Service evaluation, provisioning, Redundancy, Risk management, Sana Security, Secure Coding, Security, Security Program Management, Security tokens, Service and support, Service contracts, Service evaluation, Shavlink Technologies, Single sign-on, Snort/Sourcefire, St. Bernard Software, StillSecure, Symantec, Tripwire, Vendors, VPN, VSecure, Vulnerability Assessment & Audit, vulnerability management, Wireless
How did I get a virus on my computer?
Do you hear that question or something similar too often? We’re taking an informal survery on SearchSecurity.com to find out what the most common security-related user questions are. Results will be compiled into a question and answer tip that you will be able to post or handout to your users. What are the top 5 [...]
Answer Question
| April 15, 2005 6:07 PM
Administration, Application security, Architecture/Design, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, IDS/IPS management, Incident response, Installation, Instant Messaging, Intrusion management, Managed security services, Management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Service and support, Service contracts, Service evaluation, Signature updating/Management, Single sign-on, Spyware, Trojans, Viruses, VPN, Vulnerability Assessment & Audit, vulnerability management, Wireless, worms
Do you hear that question or something similar too often? We’re taking an informal survery on SearchSecurity.com to find out what the most common security-related user questions are. Results will be compiled into a question and answer tip that you will be able to post or handout to your users. What are the top 5 [...]
Answer Question
| April 15, 2005 6:07 PM
Administration, Application security, Architecture/Design, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, IDS/IPS management, Incident response, Installation, Instant Messaging, Intrusion management, Managed security services, Management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Service and support, Service contracts, Service evaluation, Signature updating/Management, Single sign-on, Spyware, Trojans, Viruses, VPN, Vulnerability Assessment & Audit, vulnerability management, Wireless, worms
Exchange 2000 issues
I seem to have 2 issues. Both are on the same setup. Windows 2000 Server running Exchange 2000. Both have all the latest patches and SP’s. 1) Mail will flow inbound just fine. Some mail will flow outbound just fine. Certian addy’s just have in the SMTP queue ( AOL,Yahoo, Bellsouth ). Other mail going [...]
Answer Question
| April 7, 2005 12:29 PM
Active Directory, Administration, Application management, Cabling, Client management, Database issues, DHCP, Dial-up networking, DNS, E-mail applications, Exchange, Exchange 2000, Exchange Server ActiveSync, Features/Functionality, Help Desk, HTTP, Hubs, Installation, Mail protocols, Maintenance, Microsoft Windows, Modems/Cable Modems, Network applications management, Network Interface Cards, Network Management Systems, Network monitoring, Network testing, Networking, Networking Equipment, Networking services, Norton, Outlook, Outlook Mobile Access, Performance management, POP3, Remote management, Routers, Security, Service and support, SMTP, Storage, Storage management, Switches, Symantec, TCP, Tech support, Third-party services, Vendor support, Vendors, WINS, Yahoo
I seem to have 2 issues. Both are on the same setup. Windows 2000 Server running Exchange 2000. Both have all the latest patches and SP’s. 1) Mail will flow inbound just fine. Some mail will flow outbound just fine. Certian addy’s just have in the SMTP queue ( AOL,Yahoo, Bellsouth ). Other mail going [...]
Answer Question
| April 7, 2005 12:29 PM
Active Directory, Administration, Application management, Cabling, Client management, Database issues, DHCP, Dial-up networking, DNS, E-mail applications, Exchange, Exchange 2000, Exchange Server ActiveSync, Features/Functionality, Help Desk, HTTP, Hubs, Installation, Mail protocols, Maintenance, Microsoft Windows, Modems/Cable Modems, Network applications management, Network Interface Cards, Network Management Systems, Network monitoring, Network testing, Networking, Networking Equipment, Networking services, Norton, Outlook, Outlook Mobile Access, Performance management, POP3, Remote management, Routers, Security, Service and support, SMTP, Storage, Storage management, Switches, Symantec, TCP, Tech support, Third-party services, Vendor support, Vendors, WINS, Yahoo
Importing Data in SQL Server 2000. “Integrity violation error” in RowID column
Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the Enterprise Manager. The textfile [...]
Answer Question
| April 8, 2005 7:18 PM
Database Management Systems, MySQL, Oracle
Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the Enterprise Manager. The textfile [...]
Answer Question
| April 8, 2005 7:18 PM
Database Management Systems, MySQL, Oracle
sqlserver 2000 stored procedures
Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy
Answer Question
| April 4, 2005 10:02 AM
ColdFusion, MySQL, SQL, SQL Server
Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy
Answer Question
| April 4, 2005 10:02 AM
ColdFusion, MySQL, SQL, SQL Server
Loading CSV files into Oracle tables
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]
Answer Question
| April 19, 2013 11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]
Answer Question
| April 19, 2013 11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
REPORT WAIT TIMES
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the [...]
Answer Question
| March 31, 2005 10:28 AM
Microsoft Access, SQL Server
Help with VBA Code for retrieving data from a table in an MS Access Database
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]
Answer Question
| March 30, 2005 12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]
Answer Question
| March 30, 2005 12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]
Answer Question
| March 24, 2005 10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]
Answer Question
| March 24, 2005 10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
Free online practice exercises on SQL/Oracle
I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti
Answer Question
| April 17, 2013 9:47 AM
MySQL, Oracle, SQL Server
I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti
Answer Question
| April 17, 2013 9:47 AM
MySQL, Oracle, SQL Server
