ISQLQuery is an interface in NHibernate. When using this tag please use NHibernate tag as well.
Questions tagged [isqlquery]
43 questions
0
votes
2 answers
How To execute SQL Query in ASP.NET Core API
I have this SQL Query :
DECLARE @pageNo int=1
DECLARE @pageSize int=2
SELECT top 2 id,
Title,
Author,
NumberOfPages,
PublishedAt,
RowNumber
FROM
(
SELECT top 2 id, Title, Author,
NumberOfPages,PublishedAt,
Row_Number() over (order by id desc) as…
Mohammad Eibou
- 13
- 4
0
votes
0 answers
Syntax error at or near WHERE clause, Natural join
Why does this code not work?: (If I remove book_info and author in the 'where' clause, it still doesn't work).
SELECT title, last_name
FROM book_info NATURAL JOIN book_author natural join author
WHERE book_info.title = ‘Uncle Samsonite’ AND…
user1
- 37
- 6
0
votes
0 answers
How to connect and query from two database servers in isql?
I want to query from two tables present in two different database servers using ISQL.
Query is
select * from server1.database1.table1
where column1 in (select column1 from server2.database1.table1)
How do I do this in ISQL?
Gurunand A
- 11
0
votes
1 answer
Raw SQL Query that causes error when translated to ActiveRecord Query (Firebird Database)
I am trying to do a fairly simply query that involves getting all the records between two dates via a specific column.
The raw SQL works fine in ISQL Firebird:
SELECT * FROM OPS_HEADER
WHERE PB_BOL_DT
BETWEEN '2020-09-01' AND '2020-09-10';
Here is…
AttemptedMastery
- 738
- 6
- 21
0
votes
0 answers
Incorrect Output for varchar(32) in SQL Query
I have some varchar(32) field in my ERP database in item Master, but when I want to get these field in SQL query it gives incorrect output for example 6M - 6. Please any suggestions to solve the issue and get the correct output.
Select [No_],…
AkJ
- 1
- 1
0
votes
1 answer
How does sqlite select the index when querying records?
Background
I am an iOS developer, and we use CoreData which uses sqlite database to store data in the disk in our project. Several days before one of our users said that his interface is not fluent in some case when using our app which version is…
Gang Yang
- 11
- 1
- 4
0
votes
1 answer
How to restrict to execute a single sql query using OleDbCommand
I have tried to give multiple insert or update in single query like
OleDbCommand command = new OleDbCommand("INSERT INTO Employee (Id,
Name, Address, Salary) VALUES (2001, 'name1', 'address1',
100000);UPDATE Employee SET Salary = 2000000 WHERE…
Sandip D
- 103
- 1
- 14
0
votes
1 answer
Concatenating Boolean to DataFrames sqlQuery str
I am attempting to query the weather database for building decision trees. In it there are 14 instances and I am making new dataframes based on the intend subset that I want to query e.g -->
new_data = data.query("'rainy' in Outlook")
will…
Steve
- 4,388
- 3
- 17
- 25
0
votes
1 answer
execute sql DDL WITH ibscript at runtime
I have a problem about running script
IBScript := TIBScript.Create(nil);
IBScript.Database := FDM_DB.IBD_GCV;
IBScript.Transaction := FDM_DB.IBT_GCV;
IBScript.Terminator :=…
kovarov
- 465
- 5
- 11
0
votes
1 answer
Getting mapped entities from an ISQLQuery without AddEntity
consider these POCOs:
class Foo {
int Id {get;set;}
string Name {get;set;}
}
class Bar {
int Id {get;set;}
string PropA {get;set;}
Foo PropB {get;set;}
}
Now what i want to achieve is using an ISQLQuery with a root entity of Bar to also…
Jaguar
- 5,929
- 34
- 48
0
votes
1 answer
SQL greater than & less than statements don't return correct results
I'm running queries and they aren't looking at the entire number when using > and < statements so in this example the results are incorrect as it's looking at the 1 rather than the 10 in the first octet. Here is the query and an excerpt of the…
user3009669
- 51
- 1
- 8
0
votes
1 answer
Sqllite query In inner join i don't want to repeat id
In iOS i am using sqllite , i have create database with two tables one is for person and second is for person images, i want to get person info with any one image BUT my query is return all image with repeat person id please help me here is my query…
0
votes
2 answers
SQL query issues - how to find answer?
Tables:
PERSON (ssn, Name)
Has_Visited (ssn, city)
Belongs_To (City, country)
Based on following information, create this question:
What is the name of the persons that have visited the city "London"?
0
votes
1 answer
how to find the weekend dates from given list of dates
I have a list of dates and other columns in which have to find the weekend dates among them and the the weekend dates should be there in the list of given dates
Output should be some thing like this...
Any help is appricated thanks.
Vinay
- 111
- 1
- 3
- 15
0
votes
1 answer
Sql Server Selecting 1 single datapoint every hour or every day from a table
Hi I have several tables in sql server that record data every 30 seconds. obviously after a while that gets a bit bulky, what I'd like to do is select 1 datapoint an hour over the past 24 hours and put that into a seperate tables for fast quesries,…
Cfoote7
- 375
- 2
- 3
- 14