Questions tagged as 'sql-server'

Tagged questions
2
answers

Difference in use Index Unique and Unique Constraint in Sql Server?

I would like to know what behavior / differences between a Unique Index and Unique Constraints for Sql Server ? Many should think that this does not make a difference in the database, but it does! And not only for the DBA / Administrator...
asked by 21.12.2013 / 21:37
2
answers

Difference between CROSS APPLY and OUTER APPLY?

What is the difference between CROSS APPLY and OUTER APPLY ? How do they work? In what situation can they be used? Would it be possible to show some examples?     
asked by 23.04.2014 / 18:38
2
answers

Using Laravel 4 with Microsoft SQL Server 2008

I need to connect a SQL Server 2008 database in Laravel 4. I've been searching and found no solution to the scenario I'm in. I'm using Laravel using the XAMPP (PHP 5.5.6 --with-mssql) package on MAC OS X 10.9 with FreeTDS running perfectly...
asked by 20.01.2014 / 17:29
3
answers

How to find a String from Regular Expressions

I have a field in the SQL Server 2014 database that stores the client address. The problem is that everything was stored in a single varchar field. Here are some real examples:    Antonio José Nerchis Street, 81    Street: Guaira /...
asked by 31.08.2016 / 20:09
3
answers

Difference between type text and varchar type in SQL Server

What's the difference between using type text instead of type varchar to store information in the database? Is there a performance problem? So I have a table in the database that has a text column and it several times timeout error...
asked by 17.12.2014 / 17:36
4
answers

How to display value related to combobox in the textbox?

I'm doing a project in C # and SQL Server, and I need the item selected in the combo to display the corresponding values in a textbox . Here are the codes I've tried: private void preencherCBDescricao() {...
asked by 28.11.2015 / 19:39
2
answers

How can I query for the heaviest queries in SQL Server?

In the SQL Server database, how do you know which queries have consumed most of the database resources at runtime?     
asked by 12.12.2013 / 17:31
6
answers

Which database should I use in a small desktop application?

I read a little of Meta and I thought that this question does not go far from the current rules of the site. Risking losing reputation, come on: I currently work in a small company that currently manages very sensitive data (documents, addres...
asked by 28.02.2014 / 13:10
1
answer

Format value with Brazilian currency mask

I have a stored procedure that returns me a credit amount for a certain amount of consortium. The return of this value would look like this: 167900 . But it should look like this: R$ 167.900,00 . This value I feed a <...
asked by 23.01.2015 / 12:12
5
answers

Difference between two dates in days, hours, minutes and seconds

Problem: How to perform the subtraction between two dates and return the value in Days, Hours, Minutes and Seconds in a SQL query with SQL Server 2014? Example: Dados: DataRecebimento DataEnvio 2013-11-29 11:30:40.157 2014-05-2...
asked by 11.07.2014 / 17:43