<div>
SELECT &nbsp;a.name +'|'+ ISNULL(b.mirroring_role,'N<wbr />ULL')
</div>


SELECT  a.name +'|'+ ISNULL(b.mirroring_role,'NULL')

<div>
But if mirroring_role is not null, is that query will run successfully?<br />
<br />
Thanks<br />
<br />
bibi
</div>


But if mirroring_role is not null, is that query will run successfully?

Thanks

bibi

<div>
I try to execute it and there is an error :<br />
Conversion failed when converting the varchar value 'NULL' to data type tinyint.
</div>


I try to execute it and there is an error :
Conversion failed when converting the varchar value 'NULL' to data type tinyint.

<div>
Is mirroringrole a tinyint field? If so, you need to use:<br />
SELECT &nbsp;a.name +'|'+ ISNULL(CAST(b.mirroring_ro<wbr />le AS varchar(15)),'NULL')<br />
<br />
the ISNULL function will simply provide an alternative value if the record is null. If it isn't null, it will use the first argument of the function.<br />
So, ISNULL('value','NULL') will return 'value', but ISNULL(NULL,'NULL') will return 'NULL'
</div>


Is mirroringrole a tinyint field? If so, you need to use:
SELECT  a.name +'|'+ ISNULL(CAST(b.mirroring_role AS varchar(15)),'NULL')

the ISNULL function will simply provide an alternative value if the record is null. If it isn't null, it will use the first argument of the function.
So, ISNULL('value','NULL') will return 'value', but ISNULL(NULL,'NULL') will return 'NULL'

<div>
or use<br />
<br />
SELECT &nbsp;a.name +'|'+ isnull(CAST(b.mirroring_ro<wbr />le AS varchar(15)),'') ...
</div>


or use

SELECT  a.name +'|'+ isnull(CAST(b.mirroring_role AS varchar(15)),'') ...

<div>
after reading the question, I see that you want 'NULL' instead of ''<br />
so try my posts with 'NULL' instead of ''
</div>


after reading the question, I see that you want 'NULL' instead of ''
so try my posts with 'NULL' instead of ''

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I try to execute this command :<br />
<br />
SELECT &nbsp;a.name +'|'+ CAST(b.mirroring_role AS varchar(15))FROM sys.databases A INNER JOIN sys.database_mirroring B &nbsp;ON A.database_id=B.database_i<wbr />d &nbsp;WHERE mirroring_role is null or mirroring_role=1<br />
<br />
but the result is NULL, how can I add the name master|null.<br />
<br />
Thanks<br />
<br />
Regards<br />
<br />
bibi
</div>
</div>


Hello,

I try to execute this command :

SELECT  a.name +'|'+ CAST(b.mirroring_role AS varchar(15))FROM sys.databases A INNER JOIN sys.database_mirroring B  ON A.database_id=B.database_id  WHERE mirroring_role is null or mirroring_role=1

but the result is NULL, how can I add the name master|null.

Thanks

Regards

bibi

error on cast command

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.