Regarding deprecated functions (more than a two-digit column name)

Question

The definition of obsolete functions (a more than two-digit column name) is that

In the list, a name of 3 or 4 parts was used. Modify the request to use standard two-digit names. Occurs once for compilation.

May I ask for an example for this function?

And since I have code that uses some sql server function, for example:

Select xml.Item.value('[something]', 'varchar(20)') AS something from xml

Does the element xml.Item.value (...) contain a name of 3 or 4 parts in the column list?

And since I just look at the repository procedures in my database manually to look for this deprecated function, is there another way (for example, a query) to find out these things in my database?

Thank you so much

Answer 1

( ):

• 1- : tablename (: (: dbo), : )

• : schemaname.tablename ( )

• : servername.schemaname.tablename

• 4 : linkedserver.servername.schemaname.tablename

xml.Item.value(...) 3 - value() - XML.

, , -

SELECT OBJECT_NAME,counter_name,instance_name AS 'Deprecated Feature',cntr_value AS 'Number of Times Used'
FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%:Deprecated%' AND cntr_value > 0
ORDER BY 'Number of Times Used' DESC

: Microsoft, , , - , .

: - . , / stored procedure, , - .