Data dodania Pytanie
2018-02-14 15:02 Audit trail with Entity Framework Core »
I have an ASP.NET core 2.0 using Entity Framework core on a SQL Server db. I have to trace and audit all the stuff made by the users on the data. My ...
(2) odpowiedzi
2018-02-05 15:02 Entity Framework data migration with custom logic? »
Suppose, I want to replace table A with table B and migrate all data from one to another, so I do: Create table B through SQL query Perform transfo...
(2) odpowiedzi
2018-02-03 23:02 Memory Optimized Tables - Slower INSERT than SSD »
I have observed that inserting data into a Memory-Optimized Table is much slower than an equivalent parallelized insert to a disk-based table on a 5-S...
(0) odpowiedzi
2018-02-03 01:02 SQL - how to query two tables and return the results as one? »
Long story short, I have this website where "Parent" level comments are stored in a separate table than their replies, known as "Child" comments. To ...
(1) odpowiedzi
2018-02-02 18:02 How to sort by column and next row and order them by another column? »
I have a table with four columns: ID, isError, SolidLine and HighestError. Each row is related to another row by SolidLine column. So we have two rel...
(3) odpowiedzi
2018-01-30 12:01 SQL Server query fast after clearing cache »
I have a problem with a query running on Microsoft SQL Server 2012. This query selects articles out of different stores and ran fine over months, wit...
(1) odpowiedzi
2018-01-28 11:01 Is there any way to make this query faster and build where clause outside of loop? »
I have the following code, (and I am completely aware about parameterized queries and SQL Injection): foreach(var item in items) { string query =...
(2) odpowiedzi
2018-01-26 22:01 Stored procedure in SQL Server performs very slowly when used by many users »
I have a weird situation where I'm not quite sure what's happening with my stored procedure in my SQL Server 2016. I have created two identical proce...
(1) odpowiedzi
2018-01-21 19:01 Casting columns in SQL Server for SSIS package purpose »
I stuck with casting data in SQL Server. I'm doing a SSIS package to transfer data from SQL Server to an Oracle database, and in Oracle, I have column...
(2) odpowiedzi
2018-01-20 17:01 Oracle Wallet Integration in SSIS Oracle Provider OLEDB Connector »
I've successfully configured oracle wallet in my machine in windows 7. I also checked by executing the below command sqlplus /@myoracleDB and it ...
(2) odpowiedzi
2018-01-17 19:01 Running SQL queries in 2sxc razor templates »
I use 2sxc for reasearch projects, and statistics is the most important part of the work I do. With link and visual queries I can do 90% of the work w...
(1) odpowiedzi
2018-01-17 06:01 Coldfusion can't see table 'Helpers', but CAN see other tables in same database. Any ideas »
I'm running CF 2016, SQL Server free edition 2017. For the life of me I cannot figure this out or find similar issue. I've deleted the table 'Helpe...
(2) odpowiedzi
2018-01-16 14:01 CASE in Query of a Query »
In ColdFusion, after having queried an MSSQL Database and added a couple of rows with the QueryAddRow function, I need to reorder the query by doing a...
(3) odpowiedzi
2018-01-16 13:01 NHibernate HQL Generator to support SQL Server 2016 temporal tables »
I am trying to implement basic support for SQL Server 2016 temporal tables in NHibernate 4.x. The idea is to alter SQL statement from SELECT * FROM...
(0) odpowiedzi
2018-01-15 12:01 why is a console app affected by having SSMS open »
I have a console app (c#) which opens a connection to a sql database, executes a stored procedure and then exits. The stored procedure times itself (u...
(2) odpowiedzi
2018-01-13 08:01 "Spatial types and functions are not available for this provider" error is showing when application moved to server »
I had write an api in WebApi, that was working in local fine, but when i moved it to server then it is showing the following error, {"Message":"An...
(1) odpowiedzi
2018-01-13 05:01 Dynamically convert row into columns based on the content in the cell in SQL Server & Oracle »
Using procedure i am trying to achieve below use case. Can someone please guide me. Here is the data which is present in a table Source Table : I...
(3) odpowiedzi
2018-01-08 17:01 How to add FailoverPartner to Connection String in Asp.Net Core »
I am trying to add a FailoverPartner to a connection string to an asp.net core application . FailoverPartner works in connectionstrings in web.confi...
(0) odpowiedzi
2018-01-08 16:01 Integration of a c# class library in SQL Server »
I am trying to test the functionality of CLR Functions in SQL Server 2012. I found a tutorial online on how to basically do this and got it to work on...
(1) odpowiedzi
2018-01-07 16:01 How to get most expensive SQL queries executed on a particular Database »
I'm no DBA and barely know a few things about SQL, I have found a lot of scripts online that get most expensive queries, but I can't seem to find one ...
(1) odpowiedzi
2018-01-06 21:01 Visual studio SQL default value not showing on windows form when adding new record »
I have created a SQL table in Visual studio and set a default value on a field. The table is connected to my C# project (in the same solution) and ...
(4) odpowiedzi
2018-01-06 15:01 CFML form will not insert into SQL Server 2014 database »
Lucee 5.2, SQL Server 2014 I have a form that will not insert a new record into my SQL Server 2014 database. I've studied this problem for a couple ...
(1) odpowiedzi
2018-01-04 13:01 SQL Server Multiple Replacements »
Using SQL Server 2008 R2 - 2016. I have inherited a function we use to make friendly urls - i.e. multiple character replacements. I've just opened it ...
(1) odpowiedzi
2018-01-01 10:01 Is an ACID complaint SQL database is still "ACID" even when not explicitly using transactions? »
let's say I'm using a standard SQL engine (e.g. Postgres, MySQL...). If I'm not explicitly saying "Begin transaction" and "end transaction" when maki...
(1) odpowiedzi
2017-12-30 11:12 TypeError: sqlDb.Connection is not a constructor in Rest Service using Node.js »
I'm building a simple REST Service with Node.js When I send a GET request I'm getting an error saying: TypeError: sqlDb.Connection is not a const...
(1) odpowiedzi
2017-12-29 19:12 get all record without child and not mapped any parent to in self referencing table ? - SQL »
I have a self-referencing table with content like this: Demo here Self-referencing parent table emp_id man_id(FK of emp_id or ParentID) ----...
(4) odpowiedzi
2017-12-29 11:12 Combine ASP.NET MVC and Web API projects using identity »
I am new to ASP.NET and I have to create an ASP.NET MVC project using the identity framework for authentication and authorization, but the access to t...
(1) odpowiedzi
2017-12-28 20:12 Searching an int column on the bases of a string value »
I have a View View_Booking in sql server 2014: bkID bkSlot bkStatus ---- ------ -------- 2 Lunch 1 4 Lunch 1 6 ...
(7) odpowiedzi
2017-12-28 16:12 Create table mysql with TIMESTAMPDIFF »
I am converting some tables from my system that used sql server now to mysql, and am having a question in mysql how can I create a table with TIMESTAM...
(1) odpowiedzi
2017-12-21 14:12 What is the equivalent Syntax for Outer Apply in PostgreSQL »
Im trying to find a SQL query on the equivalent usage of OUTER APPLY from MSSQL to PostgreSQL but it seems hard to find. My MSSQL sample query is lik...
(1) odpowiedzi
2017-12-19 10:12 .Net Core 2 Sql Server connection »
I wanted to try out .Net Core and created a new .Net Core 2 Webb application. I then added another .Net Core class library in order to use that as my ...
(1) odpowiedzi
2017-12-16 12:12 passing array of ints into mssql sp from laravel for using in the "in" operator »
i have a mssql sp which one of it's arguments is table-valued. i want to pass an array of int's to it from laravel project. i tried this : DB::connec...
(1) odpowiedzi
2017-12-14 22:12 ASP.NET Web API List All Records from SQL Server Table »
I'm trying to follow a simple example (link below) to learn Web API and am unable to get it list all records from my underlying table. The following w...
(1) odpowiedzi
2017-12-07 23:12 Greater Than with multiple conditions in Linq Join »
I have the following SQL Server query: SELECT * FROM Stock s LEFT JOIN StockOrderItem soi ON s.ItemNumber >= soi.StartNumber AND s.ItemNum...
(2) odpowiedzi
2017-12-06 13:12 Error inserting file content in SQL Database using mssql php »
I'm trying to upload files (pdf, images) into the database using PHP and MSSQL. <form role="form" action="kyc.php" method="post" enctype="multip...
(1) odpowiedzi