Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

SQL Server

Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.


More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Report Builder 2.0 RC1 - Editting Relationships

    In RB20 RC1 with the wizard to create a report based on a SQL db, there is no option to change the relationships visually. The only way is to edit the query as text.

    With db's that have no foreign key relations, like the Ax db, this will slow down the development of a report.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Oct 13 2008 8:09PM=-=>

    Thank you for using SQL Server Reporting Services.
    The Query Designer which is in RC1, and is accesable from the wizard does allow you edit relationships. There is a section, on the right side, in the middle which is collpased by default. This section allows you to change the relationship types. Granted its not a ‘graphical’ view and has its limitations but you may find useful in some cases rather than always editing the SQL itself.

    <=-=Oct 17 2008 4:30AM=-=>

    Thanks for the reply.
    My problem is that I have a database without any foreign key relations (here the Ax database). When I select two tables, both are display in the Relationships section. And in my understanding there is no option to link those two tables (without a foreign key relation) within the Query Designer.

    Will there be an option to link tables together?…

  2. SSRS Exporting Report With Charts to Excel

    We are using SQL Server 2005 Reporting Services (it is great), however we need to resolve one of the issues we have when exporting reports from SSRS to Excel. When exporting charts to Excel they render as images. We need to have a choice to render charts as objects(interactive chats), meaning that if you change a number in an Excel grid then the chart(that represents the data in that grid) will immediately change too. Our analysts and clients want to tweak the numbers in the table and expect the accompanying chart to be updated automatically. (Tried SSRS2008 with no success).…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 5

    <=-=Sep 30 2008 1:22PM=-=>

    Hi,

    Thanks for writing in with this feature request. We already have a request for real Excel charts so I will resolve this issue as a duplicate of the other one.

    As far as using OfficeWriter, can you explain how that does not meet your needs? That information will help us understand your requirements much more clearly.

    Thanks,
    Chris B.
    SQL Server Reporting Services

    <=-=Oct 6 2008 6:44AM=-=>

    As far as OfficeWriter is concerned let say we have a stored proc that returns for each customer:
    Customer||Account||Amount
    Date1
    Date2

    Date..n

    Now we need a report :

    +Customer
    Date1, Date2, .. Date..n
    Customer
    Amount

    SSRS does not have a problem. It even creates a grouping that by clicking expands and collapses a customer grouping. Also, data should be saved (in Excel) for each customer (how many customers is unknown) on separate sheet. Office Writer…

  3. SQL 2008 Audit missing Application name and Host name

    Auditing is a great feature in 2008 and helps in finding who is doing what and when but would be great to capture the Application name used in action and the host name where it is submitted from. These two key values are very importatnt for a complete audit trail.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 10

    <=-=Sep 25 2008 6:06PM=-=>

    Hi,

    Thank you for your suggestion. Currently, you can obtain the client’s IP address from the Additional Info column if you add the SUCCESSFUL_LOGIN_GROUP audit group. The application name is unfortunately not available, but we will look into including this in a future releaes of SQL Server.

    Thanks,
    Il-Sung.

    <=-=Aug 26 2015 7:51AM=-=>

    Hi,

    My customer is a big financial institution and they have thousands of SQL Server. They have some basic auditing configured with Profiler traces across all of these servers. They want to use the Native Audit feature to replace Profiler traces, but they can’t because of these two missing columns – Application Name and Host Name. This is affecting their plans to use this powerful feature (SQL Audit) across thousands of SQL Server. Any updates on this request?

    Thanks!

    <=-=Oct 13 2015 9:57PM=-=>

    Hi

    I still cannot find the Application…

  4. Report Builder RC1 - Quick object finder

    Hi Team,

    Congratulation for the new version.
    Really better than a previous.
    however when we have a building error, the message error textbox1
    the problem is to find this textbox, could you provide a quick search of the object we have on the designer.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Sep 24 2008 1:16PM=-=>

    Thank you for this suggestion, it is something that we’ve heard from others as well. We will consider adding this functionality in a future release of Report Builder.

    <=-=Sep 24 2008 1:31PM=-=>

    Only Report Builder 2.0 includes a “ribbon” so we need some more information or specific repro steps. It sounds like you are using SQL Server 2005 Report Builder. Is that correct? If so, are you trying to use the Find functionality for searching the report model or the find functionality while viewing the end results of the run report? Thanks.

  5. Need to guarantee release of Application Lock

    I am using an Application Lock to serialize a section of critical code in a stored procedure. In some cases, the client, a asp.Net application, times out and cancels the command while the SQL Server is executing the critical code, so sp_releaseapplock is not called at the end of the critical section, and the lock is never released. The web application uses connection pooling, so the connection persists and holds the lock.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Sep 24 2008 9:21AM=-=>

    Thanks for your feedback. Here is the feedback from Dev

    Dev>> I don�t think that fixing the exception handling for the system SP is going to help. There are many cases where we cannot trap server-side errors in the catch block � some of the errors are batch aborting and you can only trap it on the client-side. This is a case where the customer has to release the lock just like say rolling back an uncommitted user transaction. Application locks are meant to be handled by the application logic

    My suggestion for the customer request is the following:

    Make the application code robust similar to say handling user transactions. You would check for @@TRANCOUNT for example and rollback an uncommitted transaction started from the client side

    <=-=Sep 24 2008 2:40PM=-=>

    I have modified my client application to deal with this problem, but I…

  6. Installing Report Builder as Stand Alone application

    We are currently using Report Builder 9.00.3042.00, which deploys as a cloick-once application. Many of our users do not have local rights allowing them to install applications, so these users have no means of accessing our ad hoc report facility. Is there a method for including this in the base image so that it does not need to run as a click Once application?

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Oct 13 2008 8:37PM=-=>

    Thank you for using SQL Server Reporting Services.
    click-once is an area we are investigating for a future release.
    thank you for your patience.

    <=-=Dec 9 2008 11:55AM=-=>

    Thanks for your feedback. In SQL 2005 we do not provide a standalone installer for Report Builder. However, this is available in SQL 2008 with Report Builder 2.0. Note that SQL 2008 Reporting Services is required.

    The download page is here:
    http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

    Hope that helps!

  7. OPEN { SYMMETRIC | MASTER } KEY Password Parameterization

    Consider the following SQL statement to open a symmetric key, decrypting it by a certificate that has its private key protected by a password:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = '<password>';

    Since OPEN ... KEY SQL statements do not accept parameters, you need to formulate the SQL string as inline-SQL (YUCK!). Assuming your password is 'abc123', your SQL statement will look something like this:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = 'abc123';

    Nothing wrong there.

    Now assume we select a password of [';SELECT 'SQL INJECTION';--] (excluding the square brackets []), your…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 12

    <=-=Sep 25 2008 2:39PM=-=> The tile for the bug is a little bit misleading as there is no direct SQL injection vulnerability in the DDL statement, but since there is no parameterization on DDL, it forces any application to use dynamic SQL by concatenating strings in order to generate the statement. Because using dynamic SQL opens the opportunity for SQL injection problems in case the user data (in this case the password) is not properly escaped. We definitely agree that there is a potential for improvement in this area, and I would like to generalize it a little bit more: Allow DDL parameterization for DDL that accepts passwords, including OPEN (SYMMETRIC | MASTER) KEY. We are currently considering how to improve in this particular area, but I would like to invite anyone who is forced to use dynamic SQL for DDL/DML to…
  8. Provide ALTER Permissions at the Database Object Class Scope Level

    Currently, I can GRANT or DENY explicit CREATE TABLE, PROCEDURE, FUNCTION, etc. permissions at the Database Object Class level.

    In order to GRANT a particular object class (PROCEDURE for example), I must GRANT CREATE PROCEDURE at the database scope and ALTER at the schema scope levels. However, that ALTER SCHEMA permission exposes modification to every other object class within the scope of that schema. I must then explicitly DENY ALTER on every specific object within that schema that I want to restict modifications.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Sep 2 2008 12:46PM=-=>

    Hi Anthony,

    Thank you for your suggestion. It’s too late to make any changes to SQL Server 2008 but we will consider this for a future version of SQL Server.

    Thanks,
    Il-Sung.

    <=-=Feb 11 2013 2:37PM=-=>

    Hi Anthony, Thank you for your suggestion. It’s too late to make any changes to SQL Server 2012 but we will consider this for a future version of SQL Server.

  9. After an XML modify() operation, need a way to know if the operation succeeded or not.

    After performing an insert/update/delete operation in an XML variable or column using the modify() method, there is no way to know if the operation succeded or not. There needs to be a way to know if any element/attribute is updated/deleted/inserted and the number of elements/attributes affected. Something like @@rowcount.

    Edited on 30 Aug 2008.
    SQL Server does not raise an error if the modify operation fails (if it could not modify the value). So there is no easy way to identify where the update/insert/delete operation actually modified the value or not. We need a way to identify this.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 5

    <=-=Sep 9 2008 5:10PM=-=>

    Dear Jacob and people voting on this item.

    Thanks for the request to report how many elements or nodes have been updated. How do you see the this work across multiple rows? Do you want it on a per average, per row, or the min and max values?

    Best regards
    Michael

    <=-=Sep 9 2008 8:27PM=-=>

    I think if we can get a count of elements/attributes updated, that will be good enough to start with. If the update operation did not modify anything, it may return 0 and if it updates 2 elements it may return 2.

  10. Unable to access new instance of SQL as member of administrators

    After installing 2008 I was unable to connect to the database using any protocol as a member of the administrators group.
    I had to logoff and log back on as "Administrator" for the local machine and then add my domain account directly to SQL server as a Sysadmin.

    Then I had too alter the windows firewall to allow even cmd line access to the local instance of the database.

    Vista Enterprise edition.
    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 6.0 <X86> (Build 6001: Service…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Sep 10 2008 10:38AM=-=>

    In versions earlier than Windows Vista and Windows Server 2008, members of the local administrator group do not need their own SQL Server logins and they do not need to be granted administrator privileges inside SQL Server. They connect to SQL Server as the built-in server principal BUILTIN\Administrators (B\A), and they have administrator privileges because B\A is a member of the sysadmin fixed server role.

    In SQL Server 2008, the BuiltIn\Administrator login group is NOT provisioned by default during setup install. Instead during SQL Server 2008 setup install (on the account provisioning screen), users are required to provision one or more admin account into the sysadmin fixed server role to perform administrator actions on SQL Server.

    Secondly BuiltIn\Administrator rights (by default) are stripped away in Windows Vista and Windows Server 2008 because of UAC feature, so box administrator users cannot connect to SQL

  11. Report Manager Communications should be compressable

    While using the report manager with reports that have cascading parameters that is connected to an AS cube we get poor performance during the parameter selection process when connected over the internet OR a VPN connection. This does not occur when on the local network.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Sep 15 2008 3:51PM=-=>

    Thank you for filing this bug.

    We are currently investigating your request for the next version of SSRS. Will keep you posted.

    thanx,
    Prash

    <=-=Apr 16 2010 9:21PM=-=>

    Thanx you for filing this bug.

    After further review we decided not to include your suggestion in the SSRS 2008 R2 Report Manager. We plan to keep it under consideration in our plans for the next version of SSRS.

    thanx,
    Prash

    <=-=Apr 16 2010 9:21PM=-=>

    Thanx you for filing this bug.

    After further review we decided not to include your suggestion in the SSRS 2008 R2 Report Manager. We plan to keep it under consideration in our plans for the next version of SSRS.

    thanx,
    Prash

  12. Custom Report Item should support other types then only images

    Allow create custom report item of other types like HTML and with this we could create custom report item that create flash chart or silverlight charts, it will give much more power to Report Services.

    Others BI tools like MicroStrategy and Business Objects have this out of the box (flash charts).

    And why do not allow to create custom items of other types?

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Sep 30 2008 6:53PM=-=>

    Hello,

    Thanks for writing in about this feature request. We will evaluate this for a future version of SQL Server. If we have information to give you regarding the status of this bug, we’ll do so via MS Connect.

    I’m keeping this active, but marking it to be re-evaluated as we begin our next round of planning.

    Best regards,
    Chris B.
    SQL Server Reporting Services

  13. Ability to handle temporal data / columns within the engine core

    Enterprise Data Warehouses require "start / end" or "load/load-end" dates to house data over time.

    What I would like is the ability to issue a select statement as follows:

    Select <most recent data>
    from the EDW.TABLE
    where
    data is current AS OF <my date>

    In other words, a whole host of "temporal based" functionality where SQL is capable of recognizing "layers" of data for a specific point in time.

    Thanks,
    Dan Linstedt

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Aug 26 2008 5:06PM=-=>

    Dear Dan

    Thanks for your feedback and suggestion. Are you specifically interested in the so-called transaction time (where the timestamp is immutably given at the time the data is inserted) or the so-called valid time (a user-specified timestamp indicating the validity of the data) or both?

    We are looking into a variety of interesting solutions in this space and your feedback, including your rating would be valuable input.

    Thanks
    Michael

    <=-=Mar 9 2011 5:04PM=-=>

    Dear Dan, we are closing this as a duplicate of the Feedback item 557002 since the other item has collected some votes on it already. Please go and add your own vote and comments on the other item.

    Thanks
    Michael

  14. Change or remove message 1061 from sys.messages

    When you perform:

    select * from sys.messages where language_id = 1033 and text like '%yet implemented%'

    there is a row refering to message_id = 1061. The text is: "The text/ntext/image constants are not yet implemented."

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Aug 19 2008 11:30AM=-=>

    Hi,
    Thanks for your feedback. We will remove this error message in a future version of SQL Server. This error message is not used by the engine currently.


    Umachandar, SQL Programmability Team

    <=-=Mar 8 2011 3:11PM=-=>

    This has been resolved as duplicate of connect item below:

    https://connect.microsoft.com/SQLServer/feedback/details/650174/cleanup-error-messages


    Umachandar, SQL Programmability Team

  15. Column widths and editing data for DB views in Management Studio

    The biggest issue for me is entering and editing data in a SQL Server or Express edition database without having to develop a .NET application. Using views in SQL Server Management Studio (SSMS) are a good choice for this task and work OK once I figured out that I had to use "TOP (N)" and not "TOP (100) Percent" to be able to edit data in a sorted view. I am also using INSTEAD OF triggers to "flatten data" from multiple tables. What I find really annoying is that the field column widths can be saved for the results pane…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Aug 26 2008 8:28AM=-=>

    Hi,

    Thank you for filing the enhancement request to us. We understand that adjusting columns can sometimes be painful during repeated script executions and directly editing results can be a convenience. I have marked your bug as direct feature feedback for a future release of SQL Server.

    Thanks again,
    Karthik

    SQL Server Manageability Team

    <=-=May 30 2011 1:58AM=-=>

    Hi,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    Thanks for writing in to Microsoft.

    Cheers,
    Karthik Vijayakumar

  16. SQLAgent Job Notifications

    SQL Server just keeps getting better, by the way, so thanks. DMVs rock! But (!) could you please change SQLAgent job notifications to be more specific about the result than just Succeeded or Failed? When you look at the job history the icons tell you whether all steps succeeded or only some. I'd love to see something in the notification email that would prompt me to check the results in detail.

    For example, I have a job to do my backups with a step for each database. Each step goes on to the next step even if it fails because…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jul 18 2007 6:04AM=-=>

    I agree, that would be very helpful. In the interim, I run this query to monitor jobs. This query can easily be customized to retrieve specific job and instance info….so you could tie it in as the last step of a job and email the results.

    select name,server,step_name,message,run_date,run_time,run_duration from sysjobs j
    inner join msdb.dbo.sysjobhistory h on j.job_id = h.job_id
    where run_status = 0
    order by j.name,instance_id

    <=-=Jul 24 2007 1:23PM=-=>

    Thanks for the report. We’ll be investigating this for a future release.

    -Richard Waymire

    <=-=Oct 29 2008 4:23PM=-=>

    Hi,

    Your feedback make a lot of sense and we will consider it for the next release,

    Gil

  17. RS: support PDF with digital certificates

    In enterprise environments, there is more and more demand for "signed" PDF documents, that a signed/protected with a digital certificate.
    Depending on the local regulation, invoice documents have to be "signed" to be accepted by the tax authorities (e.g. Germany)

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow finer grain of control for database level permissions

    There are a number of database level command that can be executed but only if you are a db_owner. These permissions are implicit and cannot be explicitly granted or denies, unlike other database level permissions such as "backup database".

    This can cause several security issues. For example, if you have someone who uses DTS or SSIS for the data warehouse which is updatable and usually in full recovery mode, you would like to permit this person to be able to switch between bulk recovery and back to full recovery. Unfortunately the only way to allow this is to grant full…

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Mar 31 2008 2:44PM=-=>

    Hi Richard,

    Thank you for your feedback. We can’t make any changes to SQL Server 2008 but we will consider your request for a future release of SQL Server.

    Thanks,
    Il-Sung Lee.

    <=-=Feb 11 2013 2:23PM=-=>

    Hi Richard, Thank you for your feedback. We can’t make any changes to SQL Server 2008 but we will consider your request for a future release of SQL Server.

  19. Add flag to CREATE DATABASE command which specifies if data file should be zeroed out on create or on the fly.

    I think that an excellent addition to Microsoft SQL Server would be the ability for the CREATE DATABASE command to be able to specify if the physical files should be zeroed out at creation (aka SQL 2000 style) or on the fly (aka SQL 2005 style).

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Dec 13 2007 3:16PM=-=>

    Thanks for your suggestion.
    We are looking at more explicit methods for controlling file initialization.
    Likely this will take the form of an instance switch, since it impacts more than database creation (restore, grow, add file). The switch would be dynamic however.

    <=-=Dec 13 2007 6:03PM=-=>

    An instance level switch would be perfect.

    Thank you for looking into adding this into SQL Server.

    <=-=Dec 13 2007 6:08PM=-=>

    I was thinking with a create database flag so that you could have different databases setup to work different ways. Also I would assume that this way it wouldn’t to change able. (I would assume that you wouldn’t want to allow this to be changeable after database creation.) With a database instance I would assume that the setting would in some way be changeable which you probably wouldn’t want to be able to happen.

  20. Update multiple nodes / values in a XML column

    It would be a great enhancement if it is possible to update a XML column like this:

    UPDATE ERINOT
    SET Message.modify('
    replace value of

    ( (/Root/a)[1]/text()[1] ,
    (/Root/b)[1]/text()[1] ,
    (/Root/c)[1]/text()[1] )
    with
    ( "a", "b", "c")
    ')

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 6

    <=-=Jul 9 2007 4:56PM=-=>

    Dear Eric.

    Thanks for the feedback. This multi-update functionality is very useful, but at the moment we are waiting for the W3C update language specification to be finalized before we add such functionality. Once that has occurred, we will look into it. The current workarounds are to either change the whole parent tree or to do the updates individually.

    Best regards
    Michael

    <=-=Dec 9 2007 8:46PM=-=>

    or even this would be nice:
    SET x.modify('replace value of (/nodes/nodes[type=“dynamic”]/@type) with "static"’);

    —Peter

    <=-=Oct 18 2011 2:01PM=-=>

    Here’s some additional cases:

    — Modify statement chaining
    UPDATE e
    SET Message.modify(’
    replace value of
    ( (/Root/a)1/text()1 ,
    (/Root/b)1/text()1 ,
    (/Root/c)1/text()1 )
    with
    ( “a”, “b”, “c”)
    ‘).modify(’
    xml dml
    ’)
    FROM dbo.ERINOT e

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base