/* Starting with 12.1, you can apply the TABLE operators to associative arrays indexed by integer (index-by tables), whose types are declared in a package specification. You can then use the awesome ...

So we think SQL Server 2014 comes with in-memory OLTP built-in, and maybe Violin's 6000 arrays can take advantage of it to speed SQL processing by having Windows Server 2012 R2 booted on its internal ...

JSON_ARRAY constructs JSON array text from zero or more expressions. The JSON_ARRAY function uses the rules described in this FOR JSON article to convert SQL data types to JSON types in the JSON array ...

I've got a PL/SQL function that is generating a web page the users can use to manipulate the data in a spreadsheet-like environment.I need to pass this edited data back to the PL/SQL function to ...

Well, I need to get a median value for a set of numbers, from a query. To my surprise, Sql Server does not have a median function/sproc (well, if you install the analysis tools you do, but I can't ...

The success of SQL, NoSQL, and NewSQL databases is a reflection of their ability to provide significant functionality and performance benefits for specific domains, such as financial transactions, ...

In this article we will see how to pass an array of parameters to a stored procedure using xml. For illustration purpose we will be passing the below list of id's : Let us say we want to delete data ...

The success of SQL, NoSQL, and NewSQL databases is a reflection of their ability to provide significant functionality and performance benefits for specific domains, such as financial transactions, ...