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
order by DAY no matter the year or month
hello i have a problem i want to display dates by ordering them by day to now what birthday comes first, for ex: i have
15/08/2013 00:00:00
15/08/2013 00:00:00
29/08/2012 00:00:00
23/08/2012 00:00:00
16/08/2012 00:00:00
10/08/2012 00:00:00
i want…
0
votes
0 answers
edit data in pane result
I have run a query through pane in sql server 2008. Now I want to change some data from the result, but it shows error, "No row was updated. The data in row 2 was not committed".
How can I change data in pane result.
Gaurav
- 557
- 4
- 11
- 28
0
votes
1 answer
Symmetric decrypting returns a NULL value
I have two databases . I copied all the data from one table and inserted into another database table . I have created symmetric key on second database but when i try to run the query as follow
OPEN SYMMETRIC KEY SecureSymmetricKey DECRYPTION BY…
pardeep dhingra
- 137
- 1
- 2
- 7
0
votes
1 answer
Sql jpa Query for ManyToOne
sorry for my bad english and may be bad question. I have this:
Entity
@Entity
@Table(name = "Books")
@NamedQueries({
@NamedQuery(name =…
hardor
- 3
- 3
0
votes
2 answers
Sum the timegap if consecutive timestamps are same for 10 min
i am using the below query to find the null values of a column and get the starttime and endtime of the null values using the below query for some 30,000 rows
SELECT
yt1.[timestamp] AS StartTime,
MIN(yt2.[timestamp]) AS EndTime,
…
Reyaz
- 55
- 2
- 10
0
votes
2 answers
How to write complex select in sqlite
I have the sql as below:
PRAGMA foreign_keys = 1;
CREATE TABLE people ( pid INTEGER PRIMARY KEY, name TEXT );
CREATE TABLE groups ( gid INTEGER PRIMARY KEY, name TEXT );
CREATE TABLE p_g_bridge (
pid INTEGER NOT NULL REFERENCES…
Shanmugaraja G
- 2,778
- 4
- 31
- 47
0
votes
3 answers
sql query with two tables having reference key
I have two tables:
Discounts(disid primary key)
Cust(custid primary key, disid ref discount(disid))
Now I need a query to get custid having all disid(discount coupons) and the customer may contain the same disid more than once.
Ramesh.kbvr
- 763
- 6
- 15
- 31
0
votes
3 answers
JOIN three tables and aggregate data from multiple rows for every DISTINCT row in separate column
JOIN three tables and aggregate data from multiple rows for every DISTINCT row in separate column
i have a table where one item is mapped with multiple items.
Key 1 | Key 2
1 2
1 5
1 6
1 4
1 8
I have another table like…
Mindaugas
- 163
- 1
- 7
- 16
-1
votes
2 answers
NHibernate ISQLQuery SetParameter issue
This is probably fairly straightforward but i can't seem to find a reasonable explanation in any documentation.
I'm trying to use an NHibernate.ISQLQuery and using SetResultTransformer() to return a custom set of results from a custom SQL query.…
Brett
- 155
- 3
- 9
-1
votes
1 answer
SQL Oracle Command "missing right parenthesis"
every time I want to create this table, it says Missing Right Parenthesis. Can someone please check what i have wrong please. Thank you
CREATE TABLE Pet
(
PetID Int NOT NULL PRIMARY KEY,
OwnerID Char (7) NOT NULL,
TypeID Char integer NOT…
Hellz Yeahh
- 63
- 1
- 5
-1
votes
2 answers
SQL Query issue while trying to do relations
i am creating tables in my database and i have a weird problem going on with my query when trying to create a relation between tables.
here is my query :
CREATE TABLE ogrnizationarticle (
OAID Int NOT NULL ,
_Text VARCHAR(255) NOT NULL ,
…
-1
votes
1 answer
Can i get all rows from a table on SQL and count them in same function or query?
so can i do both queries from getAllProduktet ?
function getAllProduktet($kataloguID)
{
$query = "SELECT produktet.ID, Pershkrimi, Qmimi,Fotografia, TVSH, Katalogu from produktet, tvsh, katalogu "
." where produktet.tvshID = tvsh.ID and…
Aragunz
- 511
- 5
- 18
-2
votes
2 answers
Using SQL Server how to sort a list of strings based on searched value(Searched text) position in string
I have to sort a list based on the searched text position in the string i.e. if the searched value appears first in the string then its position should be first in the list, if it appears second in the string then it should be second but all the…
user15950409
- 11
- 2