Lab Sql

I've been using Cordova and the storage adapter for SQLite. When I store objects using JSON.str… Read more Issue Storing Arrays In Sqlite Using Javascript

I'm having a problem moving from a situation where an Outer Join works, to where it fails. Work… Read more Multi Table Joins - Can I Add An Outer Join To This?

I would like to take the Getdate() results of, for example 2011-10-05 11:26:55.000 into 11:26:55… Read more Get Time From Getdate()

Trying to connect my java web application with MS-SQL server using sqljdbc41 for jdk 1.8. Here is t… Read more This Driver Is Not Configured For Integrated Authentication

I wish to use an SQL database that it already in use on my network, so I have written code to overr… Read more Overriding Validateuser() With Sqlmembershipprovider And Custom Sql Database

I am getting ORA-30926: unable to get a stable set of rows in the source tables in the following… Read more Ora-30926: Unable To Get A Stable Set Of Rows In The Source Tables

While renaming the column name, the square bracket is included in the column name, which I think is… Read more Is This A Problem In The Sp_rename Function Or Sql Server Itself?

Must declare the scalar variable '@Id' SqlConnection con = new SqlConnection(@'connect… Read more "must Declare Scalar Variable" Error

In my SQL query I am selecting data with GROUP BY and ORDER BY clauses. The table has the same numb… Read more Mysql - Using Group By And Desc

Is there a way to bind an event to Sql Server (specially Azure) so that, when there's new data … Read more Is There A Way To Be Notified In .net When Data Changes In The Sql Server? Like An Event?

I would like to convert this SELECT-ENDSELECT into FOR ALL ENTRIES to have better performance. LOOP… Read more Convert Select-endselect In For All Entries With More Table

For background info, I'm running .NET core on Arch Linux VScode and I also have SQL Server runn… Read more Getting An Sql Connection String Error When Scaffolding In Ef Core?

I'm in the process of learning a more complex SQL Server 2008 techniques so I apologize in adva… Read more T-sql Compound Statement Causes The Deadlock, Any Idea Why?

I have a SQL query that I want to map to a class. I'm using Hibernate's createSQLQuery and… Read more Hibernate Result Transformer Cannot Instantiate Resultclass

I've done this before in .Net but I am somewhat new to PHP and could use some help. I'm tr… Read more Retrieve Greek Letters From Mssql Database With Php

I am new to mysql. I have a problem in inserting record to table1 if it does not exist in table2.I … Read more How To Insert Into Table 1 If Not Exists In Table2?

I have a VARBINARY(MAX) field in a database table which contains ~35k characters. This field is a c… Read more Copying A Large Field (varbinary(max)) To File / Clipboard

I am trying to read in a text file from an SQL query (SQL Server 2005) but am not having any luck a… Read more Reading A Text File With Sql Server

This question is continuation of the following question: How do I convert this Access Query to mySQ… Read more How Do I Convert This Access Query To Mysql Query

I am attempting to count the maximum number of continuous months in a table across multiple rows of… Read more Count Maximum Continuous Months Across Multiple Rows

SELECT CCDMS_Company.CompanyID, CCDMS_Company.CompanyName, CCDMS_Container.ContainerID, CC… Read more Msg 156, Level 15, State 1, Line 22 Incorrect Syntax Near The Keyword 'having'

Here is the generated T-SQL from LINQ SELECT [Extent1].[ID] AS [ID], [Extent1].[Name] AS … Read more Sql Server Where Clause Equals Instead Of In

I would like to know what could be best approach to open a SqlConnection with Sql Server 2008R2 Exp… Read more What Is Best Approach For Opening/closing Sqlconnection In C#

I know its quite challenging, Is there any sql specialist please kindly help me to solve this. I H… Read more How To Get Recursivelevel Using Sql Server 2012 Hierarchyid?

Is it possible to export data into an excel sheet without the heading? I know SET HEAD OFF works in… Read more Query In Excel Without Heading - Oracle

I want to create a function in SQL Server which takes a comma separated string a parameter, splits … Read more How To Create A Sql Function Which Splits Comma Separated Value?

Given the following. Products_Joined.METATAG_Keywords AS Keyword, This returns this for 'keywo… Read more Sql Split Field By Comma Delimiter

I have the following problem in my application which connects to an Oracle 10g database: When my cl… Read more Oracle: How To Detect Client Process Termination Like It Works For Sqlplus?

I have 40+ columns in my table and i have to add few more fields like, current city, hometown, scho… Read more Mysql Table With 40+ Columns

I have a table containing each a start and and end date: DROP TABLE temp_period; CREATE TABLE publ… Read more Exclude Overlapping Periods In Time Aggregate Function

here is the error that came up after attempting to execute my website. This is related to my previo… Read more Specified Cast Is Not Valid Error Using Asp.net?

Consider the following table: create table language ( id integer generated always as identity (… Read more Insert, And Get The Auto-incremented Value

Possible Duplicate: how do find the number of rows in a table when the table name is in a variable?… Read more Use A Variable For Table Name

I need to implement a check to see if TableA exists, if it does, drop the entire table. If it doesn… Read more Vba Script To Check If Table Exist On Ms Access, Delete If It Does

At the start of ETL package the following SQL query runs against a SQL Server 2012 database: IF OBJ… Read more Why Does A Global Temp Table Created By An Ssis Package Disappear After Completion?

I use SQL Server 2012 and I have some databases on it. The problem is I suddenly get an error sayin… Read more Sql Server 2012 Error: Object Reference Not Set To An Instance Of An Object

How do I modify the following query to delete all posts with the custom post type 'listings'… Read more Wordpress Delete Posts Not In Specific Categories Using Wpdb Query

This is a follow up to the question Nested stored procedures containing TRY CATCH ROLLBACK pattern?… Read more Recording Sql Server Call Stack When Reporting Errors

I am a little new to cakephp 3 and i am trying to figure out how you call this simple model/table i… Read more Database Views And Models Being Called In My Controller

What's the best way to query a total price? I want to multiply several rows of data by a certai… Read more Mysql Query - 'cast' ' Concat' - How To Multiply Several Rows Of Data By A Certain Amount And Display Their Individual Totals In A New Column In £'s?

I am joining quite a bit of data together, but i need to pivot that data and then select the fields… Read more Sql Flatten, Pivot, And Query

How to change my query so that this error doesn't happen: XML data type method “value” must b… Read more Xml Data Type Method “value” Must Be A String Literal

I'm developing a web application that grabs a website RSS feed and save it into a database, usi… Read more How To Check If Data Already Exists Before Inserting On A Table On Html5 Javascript Sqlite?

This is my table tblEmployee ,when I'm trying to use a self join query it's result is varyi… Read more Not Quite Understanding The Query After Just Shifting Column Names

So I'm building a windows app, and as a result, I'm going to use SQL Server Compact instead… Read more How Do I Populate A Sql Server Compact Database?

I notice that when I query dbo.sysobjects, to determine all the objects in my database, it also pic… Read more Sql Server - Querying Sysobjects

I currently have a 'Filter' object which corresponds to a business object. This object has… Read more Alternative To Executing Dynamic Sql

I am making a web application that involves being able to grab specific computer logs from multiple… Read more Specific Caching Scenario For Web Application

My Projects has c++ dll in which a db is created in Sqllite with share deny = none . This dll will … Read more Lock A Sqlite Database For Reading From C#

I am a digital marketing manager and am trying to breakdown my campaigns for sliced analysis. My ca… Read more "split_part" To Structure A Column Into A Table?

I have got two tables as following Table Person Id Name 1 A 2 B 3 C 4 D … Read more Find Top Level Parent And With Recursive Cte

I want something like paste command in unix, it takes two files and prints first line, of first fil… Read more Mysql "paste" Two Results Together (side By Side)