• Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Remove duplicate rows from a large table in SQL Server

    For SQL Server, does anyone know the best way to remove duplicate rows from a large table? Here's what I have so far: MyTable ----------- RowID int not null identity(1,1) primary key, Col1 varchar(20) not null, Col2 varchar(2048) not null, Col3 tinyint not null Thanks!

    ITKE371,630 pointsBadges:
  • How can I get the queries history in SQL Server?

    Is there a way I can get the queries history in SQL Server?

    balachandr5 pointsBadges:
  • Can’t repair MyoVision Access database

    One of my clients has a 130MB Access MDB which contains thermo image scans from an application called MyoVision. Recently, the database became corrupt and MyoVision is offering no support to fix it. What I'd like to attempt is Repair the database as it seems to be corrupted. Create a new MDB file...

    DavidCum7775 pointsBadges:
  • Calling COBOL program from native DB2 stored procedure

    Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

    Tanmay2115 pointsBadges:
  • SQL Server 2014: Automatic update trigger if the record is duplicate

    I am using SQL 2014 and want to insert and update a lot of records within a Stored Procedure, and then have a trigger to rollback the record if it already existed and then update just after the rollback. Is there a better way of doing this?

    edwinjhoffer3,045 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Auto calculation of Valuation per unit in SQL Server

    Sir/mam, I have a Table of different product of mutual fund its valuation(nifty level change) is to be calculated. Each product has a different formula which takes input of some variable parameter and some static. How do I calculate row by row formula? (including Average function for eg,...

    ojha1235 pointsBadges:
  • Getting this error while installing SQL server failover cluster instance

    I checked CNO permissions, the CNO had "Read all properties" and "Create Computer objects". The user that create the instance is an domain administrator and local administrator. Can someone help me?

    edwinjhoffer3,045 pointsBadges:
  • SQL Server login problems

    I am using Access as a front end to SQL Server 2014 backend database using DSN-less connections to tables and for pass-thru queries. All works fine. I have recently created a second database within the same instance of SQL Server, and believe I have set log in credentials the same for both, but am...

    DataSense35 pointsBadges:
  • Best 3rd party monitoring software for SQL?

    What's the best 3rd party monitoring software for SQL?

    Fran5 pointsBadges:
  • SQL Server: Update a table using SELECT

    I understand that in SQL Server, it's actually possible to insert into a table using the SELECT statement. But would it be possible to actually update via SELECT? We have a table that contains values and we need to update another table with those exact same values. Thanks.

    ITKE371,630 pointsBadges:
  • SQL Server 2008 R2 database isolation change

    I want to change my database isolation to read uncommitted in SQL server 2008 R2. Can someone tell me the exact process and how should I can achieve this?

    edwinjhoffer3,045 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • Select 1 + 1 from tablename in SQL Server

    What will the above query return?

    shainan15 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Sanitize user input for a SQL injection using PHP

    What's the best way to sanitize user input for a SQL injection / XSS attack? I need it done with PHP too and it needs to still allow types of HTML tags. Thanks!

    ITKE371,630 pointsBadges:
  • Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 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.