Lab Sql

Table DISPLAY_TAB below is a self-reference table that can contain both parent and child tabs. A pa… Read more Cascade Delete In Many-to-many Self-reference Table

I'm using Entity Framework 5 to connect to SQL Server 2008. I've imported a stored procedur… Read more Entitycommandexecutionexception Timeout Expired Only Sometimes

I have a few columns in an SQL server 2008 R2 database that i need to convert from local time (the … Read more Sql Server: Convert Between Utc And Local Time Precisely

I am getting the error Could not parse rfc1738 URL from string 'MACHINE_IE' When I attem… Read more Sqlalchemy Issues With Foreign Keys

I have a custom data type called StudentID, which has an implicit conversion to string. When I pass… Read more How Should I Pass A User-defined Type To Sqlparametercollection.addwithvalue?

I'm getting this error in puTTY. Not sure why, looks right to me ... psql:pierre.sql:10: ERROR:… Read more Error With Auto_increment While Conneted To Postgres Via Psql And Putty

How does SQL Server determine whether a table column has low cardinality? The reason I ask is becau… Read more Sql Server 2005 Indexes And Low Cardinality

I'm trying to insert a data as a primary ID that has one alphanumerical value and two numerical… Read more Is There A Way To Insert An Auto-incremental Primary Id With A Prefix In Mysql Database?

I have a table in SQL Server 2008 that it has some columns. One of these columns is in Xml format a… Read more Updating Xml Attributes With New Values In A Sql Server 2008 Table

I have a object that contains data from a DB. The object has a ID, which in the DB is auto incremen… Read more Sqlite.net Output Parameter

I'm trying to get a regex to capture the base URL from a URL string. This ^(.+?[^\/:])(?=[?\/]|… Read more Why Won't This Regex Work In Postgresql

I installed SQL Server 2017 Developer Edition but its not starting any network server. There is not… Read more Sql Server 2017 Developer Edition Not Connectable

Trying to run Python3.2, SQLAlchemy0.8 and MySQL5.2 on Ubuntu using Eclispse but I keep getting the… Read more Sqlalchemy+pymysql Error: Sqlalchemy.util.queue.empty

I'm using this query to get some specific data: 'select * from emp where emp_name LIKE '… Read more How To Use Like Condition In Sql With Numeric Field?

Does anyone know why the following SqlAlchemy CASE statement fails with the following error message… Read more Sqlalchemy Case Statement: Valueerror: Too Many Values To Unpack (expected 2)

in Oracle SQL, there is a possible criteria called rownum. Can i confirm that rownum will be execut… Read more Oracle Sql Rownum Execution Order

Once we started to write data into an encrypted table, we noticed problems once we tried to read en… Read more Corrupted Data Using Always Encrypted In Sql Server

I am trying to parse JSON and pass the key-value pairs into a stored procedure. declare @json nvarc… Read more Pass Json_value Into Stored Procedure

I have a table called departments which consists of a column called salary. Now I want to have all … Read more First Two Salaries In Each Department

I have a table in hive , with 2 columns as col1 array and col2 array . Output is as shown below co… Read more Hive Sort Array Column With Respect To Other Array Column In Same Table