Questions tagged as 'sql'

Tagged questions
1
answer

Restarurar DataBase Data NOT Pre-Existing SQL

I have current records in a database called A_Restaurate I have Pedro, Jose, saul, Mengano, So and so in order over a thousand Old Accounts records I want to restore all that data to a New Data Base called EN_USO but this has some records wi...
asked by 20.10.2018 / 23:27
1
answer

What is the Script to move a Base data already CReada in SQL server 2008 R2?

Good day afternoons or evenings. I have a BATABASE already created in manager studio of SQL server 2008 R2, I want to move the BASEDATA (extention files .mdf and .ldf) the question is Is there a MOVE script that moves me to a new physical locati...
asked by 16.08.2018 / 04:46
1
answer

Execute SQLCMD from a JOB

Good afternoon colleagues, I need your help to know what is happening with my JOB since it does not perform the action I want. I commented that I made a Stored Procedure to send a JOB call which executes a command line SQ...
asked by 07.08.2018 / 01:46
1
answer

How to execute a query number of times?

I'm doing a table in html and php, my problem is that I'm trying to execute a query ( insert ) 'n' number of times, I'm dealing with a for . This is my code so far <?php for($ca=1; $ca<25; $ca++){ $sqlc="inse...
asked by 17.08.2018 / 17:44
2
answers

Why does it tell me that insert has more expressions than destination columns?

I hope you can help me I'm new to this ... CREATE DATABASE mundial WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'Spanish_Spain.1252' LC_CTYPE = 'Spanish_Spain.1252' TABLESPACE = pg_default CONNECTION LIMIT...
asked by 08.08.2018 / 17:26
1
answer

Detect Variable error in SQL server 2008 R2

Well I have the following Insert: INSERT INTO [PS_GameData].[dbo].[Chars] ([ServerID], [UserID], [UserUID], [CharName], [New], [Del], [Slot], [Family], [Grow], [Hair], [Face], [Size], [Job], [Sex], [Level], [StatPoint], [SkillPoint], [Str],...
asked by 04.08.2018 / 20:30
1
answer

How to format DD / MM / YYYY in a Date type field of a table in oracle?

I have a query which gets some Date type fields The result of this query is downloaded to a .csv file and what it does is that it does NOT show the date fields in DD / MM / YYYY format, try to convert them with to_char but when you sho...
asked by 25.07.2018 / 05:46
1
answer

IErrorInfo.GetDescription error with E_FAIL (0x80004005)

I have the following function which receives the path of an Excel file to open it and read it to add users, I execute it in my project from Visual Studio and it runs without problems, when I take it to the server where it should work it shows me...
asked by 24.07.2018 / 18:50
1
answer

do a correct if else in MySQL procedure?

I have a condition that will be executed depending on the data that is being sent to the procedure. This is my code: CREATE DEFINER = erp@localhost PROCEDURE sp_stockProductoMovimientoAlmacen( idProducto VARCHAR(50), operacion CHAR(6),...
asked by 21.07.2018 / 18:34
1
answer

How to do ALTER TABLE in SQL Server 2008 R2 to add IDENTITY (1,1)? [closed]

How do I add IDENTITY (1,1) to Table Query # 1 , in the UserUID column? > whose Table has pre-existing UserUID records without having to corrupt (Re-create the table) or delete the data from the pre-existing UserUID column? IMPORTAN...
asked by 21.07.2018 / 04:14