Lab Sql

I have one problem while retrieveing value from mysql using codeigniter. I have one table name task… Read more Retrieve And Print Values After Comma Separator From Single Field Using Join (codeigniter)

I have two tables one named Person, which contains columns ID and Name and the second one, named Re… Read more Sql Join 2 Tables

I have a small database originally developed using SQLite. My desktop application automatically set… Read more How To Create Foreign Keys For Non-existent Table During Initial Database Setup?

how to combine 2 different tables where they contain the same fields but different data, example Ca… Read more How To Combine 2 Different Table?

Suppose i have a one parameter stored procedure : procedure dbo.MyStoredProc @param VARCHAR(50) as … Read more Sql Stored Proc And Entity Framework 6

I am trying to test out three variations of a query that is ran from an Excel data connection. I ha… Read more Excel Odbc Data Connection Query Time Taken To Refresh Each Query

DECLARE @step VARCHAR(25) = '15'; DECLARE @COL VARCHAR(50) = step_col_@step; UPDATE table_t… Read more Mapping Dynamic Column Names In Sql Server

After uninstalling an Oracle 10 client / security patch (don't know what triggerd it) I'm h… Read more Ssrs 401.3 Error Access Denied Due To Access Control Lists

Is there a way that you can have SERVEROUTPUT set to ON in sqlplus but somehow repress the message … Read more How Do I Suppress "pl/sql Procedure Successfully Completed" Message In Sqlplus?

SELECT Name, ( NOT (ID_ListGroupParIzm IN (SELECT ID_Param … Read more Sql [hard Query - To Make Or To Avoid]

I'd like to know your experience(s) with replacing SQL Server cursors in existing code, or how … Read more What Are The Different Ways To Replace A Cursor?

I have a fairly basic flask set up (been coding using sublime text). For testing purposes, I am now… Read more Flask: Results Of The Query Is Not Being Displayed On The Webpage Using Jinja (user_data)

want to convert character format (00001000000) as 10000.00. Please help me. I've already tried … Read more Want To Convert From Character Format To Number Format With Decimal

Does anyone have a sample code that given the database file displays the names of all the user tabl… Read more Raw C++ Code To Display The Names Of Tables In An Sql Compact Server Using Ole Db

I need to have each level be the sum of all children (in the hierarchy) in addition to any values s… Read more Sum Of Child Levels Total In A Hierarchy

So I inserted few records in a table manually (without using Stored procedure) and rows were fine u… Read more How To Delete Records From A Column Which Belong To A Different Data Type?

I need a cursor for the below query so I can loop through to fetch/update/insert some other data. C… Read more Using A Cursor With A Cte

I would like to use data from SQL server in Pycharm using python. I have my database connection set… Read more Python Pycharm And Sql Server Connection

I have created register form using php and jquery. I need to store input details to sql database. I… Read more How To Store Data In Sql Database In Php

This is a new question which arose out of this question Due to answers, the nature of the question … Read more Should These Be 3 Sql Tables Or One?