Questions tagged as 'sql-server'

Tagged questions
0
answers

SQL Transactions

I need to verify that a transaction has been carried out correctly, since this transaction works on several systems, that is, if I need to register a single user on one of several systems and one or all of these systems do not Are they available...
asked by 28.03.2018 / 23:10
2
answers

Using Django with an existing Sql Sever database

I'm trying to test Django with a database in Sql Server that already exists. I have searched for documentation, and everything points to using the Inspectdb ( python mysite/manage.py inspectdb > mysite/myapp/models.py ) comman...
asked by 01.03.2018 / 19:45
0
answers

I need to export an NVARCHAR from JAVA in excel

I am using the sql server database in which I am using a cursor. I need to read this NVARCHAR from java so I can export it in excel from java. Take into consideration: that these columns of my Excel will be added more in the future. e...
asked by 09.03.2018 / 20:43
0
answers

Create Array in a stored procedure

I am migrating a stored procedure from Oracle to Sql server and I have this problem. It turns out that they occupy a varray within the code. I do not know how to do it in SQL. Searching for different pages, some recommend that a table be made...
asked by 12.02.2018 / 23:43
1
answer

Pass Array with numbers to SqlServer, split and insert the data

Here I bring my problem. I use SqlServer 2014 and VisualStudio 2015 I have an Object named CashRegister which has these attributes: public class CashRegister { private static CashRegister CashRegisterInstance; public int? Id...
asked by 16.02.2018 / 18:38
0
answers

Parallel Period filter (MDX)

If we have the following query in the [Adventure Works] cube of the BD AdventureWorksDW2014 : WITH MEMBER [Measures].[Previo] AS ( [Date].[Calendar].currentmember.PrevMember,[Measures].[Customer Count]) MEMBER [Measures].[Paral...
asked by 31.01.2018 / 21:12
0
answers

error 26 sql express using entity framework

Hi, I'm starting to study c # and I'm using visual studio community 2013 and sql express. Employment entity framework. I use the model first concept to generate the classes and the database. I have several questions to see if you can help me:...
asked by 26.01.2018 / 02:34
1
answer

Connect Query Sql Server

Good afternoon, what happens to me is that I have a query on sql server and when I stop working on the query for a while it disconnects and when reconnecting it does not let me execute the code I have, does anyone know how I can reconnect it?  ...
asked by 25.01.2018 / 20:23
0
answers

How to prevent logging when the php sql server page is updated

Dear, I would like you to help me, I'm doing an insert with php and sql server for which you register correctly but the problem is that when I update the page you register how I can avoid that. this is my code: <table class="table">...
asked by 03.02.2018 / 16:04
2
answers

Declare scalar variable in Stored Procedure

I have the following SP and it marks me the following error in the SP:    SQLState = 37000, NativeError = 137 Error = [Microsoft] [SQL Server]   Native Client 10.0] [SQL Server] Must declare the scalar variable   "@Today". SQLState = 37000, N...
asked by 15.01.2018 / 17:39