• Does SQL support nonlinear recursive queries?

    does sql supports nonlinear recursive queries

    Gomsbk35 pointsBadges:
  • SQL Explorer Not Connected

    Hi all My OS is WIN 7 , Oracle Server Installation (10g Express Edition) is Sucessful Oracle 10g Client Installation is sucessful ODBC connection is Sucessful. But SQL Expolrer - not connected Error is General SQL Error. Microsoft [ODBC Driver Manager] Driver is SQLallocHandle on SQL_HANDLE_ENV...

    Yes115 pointsBadges:
  • error in SQL workbench

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

    Whitneyf5 pointsBadges:
  • How can i connect database from sql explore

    Hi all, My OS is Windows 7, I install Oracle 10g Express Edition then i install Oracle 10g client. Installation is Sucessful then i config ODBC setting.ODBC is Connection Sucessful.But SQL Explorer is Not Connected.How can i solve this Problem?Kindly Help.

    Yes115 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

    LordPerrin15 pointsBadges:
  • FreeRadius CentOS 5.5 Help

    Hello, I have setup a freeradius server on CentOS with a SQL backend. I am unable to autenticate using NTRadPing to test a user conenction. Just need some help to debug and find out the cause. Thanks! Scott

    Jonessc5 pointsBadges:
  • SQL To Excel Data Dumping with the help of SSIS flow task.

    I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode...

    Ssis5 pointsBadges:
  • Large number rounding in Oracle 10g

    Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some...

    Techguys90 pointsBadges:
  • Crystal Reports to SSRS

    There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the...

    Mbdaniel5 pointsBadges:
  • iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,775 pointsBadges:
  • Best way to back up SQL Server 2008 database?

    What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

    ITKE352,420 pointsBadges:
  • Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager

    Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

    Anco5 pointsBadges:
  • Migrating from Microsoft applications to Oracle

    How can I easily convert my SQL 2005 databases to Oracle's latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

    ITKE352,420 pointsBadges:
  • moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.

    I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster. The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating...

    MikeDCCA5 pointsBadges:
  • Connecting to the SQL- SERVER from VS-2008 C#

    How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.

    Rajeshu135 pointsBadges:
  • How do I restore my SQL .bak file over the existing database?

    How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore to a fresh database?

    ITKE352,420 pointsBadges:
  • SQL Server 2008 Code to find fields containing similar text

    I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word "Smith" Field 2 has "Smith AB" in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET

    To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft's Senior Technical Product Manager, Brjann Brekkan, on July 20 from...

    ITKE352,420 pointsBadges:
  • Web based application not uploaded ON SERVER sometimes

    We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update...

    SJFIL5 pointsBadges:
  • Maximum memory on a 64-bit operating system?

    I need to install a new SQL server and we are buying a 64-bit OS. What's the maximum amount of memory that the operating system can hold/support/make use of?

    ITKE352,420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following