Stack Overflow
Stack Overflow

Questions tagged [sails-mssqlserver]

9 questions
9
votes
1 answer

Retrieve multiple result sets in sails js

I am using sails js with it sails-mssqlserver adapter. The problem with it is that if my stored procedure returns multiple result sets then I only receive one result set which is the latest of all. The same stored procedure is working fine with…
TGW
  • 805
  • 10
  • 27
1
vote
0 answers

Moving PHP code from mysql to ms sql server

I moved database from mysql to ms sql server, and now I need to migrate the PHP code. I'm using PHP 7.0.33. My problem is that mysql code worked on single rows of data, so after fetching data into a resource, inside the loop each row was returned…
jacknomiz
  • 13
  • 1
  • 3
0
votes
0 answers

SQL to Googlesheets using Python

I am trying to connect to a SQL server using Python and then dump the data to google sheets. import pypyodbc as odbc import pandas as pd from google_apis import create_service when I sun this code block I get an error message line 1…
Johnny Quest
  • 41
  • 1
  • 8
0
votes
1 answer

Set transaction isolation in Wildfly local datasource

I am using Wildfly 13 with a MS SQLServer database (sqljdbc driver 4.0.0) I am trying to set the transaction isolation for the connections created by Wildfly. The local datasource configuration is
user2157799
  • 21
  • 3
0
votes
1 answer

If else statement in insert query

I am facing a problem regarding syntax error in this code snippet INSERT INTO tblScheduledBillGenerate(SettingConnectionId, UserId, MonthlyBill, BillGenerateDate) VALUES ( @Id, @UserId, ( if exists (SELECT * …
M_O_MEN
  • 1
  • 2
0
votes
1 answer

SQL Server query is taking 8 minutes to complete. All indexes are good

Below is the query that I am running. Execution plan is at the bottom. It takes 8 minutes to complete and shows 'Query cost related to batch : 84%' in query plan. I haves fixed some required non-cluster indexes but it saved hardly a minute in…
Andy
  • 75
  • 1
  • 10
0
votes
2 answers

What's wrong with below mysql query

i have below query which i want to use in my application using nodejs i ran this query in mysql works fine but when i am running this query in application it's giving below error. Any help would be appreciated. SELECT COUNT(*) as nos, t.*…
Neeraj Kumar
  • 1,058
  • 1
  • 9
  • 22
0
votes
1 answer

Sailsjs Waterline many to many relationship with legacy database

I have 2 domain User and Role and it has a relation to Many To Many. User has many Roles. When I run the application it creates the mapping table like role_user__user_role. I need to support legacy database where the table name is UserRole. Can…
user9873999
  • 311
  • 3
  • 15
-2
votes
1 answer

SQL SERVER ERROR: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

Msg 468, Level 16, State 9, Line 26 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
yasir ali
  • 1
  • 1