Questions tagged as 'sql-server'

Tagged questions
1
answer

Change language in the database during a query

Is it possible to change the language of the database only while executing an insert query? I am having problems with date conversion due to their formation, the Bank expects dd-mm-yyyy, but in the query is yyy-mm-dd.     
asked by 18.07.2014 / 21:23
1
answer

How to use the current date in a procedure?

Good evening guys. I need help. For you to understand, I'm trying to run a system procedure that asks me for some variables that I can pass them in a fixed way, but one is date. in case the date needs to be of the current day, as I want to sched...
asked by 03.04.2015 / 03:13
4
answers

Select with 3 tables in SQL SERVER

Ineedtodoaselectonthemachinetable,butwhenIexecutemycommandselectmaq.maqNip,equi.*fromtblMaquinamaqjointblEquipamentoequionequi.equId=maq.maqTipoEqui;Thefollowingresultisdisplayed and I wanted the brand name, the template, and not just your...
asked by 04.01.2019 / 15:13
2
answers

How to Migrate SQL Server Database to Oracle

I've created a diagram in sql-server , where it automatically creates the entire database structure, but I will have to migrate to Oracle. Can I migrate the entire structure (tables, FKs, PKs, etc.) with some tool? Obs. 1: There are no d...
asked by 01.04.2014 / 15:41
1
answer

Oracle migration to sql server

Can someone tell me a good data migration tool for the oracle database for the sql server database and vice versa?  I need to get lots of records from the oracle database and save it to the sql server database, I need the migration to be done in...
asked by 12.12.2018 / 19:28
2
answers

Insert procedure into three tables

Hello everyone, I am trying to change a procedure that I created to insert a new book into three tables. The table has autoencrement in the book_id column, and tables B and C are not null, I am using @@ IDENTITY to get the last value of table_id...
asked by 05.12.2018 / 12:03
2
answers

How to return empty value?

Adding any positive number to the result of a Subquery returns as null and needs to return 0 so that it can be added with the first value obtained. What can I do to get the query to return an integer value? Follow Query: DE...
asked by 27.11.2018 / 12:06
1
answer

While always returns the last record in sql server

I have a select to bring all the records that have been entered and I need to do a while to cycle through this select and give an insert in another temporary table. Only while is always bringing the last record What could be wrong?...
asked by 28.11.2018 / 13:14
1
answer

Select TD javascript

I'm developing a routine with a pivot table using javascript, where when I open the routine a button 'ADD TABLE' appears Whentheuserclicks'ADDTABLE'thetableheaderappearsandan'ADD'buttonthatisresponsibleforaddingrowstothetable. Theproblemisth...
asked by 13.11.2018 / 13:06
2
answers

registering php data in database SQL server 2008

I have a question ... I do not know if I'm putting the code correctly, I'm a beginner in php and I need a help ... I already managed to do the form that I have to write to MySql ... but now I'm messing around in a SQL Server and I can not get it...
asked by 29.07.2014 / 00:35