Questions tagged as 'sql-server'

Tagged questions
2
answers

What is the difference between varchar and nvarchar?

What's the difference between using data types varchar and nvarchar ? nvarchar exists in every SQL database? Is there any significant difference in performance between the two? Is there a criteria for using them? A...
asked by 21.06.2017 / 15:13
2
answers

PDO Drivers for SQL Server

I'm trying to run a PHP application (version 5.5.8) with the connection to the SQL Server database with PDO, but it returns the following error:    could not find driver I have tried to enable features in php.ini but to no avail! Remem...
asked by 23.01.2015 / 18:15
2
answers

Using WITH AS command on Sql Server

I have seen this example below, I would like to know how this With [name] AS command works in Sql Server, and what its uses compared to tables in memory or SubQueries , in terms of performance. With ClientesAtivos AS (...
asked by 24.09.2015 / 05:44
3
answers

What is the index for SQL Server?

For what the index serves, I know it improves performance, but what the database does behind it improves this performance. When is it recommended to use? And where should I use an index?     
asked by 05.08.2014 / 17:51
2
answers

What does the ^ = operator mean in C #?

I have a function in C #, where I decrypt a string and need to convert to a function in SQL Server for technicians to be able to work with the decrypted value. There is a foreach , which I do not understand how it works: var calculoChave...
asked by 27.01.2015 / 13:32
1
answer

What does COLLATE LATIN1_GENERAL_CS_AI do?

I'm asking this question because I came across this
asked by 02.06.2017 / 20:20
3
answers

Use VARCHAR (255) for all fields or choose the best size for each field? [duplicate]

Assuming the following fields (for example): Nome , Rua , Cidade , UF . The Nome would be the name of the client. There are people with 2 short names or people with 5 or more names, so it is possible to have a...
asked by 07.05.2018 / 02:11
2
answers

What is the limit of IN operator arguments in SQL Server?

In Oracle are 1000 arguments, what is the limit in SQL Server?     
asked by 06.12.2016 / 14:10
1
answer

Methods ExecuteReader (), ExecuteNonQuery () and ExecuteScalar (), what are the differences and how to use them?

I'm working with SQL Server database in C #, but I noticed that the SqlCommand object has several methods to execute a query , they are: ExecuteReader() , ExecuteNonQuery() and ExecuteScalar() . My question is, what...
asked by 24.10.2015 / 00:26
1
answer

Laravel 5 and Sql Server

I need a help, I made several attempts to connect Laravel with SQL Server and all without success. However, I was able to run pure php using sqlsrv_connect and Code Igniter. Windows 10 64 bits. Wampserver 2.5 32 bits. PHP version: 5.5.12 (TS,...
asked by 16.11.2015 / 18:58