UFN_TABCAPTIONCOUNTSUFFIX
Formats a number for appending onto a tab caption to indicate the number of records on that tab.
Return
| Return Type |
|---|
| nvarchar(13) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COUNT | int | IN |
Definition
Copy
CREATE function dbo.UFN_TABCAPTIONCOUNTSUFFIX(@COUNT int)
returns nvarchar(13)
with execute as caller
as begin
if @COUNT>0
return ' (' + convert(nvarchar(10),@COUNT) + ')';
return '';
end