View stream properties in SQL

Stream datatypes are not displayed when you execute SQL (in SMP for example).

The following query (SAMPLES namespace):

SELECT TOP 2 ID, Notes FROM Sample.Employee

Produces this output:

To get around that use SUBSTRING operator:

SELECT TOP 2 ID, SUBSTRING(Notes, 1) FROM Sample.Employee

It produces much more useful output:

To limit the length of the stream property  use three argument form:

SELECT TOP 10 ID, SUBSTRING(Notes, 1, 100) FROM Sample.Employee 

In this example only the first 100 characters from a stream would be returned.