• 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,365 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,365 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...

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

    ITKE435,985 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:
  • 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 password issues

    How can I access a SQL Server without a password, how can I change a SQL Server password, and what is an SA on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Select columns with columnized ntext data

    I have a table with 20 columns, where column 2 is an ntext, and it contains 133 comma separated 'fields'. How do I read the 19 columns and include in the output, the 133 columns from the ntext column.

    PeterGrierson45 pointsBadges:
  • Schedule backups on regular intervals in Azure Backup

    I have SQL Server on premises, data is about 20GB. I want to scheduled backups on regular intervals in Azure Backup. Would like to how it works?

    mmreddykiran5 pointsBadges:
  • INSERT or CREATE record in SQL Server database

    I have this SQL Server table structure: MyTable(KEY, datafield1, datafield2...) And now I have to update an existing record / create a new one if it doesn't appear. What's the best way to do that?

    ITKE435,985 pointsBadges:
  • Ignores my new column-store index in SQL Server 2014

    I am using SQL Server 2014. I had an existing table with lots of indexes. I added a non clustered column-store index as a test. When I run test queries it ignores my new column-store index. I don’t know Why? Should I remove the old indexes, leaving just the column store?

    danieljones2,800 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE435,985 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,365 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Grant permissions to user for backup/restore in SQL Server

    Can anyone tell me what permissions must I give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role?

    edwinjhoffer3,365 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.

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

Following