Lab Sql

I am creating an Octopus deploy that installs a windows service on a remote server. I am re-using a… Read more What Do I Need To Execute A Sql Server Powershell Module

I have a two tables that are Subject and chapter. I need to display chapter_name by passing Subject… Read more How To Retrieve Value From The Sqlite Database?

I need SQL query for grouping by some category which would present quantities of only those groups … Read more Grouping Of Top 80% Categories

If I run this command in SSMS: set showplan_xml on GO exec some_procedure 'arg1', 'arg2… Read more Programatically Read Sql Server's Query Plan Suggested Indexes For A Specific Execution Of Sql?

I am relatively new to SQL so will try explain as best I can. All servers are SQL Server 2012 I cur… Read more An Error Occurred During Service Master Key Decryption

Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothi… Read more How To Correctly Filter A Datatable (datatable.select)

I need to format a string and pass it in as parameter for a SQL IN clause such as: Select * from T… Read more Formatting A String For A Sql In Clause

i have some question regarding about get data from database which need to fetch from past year ( dy… Read more Oracle - Get Data From Past Year (dynamic)

I guess it is too late and I'm too tired to see what I'm doing wrong. Here is what I'm … Read more Getting Scope_identity From Sql Server On Insert

Let's say I have two tables of books and two tables of their corresponding editions. I have a q… Read more How Can I Exclude Left Joined Tables From Top In Sql Server?

I'm trying to move data from a datalake stored in Azure Data Lake Storage Gen1 to a table in an… Read more Data Factory New Linked Service Connection Failure Acl And Firewall Rule

i am having trouble stuffing the date and time for the same item in SQL sever. Below are three simp… Read more How To Stuff Date And Time In Sql

is there any way how to write the following SQL statement in SQLAlchemy ORM: SELECT AVG(a1) FROM (S… Read more Sqlalchemy Subquery - Average Of Sums

Does the documentation quotation from this answer: https://stackoverflow.com/a/542691/1011724 When… Read more Does Linq2sql Automatically Put Executecommand In A Transaction

I am difficult to understand why the mssql.anggalisdiyanto.net domain is can be accessed and i can … Read more Cannot Connect To Plesk V12 Sql Server Remotely From Sql Server Management Studio

How can I get the type of each column in a SQL Server table or view using Entity Framework? I nee… Read more How Can I Get Data Type Of Each Column In A Sql Server Table/view Etc. Using C# Entity Framework?

I have a table like this to save the results of a medical checkup and the date of the report sent a… Read more Postgresql: How To Combine Multiple Rows?

I am currently working on a database project and have some issues with joining tables. The initial … Read more Sql: After Joining Tables Sum() Function Returns Wrong Value

INSERT INTO Countries (Country, Capital, Cities) VALUES ('Philippines','Manila',122… Read more Livesql Keeps Showing Me This: Ora-00933: Sql Command Not Properly Ended

We're using a SQL Server CE database. I understand that there are limitations to the types of t… Read more Why Does Sql Server Ce Not Allow This Trigger To Fire?

I have a table with a column Name that can contain substring surrounding with quotations ...'su… Read more Replacing First Occurrence Of Character With One Character And The Second With Another Character In Sql

I am a little confused as to how to approach this SQL query. I have two tables (equal number of rec… Read more Sql Select Across Two Tables

I am doing one WPF application and trying deploy/publish it. As long as i run the application withi… Read more Unable To Load Dll Sqlite Interop Dll Wpf

ASPNET MVC5 web app, Visual Studio 2015 The website is language localized, so I need to get localiz… Read more Linq Query Leading To Invalid Column Name Sqlexception

I have the following codes. Im using Django and using raw SQL statement to send data to my template… Read more Can Anyone Help Me With This Template That Is Getting The Weird Value In My Textbox

I am facing a problem for past two days with regard to the date format in SQL. I have developed a a… Read more Date Formats Mismatch Between Different Servers (xml Column)

This is not query related, what I would like to know is if it's possible to have a field in a c… Read more Sql Field As Sum Of Other Fields

I am able to successfully connect from access 2007 into SQL Server 2008 using ODBC; however it prom… Read more Sql Server 2008: Odbc Connection Problems

I am trying to Insert data into Database, but getting problem, error says: android.database.sqlite.… Read more Android.database.sqlite.sqlitedatatypemismatchexception: Datatype Mismatch (code 20)

I have a table having structure as follows id cust_id target month year fiscal_ID 1 234 50 … Read more Quarter Year Wise Result Filteration In Sql

I trying to connect my database using C# code, but getting a KeyNotFoundException when the debugger… Read more What May Cause The Keynotfoundexception When Trying To Open A Mysql Connection

I have a lot of difficulties in trying to translate this SQL query to a DQL one (I am using Symfony… Read more How To Translate This Sql Query To Dql?

Possible Duplicate: ROW_NUMBER() without over in SQL I have a grid with sorting on each column an… Read more Need To Use Row_number Without Over In Sqlserver 2005

I need to select pairs of rows from a table that meet certain criteria. Here's an SQL fiddle th… Read more Optimize Mysql Self Join Query

I've a database containing a table for products order like this: order_id | prod_code | prod_co… Read more Sqlite - Transposing Rows Into Columns Properly

I am having issue deploying SSAS package to SQL Server Analysis. It is complaining of duplicates ke… Read more Error In Deploying Ssas Cube To Sql Server Analysis

In order to investigate query plan usage I'm trying to understand what kind of query plan is st… Read more Sql Server 2008 Plan Cache Is Almost Always Empty

For example, in a table I have created called 'likes', there are three fields: id (irreleva… Read more How To Find The Highest Number Of Times A Value Is In Records?

I logged into SQL Server 2008 via SQL Server Management Studio using Windows admin account. When I … Read more Sql Server 2008 Enable Sa Account

A SQL Server Project in Visual Studio 2015 with stored procedures that use the phrase AT TIME ZONE … Read more Unable To Build Sql Server Project Because Of At Time Zone

I have a SQL query, that returns a set of rows: SELECT id, name FROM users where group = 2 I need … Read more Sqlserver Sql Query With A Row Counter

This has me stumped. I am trying to set encoding for my Sqlserver connection and all that I have tr… Read more Cakephp Sqlserver Encoding

I have table like this: And I want to short the data based on ParentID that refer to ID. So, if th… Read more Order By Sql Query Based On Value Another Column

I get this error when using linq-to-sql with timestamp as part of a composite primary key: 'The… Read more Timestamp As Part Of Composite Primary Key?

DB-Fiddle CREATE TABLE customers ( id SERIAL PRIMARY KEY, order_date DATE, country VARC… Read more Assign A Certain Country To All Orders Of A User If The User Placed At Least One Order In A Specific Other Country

i am working on project where user have database with date stored in normal format 8 March 2013 and… Read more Change Time Format In Mysql Query Order By

Using the JOOQ parser API, I'm able to parse the following query and get the parameters map fro… Read more Get Table/column Metadata From Jooq Parser Result

General explanation: my query 2_Total returns a single value: Run the VBA function that exports … Read more Ms Access Openredcordset Reading Wrong String

I am a complete beginner in the coding World and I am trying to use IText to generate PDF from my A… Read more Show Result From An Sqlite Database In Pdf Using Itext

Table1 Date v1 05/01/2010 26 05/02/2010 31 05/03/2010 50 Table2 Date … Read more How To Join Two Tables

I have a table with the number of trips taken and a station_id, and I want to return the 5 most rec… Read more Returning 5 Most Recent Trips Per Id

Using the provided table I would like to randomly sample users per day. The number of users to be s… Read more Sampling Without Replacement With A Different Sample Size Per Group In Sql

which is more efficient in sql min or top? select MIN(salary) from ABC select top 1 salary from ABC… Read more Which Is More Efficient In Sql Min Or Top

Is there an OR sqlite statement? I've been trying to google it, but google seems to be filterin… Read more Python: Sqlite Or Statement

I am getting this error when I try to register a user etc: Invalid object name 'dbo.AspNetUser… Read more Local Works. Azure Give Error: Invalid Object Name 'dbo.aspnetusers'. Why?

i am trying to create an editable grid with jqgrid - however I cant get the data to save to the dat… Read more Jqgrid Not Saving Data To Database

After asking about calculate the sum of the total price here and Its work but then went I add(SUM(… Read more Calculate Sum Of Price From 2 Table Sql Server

This is a follow up on the other question I asked. Quarter Segment Customer *Counter* … Read more Sql: Gaps And Island Problem - Date Not Consecutive Causing Rank Inaccurate

I hava SqlServer 2008 db server, And I use spring boot + jpa(hibernate) to access database. I have… Read more Hibernate @column Annotation Not Work

I'm seeing an issue with an SSIS (SQL Server 2005) job where I'm getting the following erro… Read more Ssis Connection Error - File Name Not Valid