summer2012training

I need to insert dataset in postgresql. INSERT INTO table_subject_topics_exams (name_of_subject, se… Read more Insert Data Into Postgresql With Duplicate Values

Simple question, i have a query with some WHERE and i need to duplicate it with a change to 1 field… Read more Quickest Way To Duplicate A Mysql Record

I'm getting Errors that ORDER by should come after UNION but i want these to queries ordered be… Read more Sql: Select With Union, Order By And Limit

I've been staring at this for a while now. Maybe some fresh eyes will be able to point out what… Read more Mysql If Exists

What is the Big-O for SQL select, for a table with n rows and for which I want to return m result? … Read more What Is The Big-o For Sql Select?

I am trying to reconcile the IDs in a temp table (top) from another DB table (bottom). Since I only… Read more How To Update Multiple Rows In A Temp Table With Multiple Values From Another Table Using Only One Id Common Between Them?

I have a DB table with records as shown below, ID ATTR_NAME ATTR_VALUE 1 ABC DEF … Read more Fetching Columns Of A Multiple Rows In One Row

I have a similar problem with what is posted here: SQLite connection not appearing in Entity Data M… Read more Sqlite Connection Not Appearing For Vs2015

How could i get the table column name and value using sqlalchemy? Using what i have, i'm able … Read more Return Field Name And Value From Sqlalchemy Result

i try to generate a table (look TABLE 1) with the query(below). CREATE TABLE #temp( [VisitingCount]… Read more How Can I Left Out Join These #temp (default Data) And Another Table?

Is it possible to combine the use of back ticks ` with the substr() function? I have column names w… Read more Mysql Query Column Name Substring

I know Red Gate has such a product, but I'd rather not have to pay for something which, in my o… Read more Are There Free Sql Server Mgmt Studio Autocomplete Add-ins?

Okay, So I am hashing my password using 'sha1' when I define what the variable '$passwo… Read more Hashed Password Logging In Error

I am working on an Entity Framework project using SQL Server 2008. We recently changed to use the d… Read more Allow Entity Framework 4.5 To Use Datetime2 With Sql Server Ce4

Getting Examples from similar Stack Overflow threads, Remove all characters after a specific chara… Read more Using Regexp_substr With Strings Qualifier

I have an application that uses a SQL Server database with several instances of the database...test… Read more Sql Server Equivalent Of Mysql Dump To Produce Insert Statements For All Data In A Table

A colleague I work with recently told me that SQL Express and MS Access were essentially the same t… Read more Sql Server Express Vs Ms Access

I have the following SQL query that comes out at 700 declare @a decimal(10,0) declare @b decimal(10… Read more Sql Calculation Not Showing In Correct Format

I have an entry that looks like this: UserID---StatusStart---StatusEnd---StatusKey---StateDuration … Read more Sql - Split Total Time By Time Intervals

I have an application that originally needed to connect to Sybase (via ODBC), but I've needed t… Read more Turning On Multiple Result Sets In An Odbc Connection To Sql Server

I'm looking for a way to clear transaction logs; in particular, I want to shrink the logs. I kn… Read more Executing Shrink On Sql Server Database Using Command From Linq-to-sql

I've got a problem with inserting two rows to table. The database is in UTF8. The problem seems… Read more Mysql, Polish Characters And Duplicate Insert Statement

I have a SSIS package where I have to select some values from an excel sheet and insert them into a… Read more Bulk Insert From Excel To Sql For Selective Fields On The Basis Of Cell Location

Following this question, I set the following MySQL parameter in C:\Program Files\MySQL\MySQL Server… Read more Mysql's Wait_timeout Incorrect In Sqlyog

I am working with an existing SQLite database and experiencing errors due to the data being encoded… Read more Sqlalchemy: Dealing With Cp-1252 Data When Python Is Expecting It To Be Utf-8

What's the best delimiter to use when exporting data? What's the best way to work with NULL… Read more Questions About Exporting And Importing Flatfiles (txt, Csv) In Sql Server 2005

I have some data in a source table that looks like the below. This is basically a narrative field … Read more Consolidating Data From Multiple Rows Into A Single Varchar(max) Field, Is There An Alternative To A Cursor And .write

Can anyone point me to a vbscript (using WMI) to find out the installed SQL Server version. I have … Read more Vbscript Using Wmi To Find Out Sql Server Version