Lab Sql

Edited: I have added login details to a demo SQL Server 2017. I am querying an SQL Server from R us… Read more Querying Sql Server Geospatial Data From R

I have a object with a byte[] property, and I would like to convert this value to the correct value… Read more How Convert A Byte[] To A Data To Insert A Value In A Varbinary(max) Column In Sql Server?

Simple question I couldn't figure out (not a SQL expert... sorry): I want to do a select on the… Read more Sql: How To Predicate Over Stored Procedure's Result Sets?

I have a string: @string='TEST RESULTS\TEST 1\RESULT 1 The string/text remains the same except … Read more How To Extract Numbers From A String Using Tsql

I have a query that looks like this: SELECT count(*) ,date_format(created, '%d/%m/%y … Read more Find Missing Date And Add Them Into Result - Mysql

I am trying to populate some columns in an INSERT statement, but I am trying to use multiple select… Read more Insert Statement With Sub Queries

I have SELECT: SELECT c FROM ( SELECT 'candidate_id' as id, count('candidate_id'… Read more Get 0 Value From A Count With No Rows

Can anyone point me towards a sorting algorithm in javascript that would sort the same way SQL Serv… Read more Javascript Sorting To Match Sql Server Sorting

mysql> EXPLAIN SELECT * FROM urls ORDER BY RAND() LIMIT 1; +----+-------------+-------+------+--… Read more How Do I Select A Random Record Efficiently In Mysql?

I currently have a tabllix in SSRS with multiple rows, but I wish to only display the top 5 rows, y… Read more Ssrs Display Top N But Have Sum Include All Values

I have a stored procedure that returns XML raw data FOR XML RAW something like the following format… Read more Xml Raw Data Returned From Sql Server 2005 Not Correct When Calling From .net

I'm using SSEUtil to automatically create a functional test database from the schema derived fr… Read more Sql Error: "cannot Use Full-text Search In User Instance."

How do I rank salespeople by # customers grouped by department (with ties included)? For example, g… Read more Use Access Sql To Do A Grouped Ranking

Trying to debug a customer's connection problem when they try specifying the SQL Server port. R… Read more "login Failed For User" When Specifying Default Port

In Azure, how can you configure an alert or notification when a SQL Server failover happened if you… Read more In Azure, How Can You Configure An Alert Or Notification When A Sql Server Failover Happened?

Hi this is my code List listA = new ArrayList (0); String[] arrA = new String[100]; listA.add('… Read more Java.sql.sqlexception: Fail To Convert To Internal Representation: While Passing Arraylist To Oracle.sql.array

I'm running python 2.7.3 which I manually installed in my home directory as I don't have ro… Read more Python: Sqlalchemy Importerror: No Module Named Pysqlite2

I have a MSSQL query for point table of all matches of this season. The database consists of one t… Read more Sql Soccer Points Table Last 5 Matches

I need to Join 2 tables but there is not a true common field. In Table A the ID field contains the … Read more Joining 2 Tables Using A Wildcard

Running SQL 2005 X64. First, create the following stored proc on a database: CREATE PROCEDURE dbo.… Read more What Leads To This Strange Sql Behavior?