Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure. This tag refers to the standard language, not for questions about specific vendor extensions, like MySQL or Microsoft SQL Server, so if you think your question relates to ...
0
votes
0answers
5 views
SQL SMO v11 (SQL 2012) + .NET v2.0
I write a C# cmdline tool that does SQL DB backup via SMO DLLs (SMO DLLs v11 from SQL 2012).
In Visual Studio 2012, the initial target framework is set to .NET v4.5 and everything works just as ...
0
votes
0answers
8 views
Search Blob and find multiple matches along with identity field
I have an identity column and a string value stored as a blob in 2 columns in my db.
What I’m trying to do is search for multiple values within the string and return the results in different rows for ...
1
vote
0answers
10 views
SQL 2012 Error 3154 while restoring a DB backup in SQL 2012 even if “With replace” is checked [migrated]
I have SQL 2012 with SP1 installed on my computer. I made a backup of a database "test.bak"
I have a database with the name "test2" wich is the same database, but the data changed.
I want to restore ...
0
votes
1answer
19 views
Return Type of Oracle Trunc Function
select trunc('11.01') from dual
Output : 11
What is its datatype in jasper report am getting as BigDecimal.
Is there any work around to get that as string.
0
votes
2answers
18 views
migrating code from dev to prodcution, is there a checklist
I am currently trying to gather requirements to what is actually needed to move code from dev to production. These will mainly be SQL stored procedures and will be used to create reports in SSRS.
...
0
votes
1answer
11 views
Associate Duplicate Rows with corresponding active roe (row 1)
SQL Server: Duplicate result set with RowNo
SourceID FullName RowNo UniqueID
----------------------------------------------------------------
29757 NORBERT OVERWEG 1 29757
53736 ...
0
votes
1answer
29 views
Using SQL Server, is there a way to query (555) 344-2524 using 5553442524?
Using the PHP SQLSRV driver to connect to SQL Server 2000, is there a way I could match all of these rows using this piece of data: 5553442524?
555-344-2524
(555) 344-2524
555.344.2524
...
0
votes
0answers
9 views
“SET FMTONLY ON” Alternative to MySQL
The goal
Send the columns of tables as header using "SET FMTONLY ON" alternative to MySQL.
The problem
I'm using Entity Framework 5 of C#.Net and I need to create complex types with their scalar ...
1
vote
0answers
19 views
JDBC SQL QUERIES JAVA Dates and Comparison
I want to create methods in order to process the actual rate of the variable into the database. Lets assume if the rate didn't change for Yesterday then keep the same rate however if changed then ...
-1
votes
1answer
28 views
multithread SQL-query
I have a SQL query:
INSERT INTO logins (name, password,roleId,email,phone)
SELECT 'login', 'password', 1, '[email protected]', '375291234567'
FROM (SELECT count(*) FROM logins as l4) as l3
...
0
votes
1answer
17 views
CodeIgnighter array information
from print_r
Array (
[0] => stdClass Object (
[id] => 2729
[title] =>
[image_file] => M6_Black_Back.jpg
[product] => 2
[active] => 0
...
0
votes
3answers
20 views
oracle sql 2 records per day per unique fields, how to get the latest
Here is the table structure:
ID
FIELD_A
FIELD_B
DATE_FIELD
VALUE_FIELD
The ID field is just a number that increments with each record. We get 2 "sets" of records in a day where FIELD_A, FIELD_B, ...
1
vote
1answer
15 views
match and replace mysql query
I have two tables in a database like this:
ARTICLE TABLE
id | name
------------
1 | Cars
META TABLE
id | post_id | key | value
---------------------------
1 | 1 | Audi | 42
And want to ...
0
votes
1answer
24 views
QSqlRelationalTableModel::removerow() deletes the row from table but not from the model
The code speaks better:
model = new QSqlRelationalTableModel();
model->setEditStrategy(QSqlRelationalTableModel::OnRowChange);
model->setTable("members");
model->setRelation(Member_TeamID, ...
0
votes
1answer
10 views
How to add lines from text file to sqlite db rows that already exist?
I have 12 columns with +/- 2000 rows in a sqlite DB.
Now I want to add a 13th column with the same amount of rows.
If I import the text from a cvs file it will add this after the existing rows (now I ...
