How can we help you today? How can we help you today?

Variable is declared but never used - Issue

Hi,

The following SQL gives Issue code: MI005 for @date.

declare @date date = getdate()
declare @xml xml = '<root/>'
set @xml.modify('insert attribute testDate {sql:variable("@date")} into (root)[1]');
select @xml

Is this a bug or am I missing something?

Version - 10.12.5.30313

Thanks,

Dave.
ddowdell
0

Comments

3 comments

Sort by
  • DustinM
    Hi Dave,

    Thank you for your inquiry into SQL Prompt and for bringing this to our attention.

    I was able to recreate this on my end and will escalate it to our dev team to take a look.

    Best,

    Dustin
    DustinM
    0
  • DustinM

    Hi Dave,

    Thank you for your patience with us regarding this issue.

    Our development team has now reviewed the bug you have identified and highlighted it to us alongside our current workload and available resources. Unfortunately, on this occasion, this is not something they are able to provide a fix for.

    We do appreciate the effort our customers go to working with us to better our products, so please continue to highlight anything you find that needs our attention.

    Best,

    Dustin

    DustinM
    0
  • TrevorMcComb
    I have a similar issue.


    Version 10.16.2.14461

    Regards Trevor
    TrevorMcComb
    0

Add comment

Please sign in to leave a comment.