comprasconencanto1

I'm having trouble with the following statement, which is returning the error 'Sequence con… Read more Help With Sql/linq Debugging

I am sorry if there is a duplicate but I tried all ways still I can't do the insertion. I have … Read more Mysql&msaccess: Insert Into Table Which Have An Incremented Field

Is there a way in NHibernate / QueryOver API to pass a parameter already in the mapping (so it uses… Read more Nhibernate / Queryover: How To Left Join With Parameter

I want to create a temp table in sql server by using Entity Framework. Is there any way I can do th… Read more Create Temp Table With Entity Framework

I'm trying to create a data import mechanism for a database that requires high availability to … Read more Bulk Inserts Of Heavily Indexed Child Items (sql Server 2008)

I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key i… Read more Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

My main query was solved at the following post TSQL - Get the difference between each row value I h… Read more The Difference Between Each Row Value - Sum Error

Can someone tell me what I am missing? I am using this connection string to connect to my database … Read more I Cannot Connect To Sql Server Express Using Vb.net

Question is a follow up to this. The SQL in question was UPDATE stats SET visits = (visits+1) And … Read more When It Comes To Updating All Rows In A Table, Does The Method Of Locking Matter For Performance?

I am using phpmyadmin 4.8.4 and have tried to export one of my tables as backup. I noticed that sq… Read more Why Has The Latest Phpmyadmin Dropped Sql As Export Format?

am using entity framework generally successfully, but one query is running remarkably slowly. The … Read more Sql Query Using Entity Framework Runs Slower, Uses Bad Query Plan

I am trying to find a way of converting HEX to a float in SQL Server. An example value is 0x42c8000… Read more Converting Hex To Float Sql

I am having difficulty inserting data with its related entities. public class Status : Entity, IAgg… Read more Entity Framework Insert Conflicts With Another Foreign Key

I'm doing collection of two columns(col & val). Into second select col is parameter of othe… Read more Looking Null Values For Different Oracle Type

Hi I use long time MS SQL and SQL Server Management Studio no I start with oracle and try some SQL … Read more Syntax Highlighting In Oracle Browser Something Like Sql Server Management Studio

I'm having a bit of a problem with using my sequence within a SELECT statement. SELECT c.… Read more Sequence Within Sql Select

The upsert works using on conflict but the datatype of id is serial meaning I want to have it auto-… Read more Upsert/on Conflict With Serial Primary Key

I want to connect from a COBOL/VMS system to an SQL Server 2005 instance. Could someone point me to… Read more Getting A Driver For Vms To Connect To Sql Server 2005

In my Django admin I have a TabularInLine class. In the picture, each element of this class is numb… Read more How To Enumerate New Column?

I am trying to declare a custom type of 'XMLType' for use with MSSQL. But I keep getting &#… Read more Sqlalchemy Declaring Custom Userdefinedtype For Xml In Mssql