Lab Sql

So I am getting the following error message from SQL Server when sp_SomeProc tries to execute an in… Read more Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File

I have created simple android tests with UiAutomator. In these tests I want to confirm that some da… Read more Cannot Connect To Sql Server Via Android Test

I need to have stored procedure where I can run multiple cursors. Loop over each cursor and then d… Read more How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

Here is what I have: 1) a simple sql file given to me that creates tables and fills them with data … Read more Creating A Simple User Interface To Access An Oracle Database

I'm working on a PHP MSSQL project that is using the sqlsrv driver. What's the best way to … Read more How To Sanitize Input With Php And The Sqlsrv Driver?

Possible Duplicate: SQL Data Transfer I have my Dev database, and some times I add some data to t… Read more Sql Transfer Data Between Databases Tsql

I need to order attribute names in alphabetic order and I've created following code, but it lef… Read more Order Attribute Names In Xml Using T-sql

I have the following table with values as CREATE TABLE stud ( sname NVARCHAR(10), hr… Read more Sql Pivot Table With Three Cross Tab And Multiple Columns Dynamically

App won't run - trying to execute query to print certain value Method: public Cursor trying(Str… Read more Method To Excute Query And Return Results

I'm using Microsoft SQL Svr Mgmt Studio 2008. I don't have access to create a temporary ta… Read more Sum A Union Query

What is the most elegant way to create a string of binary zeros, of type varbinary(max), if the len… Read more Create A Binary String Of Zeros, With Variable Length

I've a table named wp_bp_activity with many columns that I think I should work with 4 of them f… Read more Idea For Writing A Mysql Query

I have one table and want to use it as my input for a query pulling from another table: input table… Read more Take One Table As Input And Output Using Another Table Bigquery

Am trying to Fetch Only one record from the Sybase Table without using the RowCount Function, even … Read more Select Top 1 * From Table Fails In Sybase Procedure

Say I have a table with 100,000 User IDs (UserID is an int). When I run a query like SELECT COUNT(… Read more Higher Query Result With The Distinct Keyword?

Inside some web api controllers, I would like to access the User as indicated in this answer: https… Read more Acessing Username In Web Api Controller When Database Table Stores User As Integer

I've been wondering - I have a lot of use with sysdate on my system, and when comparing it to m… Read more Oracle - Get Current Date Formatted

When my IIS MVC4 Web App (running as my user) tries to connect to a named LocalDb Instance it fails… Read more Sqllocaldb Info Lists Two Instances With The Same Name

The code I was given for an SQL CLR project contains one function where the .net implementation is … Read more How Can I Get The Definition Of A Sql Clr Function From The Database

I am finding some problem trying to connect to a SQL Server instance from an Ubuntu machine using s… Read more Error Trying To Connect To A Sql Server Using Sqlcmd (from Ubuntu Command Line)?