application_id scalar function returns the application id of the current connection. the data type of the result is varchar(128).
application_id标量函数返回当前连接的应用程序id。
listing 6 creates a scalar function that extracts a given xml element from an input document and shows how this function can be invoked in a simple sql query to return the name of a given customer.