Lab Sql

I need a function to convert mathematical expressions to a float value: create function dbo.Express… Read more Sql Function For Converting String Expression To Proper Value

Normaly, this code working very well. But, if 'cursor' is empty, there is an error in main.… Read more Sqlite Empty Cursor Error?

I have one source table that should be converted to one destination table. The source table contain… Read more Splitting One Row Into More Rows -- Table Transformation

Here's the structure of a query I came across: MERGE INTO TABLE t USING (SELECT ? id, ? email, … Read more How Does Oracle Select From Dual Work With Multiple Fields

I am very new to SSIS and I am building a package which will import files. I have a Execute SQL Tas… Read more Execute Data Flow Task Based On Condition In Ssis

I don't understand correctly how pivot is working with MSSQL, and I'm not able to apply piv… Read more Mssql 2012 : Pivot Typologies And Dates Using Php

I have a vector with table names: table_names Solution 1: It's often best to use lapply and k… Read more How To Query Tables With For Loop In R?

I need to fetch key value pairs from the second object in array. Also, need to create new columns w… Read more Fetch The Data From Array Of Objects Sql Bigquery

How would I continue the while loop after an exception has been raised in the code below? DECLARE … Read more How To Continue While Loop After Exception Raised In Sql

My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 - DTS to SSIS but I have a few … Read more Upgrading Dts Packages To Ssis Packages

i have tried lot to connect database using PHP PDO. i have got lot of samples, i am not sure what w… Read more How To Connect A Sqlite Database Using Php?

I have three tables in my database. A table for Product, a table for Types and a mapping table name… Read more Use Stuff With Inner Join Query

Im currently working on a Flask Application with MySQL / SQLAlchemy. I am trying to dockerize it bu… Read more Docker Error 2002 Sqlalchemy

I am working on an SSIS package that loads data from a CSV file into a staging table in SQL Server.… Read more Get Filename Of Timestamped Csv Using C# Script In Ssis

Edit: This question was flagged as a duplicate, but it is not. The other answers on SO show how t… Read more Search All Tables In All Databases On Server For A String

Using SQL Server 2000 Developer Edition, why would this code: select top 10 * from table result in… Read more Sql Server 2000 "select Is Broken" With Top Clause

I'm using SQL Server 2008. I'm creating a DDL trigger like this: CREATE TRIGGER tName ON … Read more Sql Server : Ddl Trigger, Controlling Table Creation

I have an app where i am trying to update a row in the Transactions table in my DB. Here's the … Read more Android Row Not Updating In Sqlite Db

I have a SQL query select to_char(cast(sysdate as timestamp with LOCAL time zone), 'YYYY-MM-DD,… Read more Display Time Zone Description In To_char() In Oracle

I have 3 different tables for a blog I am working with. 1st table: blog_posts, it has an ID, Title,… Read more Get All Posts That Have A Specific Tag And Keep All Other Tags On Results With Sql