• Database with Visual C++

    I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don't know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot

    Makee15 pointsBadges:
  • Database for OLTP

    Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

    Akansha150 pointsBadges:
  • How to split a column into SQL data..

    I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

    Anamika8315 pointsBadges:
  • Cannot Regster remote SQL Server 2000

    I can access remote server by remote desktop and I can ping server also, but fail to register remote SQL Server. Please help.

    Master197015 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • About MCTS 70-432 exam

    Sir, as I'm new to this, I would like to know were would I can get free download for the MCTS 70-432 exam. I also need study material for this and also like to know if I need to go through a training session from an institute for this exam or can I do it myself. Please guide me for the above....

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Database file in Novell GroupWise

    What is a data base file in novell groupwise? Is it associated with each novell file or there is only 1 which contains info for all other file?

    PCVITA15 pointsBadges:
  • How to perform pit recovery

    I cannot find a good doc which describes hot to perform a pit recovery in sql server.

    Michaelkurth5 pointsBadges:
  • Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?

    Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE351,965 pointsBadges:
  • Archiving Exchange 2007 in a SQL database

    How do you set up an SQL database/server to receive and store archiving/journaling for exchange 2003/2007 email.

    Cmoney5 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE351,965 pointsBadges:
  • Free Centralize backup solution

    Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel,...

    Thmohan50 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that your data has updated.But it is not showing in the database. Please look in the below code and tell me where I'm wrong: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Consolidating SQL Server databases

    How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting VB 2008 to SQL Server2005

    How to connect VB2008 with SQLServer2005 through coding. Not through OleDBAdaptar. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    Michael Tidmarsh33,310 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • How to use INSERT or UPDATE on SQL Server

    In our SQL Server database, we have a table structure like this: MyTable(KEY, datafield1, datafield2...) Sometimes, we need to either update an existing record or just insert a new one if you doesn't exist. Basically, this is what we want to run: IF (key exists) run update command ELSE run insert...

    ITKE351,965 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