Questions tagged as 'sql'

Tagged questions
1
answer

returns more than one SQL result under query for trigger?

I have this trigger script created by me which executes a perfect UPDATE when it is a single user but when it is more than one or several User Fails the query by the trigger (BEFORE NOTHING SEARCH ON INTERNET that has to do with TOP 1 or IN the...
asked by 16.09.2016 / 20:14
1
answer

Restore DataBase.bak without affecting triggers Current SQL SERVER

How is a DataBase.bak in SQL Server 2008 R2 overwritten? While I have the Triggers in the database that is working. I need to do a restoration of it without affecting the triggers of the old database, that is to say that only the r...
asked by 20.09.2016 / 23:38
2
answers

Problem when inserting data in windows form c # form with sql

I am developing a program that I am doing for my class, it is a small program of a hardware store where product information is kept, clients (so that if it is a distributor, apply discount) , types of products and so on. The problem is in th...
asked by 26.08.2016 / 05:20
1
answer

Is it possible to execute a stored procedure with one click?

I have a store procedure in SQL and I would like to know what is the simplest way to execute it. This is a set of tables that must be updated once a year, but you will not opt for the JOB because the update date will never be the same. The id...
asked by 15.08.2016 / 16:59
2
answers

Error compiling PocketPC project

I have the following error:    Error 1 Registration or implementation error: 0x8973190d. Failed to open file '% CSIDL_PROGRAM_FILES% \ Microsoft SQL Server Compact Edition \ v3.5 \ Devices \ wce500 \ ARMV4i \ sqlce.ppc.wce5.armv4i.CAB'. Error...
asked by 27.07.2016 / 20:09
1
answer

How to get the value of the table calling from php?

I have a problem with the following code: <table border=7 ALIGN=CENTER width="70%" bgcolor=#ffffff> <form role="form" name="registro" enctype="multipart/form-data" action="vehi-consul.php" method="post"> <TR ALIGN=CENTER&...
asked by 21.06.2016 / 18:53
1
answer

Slow Queries SQL Server Full-Text

I have created a catalog for Full-Text searches in SQL Server: CREATE TABLE [dbo].[full_text]( [client_id] [int] NOT NULL, [file_id] [bigint] NOT NULL, [page_number] [int] NULL, [contents] [nvarchar](max) NULL, [ID] [int] IDENTITY(1,1) NOT NUL...
asked by 18.05.2016 / 09:57
2
answers

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 3, current count = 4

In the following procedure stored in sql server 2012, I get the following error when I execute it with the statement: EXEC DBRepStage.dbo.spDesbloquear '172011235114','2016-03-03 09:32:52.000','xxxx','03/03/2016 11:15:53' The result is:...
asked by 18.05.2016 / 19:16
1
answer

Get a scalar in java

How can I read a scalar from java on sql server? This is my query to the database the insert works perfectly but I do not know how to read the second instruction insert into Category values('Recursos Humanos','HR') SELECT @@IDENTITY as inserta...
asked by 10.06.2016 / 23:49
1
answer

Error when using OR in JPQL

I ask for your help to help me with a query I'm doing and return me an error. I have tried it with createNativeQuery and with createQuery , but it is generating error; the idea is that it receives a parameter and that it can do the...
asked by 31.05.2016 / 19:48