A Smart Developer
Amjad, Since what you’re trying to do will take you a lot of time developing and debugging, I suggest you download instead QuickBooks Simple Start Free Edition (http://quickbooks.intuit.com/product/accounting-software/free-accounting-software.jsp). If this is for a science project for school, go on. - Jacob
View Answer
| February 24, 2009 9:16 PM
BAS Modules, SQL Server 2005, SQL tables, VB 6.0
Amjad, Since what you’re trying to do will take you a lot of time developing and debugging, I suggest you download instead QuickBooks Simple Start Free Edition (http://quickbooks.intuit.com/product/accounting-software/free-accounting-software.jsp). If this is for a science project for school, go on. - Jacob
View Answer
| February 24, 2009 9:16 PM
BAS Modules, SQL Server 2005, SQL tables, VB 6.0
Stored Procedures, One Database, Different Software Releases
Usually, I will add an optional parameter and use that as an indicator. Here is an example. Let’s say you are adding a field in the Customers table called TwitterId and your latest app version is using this field. Let’s also say you have a Customers_Insert stored procedure that is used to store new records [...]
View Answer
| February 24, 2009 8:49 PM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET
Usually, I will add an optional parameter and use that as an indicator. Here is an example. Let’s say you are adding a field in the Customers table called TwitterId and your latest app version is using this field. Let’s also say you have a Customers_Insert stored procedure that is used to store new records [...]
View Answer
| February 24, 2009 8:49 PM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET
Embed date in SQLBase unload filename
It’s been a long time since I worked with a Centura database; but I still have some documentation books, so I tried to find something that could help in this matter, but I was not able to find anything. It seems that Sql Talk (BAT option, which I assume you are using) doesn’t allow something [...]
View Answer
| February 24, 2009 8:13 PM
Backup software, Scheduled Tasks, Scripts, SQLBase, SQL_Talk
It’s been a long time since I worked with a Centura database; but I still have some documentation books, so I tried to find something that could help in this matter, but I was not able to find anything. It seems that Sql Talk (BAT option, which I assume you are using) doesn’t allow something [...]
View Answer
| February 24, 2009 8:13 PM
Backup software, Scheduled Tasks, Scripts, SQLBase, SQL_Talk
SSIS and Microsoft Excel
I haven’t extracted data using SSIS before, but it is easy enough to use Excel and VBA as the controlling program, and pull the data from the database, and then save it to where ever you need. You can then schedule the excel workbook to open and run every night.
View Answer
| February 24, 2009 10:58 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS
I haven’t extracted data using SSIS before, but it is easy enough to use Excel and VBA as the controlling program, and pull the data from the database, and then save it to where ever you need. You can then schedule the excel workbook to open and run every night.
View Answer
| February 24, 2009 10:58 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS
SQL Server 2005 query to get the average
You you do the match pretty much like you wrote it above. <pre>SELECT (Column1+Column2)/2 as Column3 From YourTable</pre> <pre>Problem is that I run the query and it dispays my value, but asoon as I query that column the value is NULL.</pre>
View Answer
| February 24, 2009 8:03 AM
SQL, SQL queries, SQL Server 2005, Windows Server 2003
You you do the match pretty much like you wrote it above. <pre>SELECT (Column1+Column2)/2 as Column3 From YourTable</pre> <pre>Problem is that I run the query and it dispays my value, but asoon as I query that column the value is NULL.</pre>
View Answer
| February 24, 2009 8:03 AM
SQL, SQL queries, SQL Server 2005, Windows Server 2003
SQL Server data purging
No you can not place online data on a tape. Tape can only be used for backing up the database. The recommended solution would be to get slower less expensive hard drives and use them to host a second filegroup which you move the old data to.
View Answer
| February 24, 2009 6:15 AM
Backup & recovery, SQL Server, SQL Server backup, Tape Backups
No you can not place online data on a tape. Tape can only be used for backing up the database. The recommended solution would be to get slower less expensive hard drives and use them to host a second filegroup which you move the old data to.
View Answer
| February 24, 2009 6:15 AM
Backup & recovery, SQL Server, SQL Server backup, Tape Backups
install a second instance of sql server 2005
Here is a <a href=”http://www.exforsys.com/tutorials/sql-server-2005/installing-a-second-copy-of-sql-server-2005.html”>good tutorial</a> for you.
View Answer
| February 23, 2009 9:44 PM
Multiple SQL Server Installations, SQL Server 2005, SQL Server installation
Here is a <a href=”http://www.exforsys.com/tutorials/sql-server-2005/installing-a-second-copy-of-sql-server-2005.html”>good tutorial</a> for you.
View Answer
| February 23, 2009 9:44 PM
Multiple SQL Server Installations, SQL Server 2005, SQL Server installation
SQL Server 2005 SP2 backup failing
Within a Windows domain the time on the machines has to be within a couple of minutes of each other. If one of the computers is drifting its time you’ll have problems talking between the machines. It is recommended that domains use the time sync features of the computers to ensure that the times match [...]
View Answer
| February 23, 2009 8:44 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database
Within a Windows domain the time on the machines has to be within a couple of minutes of each other. If one of the computers is drifting its time you’ll have problems talking between the machines. It is recommended that domains use the time sync features of the computers to ensure that the times match [...]
View Answer
| February 23, 2009 8:44 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database
Website and database connection
You’ll need to use the information you have to create the connection string. <a href=”http://www.connectionstring.com/”>Connectionstrings.com</a> has all sorts of good info on getting up the connection string. You’ll then need to open the <a href=”http://www.devhardware.com/forums/programming-82/connecting-to-sql-server-using-jsp-32079.html”>connection and execute</a> the query that you want. <a href=”http://www.java-samples.com/showtutorial.php?tutorialid=619″>Here is an example</a> you could find useful.
View Answer
| February 23, 2009 3:55 PM
Database connectivity, JSP, SQL Server, SQL Server connectivity, SQL Server development, Web development
You’ll need to use the information you have to create the connection string. <a href=”http://www.connectionstring.com/”>Connectionstrings.com</a> has all sorts of good info on getting up the connection string. You’ll then need to open the <a href=”http://www.devhardware.com/forums/programming-82/connecting-to-sql-server-using-jsp-32079.html”>connection and execute</a> the query that you want. <a href=”http://www.java-samples.com/showtutorial.php?tutorialid=619″>Here is an example</a> you could find useful.
View Answer
| February 23, 2009 3:55 PM
Database connectivity, JSP, SQL Server, SQL Server connectivity, SQL Server development, Web development
Explain Stored Procedures in AS/400
Stored procedure is: 1. Called by SQL 2. Is either a program written in PL-SQL or 3. Identifies a program (in languages like RPG/Cobol/CL etc) on the AS/400 to run 4. Can receive a set of IN parameters 5. Can return a set of OUT parameters 6. Can receive and return a set of IN-OUT [...]
View Answer
| February 20, 2009 2:06 PM
AS/400 development, AS/400 stored procedures, Stored Procedures
Stored procedure is: 1. Called by SQL 2. Is either a program written in PL-SQL or 3. Identifies a program (in languages like RPG/Cobol/CL etc) on the AS/400 to run 4. Can receive a set of IN parameters 5. Can return a set of OUT parameters 6. Can receive and return a set of IN-OUT [...]
View Answer
| February 20, 2009 2:06 PM
AS/400 development, AS/400 stored procedures, Stored Procedures
Installing SQL Server 2005 Enterprise Manager in Windows XP Pro
Just ignore the IIS warning. That only applies if you are installing SQL Reporting Services on the machine.
View Answer
| February 19, 2009 10:30 PM
IIS, IIS errors, SQL Server 2005 Enterprise Manager, SQL Server 2005 error messages, SQL Server Enterprise Manager, SQL Server error messages, Windows XP, Windows XP Professional
Just ignore the IIS warning. That only applies if you are installing SQL Reporting Services on the machine.
View Answer
| February 19, 2009 10:30 PM
IIS, IIS errors, SQL Server 2005 Enterprise Manager, SQL Server 2005 error messages, SQL Server Enterprise Manager, SQL Server error messages, Windows XP, Windows XP Professional
SQL Server 2008 Export data problem
Have you asked your ISP if they can just put a database backup on your web server that you can download once a week? Try looking at the Object Transfer component within SSIS. It should be able to drop the objects and recreate them in the correct order.
View Answer
| February 19, 2009 10:28 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export
Have you asked your ISP if they can just put a database backup on your web server that you can download once a week? Try looking at the Object Transfer component within SSIS. It should be able to drop the objects and recreate them in the correct order.
View Answer
| February 19, 2009 10:28 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export
Server 2003 memory performance configuration
The machines which have large page files probably need more RAM. Have you identified which layer of the application the performance problems are coming from? Is the database running slow, is the web server running slow, are the term servers running slow? Without identifying which layer is causing the problem you won’t have much luck [...]
View Answer
| February 19, 2009 10:20 PM
Server Performance, SQL, SQL Server, Windows Server 2003, Windows Server Performance
The machines which have large page files probably need more RAM. Have you identified which layer of the application the performance problems are coming from? Is the database running slow, is the web server running slow, are the term servers running slow? Without identifying which layer is causing the problem you won’t have much luck [...]
View Answer
| February 19, 2009 10:20 PM
Server Performance, SQL, SQL Server, Windows Server 2003, Windows Server Performance
How do I combine multiple rows into one row?
One method is to use MAX on all the columns that aren’t your ID field. <pre>SELECT Col1, max(Col2), max(Col3), max(Col4), max(Col5) FROM YourTable GROUP BY Col1</pre>
View Answer
| February 19, 2009 3:04 AM
SQL Mulitple Rows
One method is to use MAX on all the columns that aren’t your ID field. <pre>SELECT Col1, max(Col2), max(Col3), max(Col4), max(Col5) FROM YourTable GROUP BY Col1</pre>
View Answer
| February 19, 2009 3:04 AM
SQL Mulitple Rows
How can I pass tablename as a parameter in MySQL stored procedure?
It would be something <b><i>similar</i></b> to this: <pre>CREATE PROCEDURE test ( ImageID varchar(10), Stat varchar(1), tablename varchar(200)) BEGIN SET @s = CONCAT(‘INSERT INTO ‘,tablename,’ (ImageId,Status) values (‘,ImageID,’,',Stat,’)') PREPARE stmt FROM @s; EXECUTE stmt; DEALLOCATE PREPARE stmt; END;</pre> (change data types as needed…)
View Answer
| February 18, 2009 2:17 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures
It would be something <b><i>similar</i></b> to this: <pre>CREATE PROCEDURE test ( ImageID varchar(10), Stat varchar(1), tablename varchar(200)) BEGIN SET @s = CONCAT(‘INSERT INTO ‘,tablename,’ (ImageId,Status) values (‘,ImageID,’,',Stat,’)') PREPARE stmt FROM @s; EXECUTE stmt; DEALLOCATE PREPARE stmt; END;</pre> (change data types as needed…)
View Answer
| February 18, 2009 2:17 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures
SQL Restore takes 6-10 minutes to come up in Enterprise Manager
check out msdb.dbo.sp_delete_backuphistory My guess is your msdb is full of backup history. When you use the GUI it is reading through all of the history. Create a SQL agent job to run daily and trim the history back 30 or 90 days.
View Answer
| February 17, 2009 6:58 PM
MySQL Restore, SQL 2000, SQL Enterprise Manager, SQL performance, SQL Restore, SQL Restore Performance, Windows 2000 Server
check out msdb.dbo.sp_delete_backuphistory My guess is your msdb is full of backup history. When you use the GUI it is reading through all of the history. Create a SQL agent job to run daily and trim the history back 30 or 90 days.
View Answer
| February 17, 2009 6:58 PM
MySQL Restore, SQL 2000, SQL Enterprise Manager, SQL performance, SQL Restore, SQL Restore Performance, Windows 2000 Server
My CL program is running CPYTOIMPF cmd & causes an SQL error
Not sure but we could use some additional info. Can you run the command CPYTOIMPF on another file? Are there any unusual column types in the file you’re attempting to copy? — ie: BLOG’s Is there any crupt data in the file you’re attempting to copy? What is the value for the TO STREAM file? [...]
View Answer
| February 17, 2009 6:38 PM
CL programs, CPYTOIMPF, SQ999999, SQL error messages
Not sure but we could use some additional info. Can you run the command CPYTOIMPF on another file? Are there any unusual column types in the file you’re attempting to copy? — ie: BLOG’s Is there any crupt data in the file you’re attempting to copy? What is the value for the TO STREAM file? [...]
View Answer
| February 17, 2009 6:38 PM
CL programs, CPYTOIMPF, SQ999999, SQL error messages
Oracle SQL-Pagination Help
A lot depends on how you are using the results. If this is a frequent query, you might consider creating a Materialized View on the data, including the rownumber as a column in the view. With a Materialized View, you can index the columns and run very efficient queries against the view, so your pagination [...]
View Answer
| February 17, 2009 5:00 PM
Oracle SQL, Oracle SQL Pagination, Pagination, SELECT statement
A lot depends on how you are using the results. If this is a frequent query, you might consider creating a Materialized View on the data, including the rownumber as a column in the view. With a Materialized View, you can index the columns and run very efficient queries against the view, so your pagination [...]
View Answer
| February 17, 2009 5:00 PM
Oracle SQL, Oracle SQL Pagination, Pagination, SELECT statement
SQL Server 2005 backup
Typically you set up the SQL server maintenance jobs to dump backups into the backup directory and then you use backup software to back up this backup directory. Otherwise you use software specifically designed to back up SQL like Tivoli Storage Manager tdpsql. All backup software (including SQL Server backup software and backup agents like [...]
View Answer
| February 16, 2009 10:13 PM
Backup, SQL Server 2005 backup, SQL Server backup
Typically you set up the SQL server maintenance jobs to dump backups into the backup directory and then you use backup software to back up this backup directory. Otherwise you use software specifically designed to back up SQL like Tivoli Storage Manager tdpsql. All backup software (including SQL Server backup software and backup agents like [...]
View Answer
| February 16, 2009 10:13 PM
Backup, SQL Server 2005 backup, SQL Server backup
What are basic differences between SQL Server 2000 and 2005
Here is a <a href=”http://www.sqlservercentral.com/articles/Administration/2988/”>good article</a> for you. You will need to register to read it, but registration is free. Here is a<a href=”http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx”> list of all the features</a> that all the various editions of SQL Server 2005 offer. Compare this with the list of features that you are using now and see how they [...]
View Answer
| February 16, 2009 10:10 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005
Here is a <a href=”http://www.sqlservercentral.com/articles/Administration/2988/”>good article</a> for you. You will need to register to read it, but registration is free. Here is a<a href=”http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx”> list of all the features</a> that all the various editions of SQL Server 2005 offer. Compare this with the list of features that you are using now and see how they [...]
View Answer
| February 16, 2009 10:10 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005
