what is the advantage and disadvantage of mysql 5.0?
Answer Question | August 31, 2009 5:53 AM
MySQL, MySQL 5.0
Could someone please guide me as to how to go about for the certification of SQL
Answer Question | February 25, 2011 5:49 AM
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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