Questions tagged as 'sql-server'

Tagged questions
0
answers

Doctrine2 + pdo_sqlsrv createQueryBuilder Order By with varchar field does not work

I'm creating a method that gets values for createQueryBuilder () coming by parameters. I tested it in my local database with pdo_mysql driver and it worked perfectly, by ordering both an int (id) field and a varchar (title) type field. Howe...
asked by 02.12.2015 / 20:44
1
answer

microsoft sql server connection and configuration in php

I'm trying to connect to a microsoft sql server database using php. The php version is: PHP Version 5.6.3 and the error it gives is    Fatal error: Call to undefined function mssql_connect () in C: \ xampp \ htdocs \ aloha.php on line...
asked by 02.12.2015 / 14:34
1
answer

How to modify the user and the server folder in SQLServer 2014

I would like to know how to modify the user and the password of the server and it is possible to modify the place where the server is saved after installing the SQL server 2014 in windows 10. I have already looked at several sites but not I foun...
asked by 26.01.2016 / 16:14
1
answer

Sort by position of edited record (sql server)

When I enter a new record, I sort it by the last record entered. SELECT TOP(50) * FROM TB_CLIENTE_FORNECEDOR where status <> 'S' order by IDCLIENTEFORNECEDOR desc If I'm editing a record whose id is 10, I want to sort by this id.    ...
asked by 11.10.2015 / 02:49
1
answer

How to delete a table from the "memory" of SQL Server

I had a table called tb_established in a SQL Server database and deleted it, when trying to create a table with the same name the system return error stating that it already exists, how do I erase the table from the database memory?     
asked by 09.11.2015 / 23:31
2
answers

Doubt using RIGHT JOIN on Sql Server

How could I return the results of these three tables, even if I did not have a relationship between them. Thank you SELECT A.IDPLANOCONTAS, A.NUMERO_CONTA AS NUMERO_CONTA1, A.DESCRICAO_CONTA AS DESCRICAO_CONTA1 , A.OPERACAO AS OPERACAO1,...
asked by 01.10.2015 / 04:49
1
answer

.Parameters.Append .CreateParameter is not passing the second parameter

I have a system in ASP Classico, and I'm trying to execute a SQL Server procedure passing two parameters. I originally passed only one selected date in a datepicker and it worked, now I want to pass an int value obtained in a combo (containin...
asked by 10.09.2015 / 15:46
0
answers

Installation MSSQL 2014 express or MSSQL 2016 PREVIEW

I have the following problem .. I installed MSSQL 2016 Preview on a server that can only access via Terminal Service Windows Authentication - Administrator The problem is that everything I encounter to help install MSSQL says that I have...
asked by 20.10.2015 / 00:30
0
answers

Sql Server 2008 - Error: Object reference not set to an instance of an object?

I was using sql server 2005, after updating, all databases do not allow the visualization of tables in Design mode, and does not let you create new tables. Itriedtocreateatableinavisualwayanditgavemethiserror,doesanyoneknowhowtosolveit?Than...
asked by 28.07.2015 / 03:01
1
answer

Backup SQL SERVER database

I have a database stored on the client server. I have access only the connection string of this database, so I can manage it, how can I back up the bd on the Server to My Local machine , for testing? / p>     
asked by 21.07.2015 / 16:22