Questions tagged as 'sql-server'

1
answer

Problem Migrating MySQL Database to SQL Server

I am not able to migrate a database from MySQL to SQL Server, using Database Migration from MySQL Workbench. In SQL Server Server authentication, it uses login sa, I have already tried to reset the login password, but I could not. I also trie...
asked by 19.08.2015 / 06:47
2
answers

SQL Server: how to create range of values based on a column with monetary values

Hello, community! I need a SQL query with the values of a table field of SQL Server 2012 shown as frequency distribution. Let's say I have the field Sales (in R $), type float. The lowest sale recorded was R $ 0.01 and the highest of R...
asked by 30.11.2015 / 20:46
2
answers

T-SQL with like sensitive to case

Is it possible to query in SQL Server 2008 with like sensitive? Actually, I'm looking at a column with a list of acronyms, which represent system flags, which are case sensitive. The question is not about the performance of this search, since...
asked by 30.01.2014 / 13:46
1
answer

Create primary key in a table that already exists in sqlserver

I made the import of a txt file with six million rows into a SqlServer table. Now I want to create a primary key in it, the problem is that no column guarantees integrity, so I want to create another column with auto increment. How...
asked by 28.05.2015 / 04:49
1
answer

Error connecting to php 5.5 with SQL Server

I can not make a simple conn between sql server and php !! I have already downloaded and leave the ext folder the driver according to my version of php I already mentioned them in php.ini I rebooted And when I test the conn of this erro...
asked by 28.10.2015 / 17:20
2
answers

Error: "PHP Startup: sqlsrv: Unable to initialize module"

I'm trying to access SQL Server through XAMPP on Windows 7 64 bit but I'm not getting it, I've already followed the tutorials step by step but at the time of starting Apache it gives the error in the line below: Line that gives the error ext...
asked by 31.10.2014 / 12:13
3
answers

Query with conditions in SQL SERVER

Follow the tables below with my question I have a problem in which to make a filter where I need to pick up the posts that have the post_pai column from the post table with a value other than 0, and I also need to check if the post_addr...
asked by 17.08.2016 / 15:38
1
answer

When to use WITH (NOLOCK)?

Select * from MinhaTabela with (NOLOCK) I know colleagues who always insert the With (NOLOCK) clause in their selects and I know others who preach that NOLOCK is bad practice and should never be used. Some claim that with NOLOCK we hav...
asked by 20.05.2016 / 21:33
1
answer

SQL Server Full-Text-Search

I am developing a search using the full text search of SQL Server 2008. The search is working correctly, but there has been a need to include a feature. When you search for "Joes", the message "you meant Joseph" has to appear. I did some rese...
asked by 11.08.2015 / 16:09
1
answer

Is Visual Studio 2013 compatible with SQL Server 2014?

I connected the SQL table with Visual Studio, but at the time of wringing the table there was a message saying that SQL Server was not compatible. If not, will I have to download another Visual Studio or database?     
asked by 23.07.2015 / 20:08