stiellledm310

Ok, when I create a sql server CE .sdf database in the new Webmatrix 3 I run into a problem. I'… Read more Webmatrix 3 Sql Server Ce 4 Busted?

I am using FMDB, which is a wrapper for SQLite. http://github.com/ccgus/fmdb Here is my query line:… Read more Fmdb Query Isn't Acting Right With Like

I have two tables table1 table2 Tabel1 contains 2 columns id Name Tabel2 contains 2 columns id… Read more How To Add A Column To A Table From Another Table In Mysql?

I'm executing this code in python from sqlite3 import dbapi2 as sqlite con = sqlite.connect(&#… Read more Sql Statement With Like From Variable

I am trying to call a udf (SQL server) from Vb code in access. Connection to DB was successful and … Read more Calling A Udf (sql Server) From Vb Access "undefined Function In Expression"

Declaring private List messages = new ArrayList (); privare MessagesAdapter mAdapter; private Recy… Read more Notifydatasetchanged Not Working While Retrieving Sqlite Data

Possible Duplicate: C# Update Table using SqlCommand.Parameters I'm trying to update an SQL S… Read more C# Update Table Using Sqlcommand.parameters Asp.net

I need to return two fields from a database concatenated as 'field1-field2'. The second fi… Read more Most Efficient Method For Adding Leading 0's To An Int In Sql

I'm getting this error when I'm trying to get a readable or writable database. 'SQLiteC… Read more Sqlitecantopendatabaseexception: Unknown Error (code 14) Could Not Open Database

Working on 10g. I am writing a query to sort a list, and sorting is an important aspect of the list… Read more Convert Fraction To Decimal

Little issue on a Postgres database, being managed in Acqua Data Studio: I need a solution to creat… Read more Join Solution On Postgres With Many Tables

Is there a way to subtract a geometry from another? A kind of reverse STUnion.. The problem I am h… Read more Subtracting A Sql Server Geometry From Another

Trying to get a basic table that shows retention from one month to the next. So if someone buys som… Read more How To Calculate Retention Month Over Month Using Sql

I have a table Cars as follows: This table will be read in grid of a C# application. The applicati… Read more Insert Or Update Datatable Values Into A Database Table Using Stored Procedure

I'm been trying to find a example of how to get a max number in a column.What I want to do is, … Read more How To Get Max Number In A Column?

ALTER TABLE products ALTER COLUMN power_price DROP DEFAULT; ALTER TABLE products ALTER COLUMN power… Read more Cannot Cast Type Numeric To Boolean

I'm currently taking the online stanford class on databases, If you could help me solve this sq… Read more Finding The Average Rating Of Each Of The Movies Sql

I want to query names from table1 and also find if a name exists in table2. I have the following qu… Read more Checking If A Value Exists In Another Table Within The Select Clause

A bulk update was done on a table. This caused an SP to execute very slowly even if it had OPTION(R… Read more Sql Server - Statistics And Recompiling

My last question on this same cte query was answered so quickly, I thought I'd bounce this next… Read more Sql Server Cte "multi- Part Identifier Could Not Be Bound."

I've checked and rechecked and looked over and over at it but can't understand what's w… Read more Update Sql Command Syntax Error

Our database is insert inensive (200-500k per night) but update light (maybe a few hundred per day)… Read more Change Data Capture For Updates And Deletes Only

I have two tables that I'm trying to join and insert into another table based on a combination … Read more How To Join Two Tables Based On A Timestamp (with Variance Of A Few Seconds)?

I have 2 tables, Foo and Bar, Foo has a link to a Bar record public class Foo { public int Id {… Read more Entity Framework - Not Using Linked Table Id In Insert Query

I need to move/copy all of my databases (only 5) from one server to another. I know how to make bac… Read more How To Move/copy All Databases With Users, Schema And Roles From One Server To Another

I am creating a select which brings me beyond the results of the table a column with a range of 15 … Read more Create Ranges Of Minutes (15) In Select

I am trying to get the hierarchy level of this query. Here is the CTE recursive query WITH Category… Read more How To Get The Hierarchy Level Of This Query

We seem to have a few developers here who think creating stored procedures that spit out HTML or Ja… Read more Embedding Html Code In Stored Procedures

I'm trying to work out why this query does not return results. The same query works fine in Acc… Read more Vb.net Sql Query Not Working In Vb But Does In Access

My code goes here.............! when there is a row deleted from the list-view. The indexes of the … Read more How Can I Get The Row Id Of The A Table In The Sqlite Database When An Item Is Clicked In The Listview

I could use some help to make this search return results in certain situations. The user has 2 fiel… Read more What Can I Do To Make This Sql Return Results In Certain Situations?

I'm joining a couple of tables, and aggregating some of the columns via GROUP BY. This is what … Read more How To Include Other Grouped Columns

I am having trouble putting image upload field within the rest of the fieldset, mainly becaouse i n… Read more How To Upload Image To Sql With Mvc3 Within One Form Using Ado.net?

I want to output all the possible combination in two tables without using cartesian join or cross j… Read more Alternative For Cartesian And Cross Join

I am simply trying to call a store procedure (SQL Server 2008) using C# and passing XMLDocument to … Read more Calling A Stored Procedure With Xml Datatype

I'm writing java application using hibernate 5.2 but without HQL there is two table, Transactio… Read more Hibernate Join Two Unrelated Table When Both Has Composite Primary Key

SELECT u.id, u.username, u.score, (SELECT COUNT(ownerId) FROM post p WHERE p.ownerId = u.id) AS to… Read more How To Convert This Query In Yii Framework Model

What I'm trying to do Instead of using form.predictions() I've tried to separate it out so … Read more How Do I Correctly Submit Results From A Wtformusing Jinja With A Python /flask Setup

I have two similar tables, one in Production and another in Work in Progress. I need to copy set of… Read more Check Whether Set Of Rows Exists In Production

I'm having great difficulty solving this seemingly easy task: Purpose: Create a query that elim… Read more Teradata String Manipulation (second Space)

I have an app with users; the users can create bookmarks, and each bookmark can have multiple tags.… Read more Remove Duplicates On Mysql Join Query On Json_arrayagg With Inner Join

I am writing a dynamic insert query in a stored procedure. I am receiving the column names as param… Read more Dynamic Sql Server Query

After trying all the possible solutions from blogs, forums, web pages, I've come up with this q… Read more Unable To Create Second Table In Sqlite

How do you perform a LIKE statement on a column of DateTime datatype in SQL Server? If I run the fo… Read more Sql Like Statement On A Datetime Type

I'm having a really tough time figuring how to use an xml data column in SQL Server, specifical… Read more Querying Sql Server Xml Column With User Provided Xpath Via Entity Framework

I'm fairly new to asp.net and especially LINQ and SQL. Say I have a table 'Employees' w… Read more Binding Multiple Fields To Listbox In Asp.net

I have a table, edgar_t100 and which is a table of one column, named ID. I need it to have 100 rows… Read more Insert Into Table Using Result Set Of Dual Query?

I need to write a query that returns the latest message in a conversation between two users. I'… Read more How To Get The Latest Message In Each Conversation Of A Certain User In Sql?

So I have a table which I populated with ~700K entries for testing, and it is showing it's pain… Read more Mysql With Innodb: How To Avoid Using Count?

I am doing a select() from a SQLite database and then an insert(): engine = create_engine('sqli… Read more Sqlalchemy.exc.resourceclosederror: This Connection Is Closed When Inserting After Select

I have restored a 2005 Database to a new 2008 R2 DB Server. I have created a new user called 'g… Read more Sql Server 2008 R2 User Cant Use System Procedure

I have a bunch of candidates, who have had one or more jobs, each with a company, using some skills… Read more Why Is My Query Returning Far To Many Results?

I have one DB (programming is with Delphi) , and I want to count an item in one column. For example… Read more How I Can Count Item In One Column With Sql Statement

string que = 'SELECT Name FROM StudentInfo where StudentNo=textBox1.Text '; Every time I r… Read more Getting Value From A Database Using Textbox

I am having an arraylist of strings. I needt to store that arraylist in the 1 column of database. … Read more How To Store The Contents Of An Arraylist In One Column Of Table In Sqlite Database In Android?

What is the SQL syntax to find last directory name from a file path. For example I want to fetch th… Read more Fetch Element At Particular Position

My question is basically an extension of this question - How to find if a list/set is contained wit… Read more How To Find If A List/set Is Exactly Within Another List

This probably isn't valid SQL, but this is what I'm trying to do: SELECT * FROM tablename … Read more Using Case In Combination With Where To Specify Different Columns To Filter By

In an InfluxDB measurement, how can the field values of points matching a query be updated? Is this… Read more Update Multiple Field Values Matching A Condition In Influxdb

I am using Python script to insert records into MySQL database table. The script fails with the fol… Read more Pymysql.err.operationalerror - Lost Connection To Mysql Server During Query