MySQL 5.0 advantages and disadvantages
what is the advantage and disadvantage of mysql 5.0?

Answer Question   |  August 31, 2009  5:53 AM
MySQL, MySQL 5.0

SQL Certification
Could someone please guide me as to how to go about for the certification of SQL

Answer Question   |  February 25, 2011  5:49 AM
SQL certifications

AS/400 stored procedures
Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were “create” routines (some were actual procedures). Seems like there ought to be an easier way.

Answer Question   |  August 26, 2009  7:13 PM
AS/400, SQLRPG, Stored Procedures

How to open sqlserver2005 after installing
I have installed Sqlserver 2005 into mys system and how can i set a username and password to that.I am the only user to that computer.

Answer Question   |  September 22, 2011  4:00 PM
SQL Server 2005, SQL Server Password Management

Getting specific values from a SQL table to the ComboBox
How do I get specific values from a SQL table to the ComboBox in the running mode?

Answer Question   |  October 5, 2011  3:53 PM
combo box, ComboBox, SQL tables

SQL autonumbering problem
I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does the auto numbering go haywire? What is [...]

Answer Question   |  August 27, 2009  2:45 PM
SQL Server, SQL Server administration

MySQL vs. Oracle
what is the major two comparison of mysql5.0 and oracle 10g?

Answer Question   |  September 1, 2009  8:36 AM
MySQL, MySQL 5.0, MySQL vs. Oracle, Oracle 10g

Merge Replication with express versions
I am trying to do a merge replication with about 10 pda’s and a desktop i do not want to use full blown ms sql due to cost, anyone any alternatives PDA’s are running Mobile 6 and sql compact IF need be will change from MS sql to other

Answer Question   |  August 26, 2009  7:49 AM
Merge replication, Mobile devices, PDAs

SQL Server datetime
Hi - When I run this: select cast (’461129′ as datetime) i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results. thx

Answer Question   |  August 27, 2009  6:35 PM
SQL datetime, SQL Server 2000, SQL Troubleshooting

Migrating C code db acess from sybase to sql server 2005 – newbie
I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i’m a bit confused … with ODBC and the use of sqlcli.h i write a simple C code that access the [...]

Answer Question   |  August 25, 2009  7:49 AM
C programming, ODBC, SQL Server 2005, Sybase

Function to find greatest numeric value across different fields
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

Answer Question   |  August 25, 2009  2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function

SQLRPGLE – Prepare – Declare Cursor
I’m using Prepare, Declare SQL cursor in my SQLRPGLE program After Declare statement I receive SQL -312 – Which indicates to me that the SQL statement is not declared correctly. Is it something wrong with my query. I ran this query in SQL editor and went fine. I dun understand why not in the program. Given [...]

Answer Question   |  August 26, 2009  1:49 AM
SQL Cursors, SQLRPGLE

Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way to ”capture the SQL Server logged in user name” in the Access code?  Probably in [...]

Answer Question   |  August 27, 2009  11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security

SQL Server Database Restore
When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner “domainrmartinez”. How can i restore a database from server1 to server2 and the database owner as “sa”?

Answer Question   |  September 4, 2009  9:21 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server database, SQL Server database restore

file user open exceptions for printer file
i’m opening a program defined printer file in SQLRPGLE.. i get error file is already open…. if that is the case, then i’m trying to write in that file but now this gives me exception that attempting to write in closed file…   Please help

Answer Question   |  October 11, 2009  8:12 PM
SQL error messages, SQL Printing, SQLRPGLE

Can I add a local SQL 2005 instance to a clustered node
I have a 2 nodes (Active/Active) SQL 2005 Standard cluster. Since SQL STD only support two clustered instances, can I add a local instance to each node? I don’t need this local instance to fail over. Is it possible to have the two clustered instances an two local instance one on each node?

Answer Question   |  August 27, 2009  8:01 PM
SQL 2005 Database, SQL Server, SQL Server Clustered Index

sqlserver2005 on windows vista home premium(32 bit)
i have sqlserver2005 wid service pack 2 installed,it gives server names as-’user-pcsqlexpress’&'user-pc’. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

Answer Question   |  August 24, 2009  7:42 AM
SQL Server 2005, SQL Server error messages, Vista, Windows Vista Home Premium 32-bit

how i do save picture in data base vb.net
iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

Answer Question   |  January 23, 2010  7:58 PM
Access Database Attachments, SQL Express, Visual Basic

SQL auto increment by group with INSERT..
Is it possible to define an auto-incremental coloumn which increments by ‘group’ ? I want to create a version log for an old table (uniquely keyed ‘HOWTONO’) which contains records with ‘How to’ data in the form of short code-fields and some long fields with text.  I intend to trigger updates, inserts  and deletions from [...]

Answer Question   |  August 25, 2009  11:19 AM
AS/400, Incremental backup, SQL, SQL INSERT, V6R1

following error when logging into SQLPlus
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I’m using Oracle 9i Personal Edition

Answer Question   |  August 21, 2009  6:41 AM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus