SQL Packages
I have a query on SQL packages.Is it necessary to create an SQL package every time we connect to a remote system?Is there any other alternative?

Answer Question   |  February 21, 2008  6:50 AM
SQL

Inserting multiple rows in Oracle 10g
I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific [...]

Answer Question   |  October 18, 2007  4:10 PM
INSERT statement, Oracle, SQL

Delete all data in the database
Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE if table has any foreign key references (normally refer to parent tables): Is there any suggested [...]

Answer Question   |  October 24, 2007  4:23 PM
SQL

Database Admin…
Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did… nor did I. [...]

Answer Question   |  December 20, 2007  3:37 PM
DBA, naming conventions, Performance/Tuning, Relation Database, Security, SQL

sql server 2000
i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

Answer Question   |  May 23, 2008  11:37 AM
SQL, SQL Server 2000

my question
How to find the repeating charactar or letter in a string like ‘information’ in pl/sql or sql .

Answer Question   |  September 22, 2008  4:35 PM
Parsing, PL/SQL, SQL

SQL Server Schema Best Practices
I am in the process of establishing a “sandbox” database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 [...]

Answer Question   |  February 22, 2008  3:01 PM
SQL, SQL Server

Where is the best site to learn SQL?
Where is the best site(s) to learn SQL? A place with example coding etc…

Answer Question   |  September 26, 2007  2:27 PM
SQL

sql
display the third and seventh employee salary details

Answer Question   |  September 26, 2007  4:22 AM
SQL

programming using c#,winforms and visual studio.
i cant think of what to write in this part of the code so that the password character is ” * ” when the user enters his/her password.pliz help private void txtPassword_TextChanged(object sender, EventArgs e) { char Password =GetStyle (“*”); txtPassword.Focus(); } i just have no idea what to write so that this particular code [...]

Answer Question   |  October 24, 2007  7:29 AM
ASP, ASP.NET, C, ColdFusion, DataCenter, Dreamweaver, HTML, J#, J2EE, Java, JavaScript, JSP, Macromedia Flash, Photoshop, Programming Languages, SQL, VB.NET, VBScript, Visual Basic, Web development tools, Web site design & management, XML

Save and Read a text file from oracle database
Hi, I want to save a text file into oracle database (i.e. relational table) and also read it from relational table. Can you please tell me the best approach to do this. Thanks

Answer Question   |  July 28, 2007  9:27 AM
SQL

Migration Problem
I am migrating an Oracle 9i database to a new Oracle 9i database. My problem is that migration of two tables is taking very long. one takes 8 hours and the other takes 4 hours. The reason i can think of is that these two table have clob fields which are being migrated as varchar2 [...]

Answer Question   |  July 25, 2007  8:50 PM
SQL

SQL 2000 to Yukon Migration
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for [...]

Answer Question   |  February 22, 2008  8:02 AM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]

Answer Question   |  March 10, 2008  3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools

Updating a table with sub query
Hi, I need to update a table with a sub query. Here are the steps I’m following but I’m struggling to successfully update the table. the performance of this update has to be good because of the number of rows I’ll be updating in production. any ideas? thanks in advance. drop table dummy_test create table [...]

Answer Question   |  June 28, 2007  4:02 AM
SQL

Subquery as a table reference
I use Showcase Strategy to develop queries and reports on the AS400. Showcase is telling me that I can’t use a subquery to create a table reference to join with in the FROM clause. The Showcase Tech says subqueries are only allowed in WHERE clause. Non-AS400 SQL texts I have read suggest subquery table references [...]

Answer Question   |  May 30, 2007  7:29 PM
SQL

Using Local Variable as FILENAME in CREATE DATABASE Statement
I am trying to use this statement in SQL Server 2000 :- CREATE DATABASE [Maintenance] ON (NAME = N’Maintenance’, FILENAME = @TableName , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N’Maintenance_log’, FILENAME = @LogFileName , SIZE = 1, FILEGROWTH = 10%) COLLATE Latin1_General_CI_AS GO The statement works OK if I hardcode the [...]

Answer Question   |  May 22, 2007  7:23 AM
SQL, T-SQL

Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]

Answer Question   |  May 15, 2008  6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL

SQL behaves differently in two identical Oracle 10g db’s
I have a SQL statement that is behaving differently in two “equal” databases (equal in schema, but size differs by about 50%). Here’s the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, ’2007′, lpad(’01′,2,’0′), ’0′ from studprovider a, student b, school c where a.student_id = b.student_id and b.school_id = c.school_id and a.provider_id = 527 and [...]

Answer Question   |  May 15, 2007  1:33 PM
Oracle, Oracle 10g, SQL

Use Dynamic Create Table Command in Stored procedure
Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. [...]

Answer Question   |  April 23, 2007  1:24 PM
Application development, AS/400, SQL