Hot answers tagged freetds
If you're on SQL Server 2008 R2, I'd recommend taking a look at the Open Data Protocol (also known as OData). Microsoft has some FAQs on it as well, and there is a Java client library available. Also take a look at sqlREST, which exposes relational databases using web services and works with most databases that have a JDBC driver.
I have seen this before. According to the Sybase ASE Documentation: Adaptive Server Enterprise implements dynamic SQL using temporary stored procedures. A temporary stored procedure is created when a SQL statement is prepared, and destroyed when that prepared statement is deallocated...[a]s a consequence of this implementation, an application accessing ...
I suspect the one of the values is NULL, so the whole expression concatenation is NULL. You'd need this: CAST(ISNULL(PageGuid, '') as varchar(max)) + ',' + CAST(ISNULL(TenantGuid, '') as varchar(max)) + '/' + CAST(ISNULL(OriginalFileGuid, '') as varchar(max))
Background From wikipedia RESTful API REST was initially described in the context of HTTP, but is not limited to that protocol. RESTful architectures can be based on other Application Layer protocols if they already provide a rich and uniform vocabulary for applications based on the transfer of meaningful representational state. RESTful ...
Only top voted, non community-wiki answers of a minimum length are eligible