Lab Sql

I am getting the error from the application as following with SQL server 2005 'Transaction co… Read more Transaction Count After EXECUTE Indicates That A COMMIT Or ROLLBACK TRANSACTION Statement Is Missing - SQL Server 2005

I have Oracle query: SELECT index_name, table_name FROM user_indexes; Since user_indexes is Oracle… Read more Oracle User_indexes Translation To MySQL

I have an Excel source going into an OLE DB destination. I'm inserting data into a view that h… Read more SSIS: "Failure Inserting Into The Read-only Column "

Some of the scripts were migrate manually without using readyroll script. Now any new push to dev b… Read more Readyroll : Getting Error While Build Using VSTS : Drift Analysis: These Changes Will NOT Be Applied Because DriftOptionBlockDataLoss=True

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

I'm trying to figure out how to get id value into database in an auto increment way, i.e it set… Read more Auto Incrementing 'id' Value When Inserting Into Sqlite

I was trying to store the url on button click using the following code.There were no error but the … Read more Storing The Url In SQLSERVER 2005 Using C# Code(data Sets)

I have one table(could only have one) that looks like seen below. It contains a plant code, an arti… Read more Self Join Issue, I Think?

I can't pull up my tables so I can use them in my stored procedure. Any reason why they aren… Read more Why Are My Tables Not Showing Up In SQL Server Management Studio's Intellisense?

I've read other answers on how to detect whether the SQLite database is locked, and it suggests… Read more Determine Whether SQLite Database Is Locked

This is an extension of a question I posed yesterday: How to handle potential data loss when perfor… Read more How To Compare Two Columns With Different Data Type Groups

The user id on your connection string is not a variable and is different from the user id (can be G… Read more What's The Best Way To Audit Log DELETEs?

Could somebody please offer some assistance. I have a standard SQL command as follows $SQL = 'S… Read more SQL Command Based On PHP Strstr Or LIKE

I want to create trigger which after insert longitude and latitude to table Vehicle create point f… Read more How To Do Trigger Which Create A Point After Insert Longitude And Latitude?

I have a select from (nothing to complex) Select * from VIEW This view has about 6000 records and … Read more SQL Query Takes About 10 - 20 Minutes

About 2 weeks ago some SQL that has been working for the past 6 months started throwing an error wi… Read more Invalid Length Parameter Passed To The RIGHT Function

How to get the rows that have a datetime column with Solution 1: This works thanks to JULIANDAY… Read more Sqlite Datetime Hour Difference

I am getting below error when using mssql object in script as: var mssql =request.services.mssql; … Read more Why The Mssql Object Can Not Be Identified?

I am trying to copy data from one database to another using ssis. I created the dtsx package with t… Read more SSIS - Auto Increment Field Is Not Inserted Correctly With Data Flow Task

I made this query but I'm not sure if there's a way not to use native query. I need to find… Read more Usage Of JPA In SpringBoot

Hi Guys I am trying to understand how to save and edited row to the database private void BudgetGri… Read more Updating DATAGRID Row To Save To SQL

Is there any way to link tables from SQL Server to Access as read-only? There's too much data … Read more MS Access: Read-only Linked Tables From SQL Server?

How can I write a SQL statement to select data from three tables? Solution 1: Use a join SELEC… Read more Select Data From Three Tables?

Actually I m trying to pass a huge Xml to my stored procedure, but I always get an out of memory ex… Read more Best Way To Pass A Huge Xml Parameter To Stored Procedure

In SQLite for iOS (3.7.7) I am running these queries: PRAGMA foreign_keys = ON; create table venue… Read more ON DELETE CASCADE Not Working In SQLite

Take the following example... Using cn As New SqlConnection(ConnectionString) T… Read more SqlCommand (Using Statement / Disposing Issue)

I have an application which connects to SQL Server 2000 (using a generic SQL Login and SQL Authenti… Read more How To Obtain Domain User Name When Connecting Via SQL Authentication

I want to show SQL data from a local db-File in a QML-Tableview and than would like to do some edit… Read more Subclassing QSqlTableModel Insert New Value

I`ve written some code to establish a connection to SQL Server, then execute select procedure to ta… Read more C# InvalidOperationException When Creating A New SqlDataAdapter

I'm querying a datetime (dd/mm/YYYY hh:mm:ss) value from a database and inserting it in a list … Read more C# Convert Datetime To Custom Format

Hi so Im creating a job application management system. in the backend the admin needs to be able to… Read more Distinguish Duplicates In A Foreach Loop From Sql

I've two tables A and B. Table A is the source and B is the target. Based on some conditions, I… Read more Using Merge In SQL Server To Update A Third Table