Most voted "sql-server-express" questions
Microsoft SQL Server Express is a version of Microsoft’s SQL Server relational database management system that is free to download, distribute, and utilize. It consists of a database specifically oriented for embedded applications and smaller scale. The product traces its roots to the Microsoft Database Engine (MSDE) of the product, which was shipped with SQL Server 2000.
Learn more…22 questions
Sort by count of
-
2
votes2
answers4968
viewsError initializing SQL Server Express
I try to initialize the SQL Server service (SQLEXPRESS) and I get this error message: What can it be?
-
2
votes1
answer567
viewsSQL SERVER EXPRESS 2014 ERROR (Microsoft SQL Server, error 1225)
Good morning, all right guys? Following work with database, and we are having some problems with SQL SERVER 2014 x64, on Windows 10. I am doing the installation normally and changing the network…
-
2
votes2
answers840
viewsUpdate in a column using more than one return
I have to update a certain field of a table by subtracting from it the values returned from a select in another table. The problem I’m facing is that as select returns more than one value and I have…
-
2
votes1
answer534
viewsIs SQL Express free?
I need a database to use on a Xamarin Forms app for college. I even created in Azure, but the limitation of 32 MB is very large, because I need to store photos too. I searched and saw that has the…
-
2
votes4
answers2042
viewsSelect with 3 tables in SQL SERVER
I need to make a select in the machine table, but when I run my command select maq.maqNip, equi.* from tblMaquina maq join tblEquipamento equi on equi.equId = maq.maqTipoEqui; the following result…
-
1
votes1
answer113
viewsMultiple sharing users when installing SQL Server
I recently installed the SQL Server Express 2016 on my machine with Windows 10. After a while I realized that on the menu "Share with" windows appeared 13 new entries in format SQLEXPRESSNN, where…
-
1
votes1
answer144
viewsI made my first program and now I need to run it on the client. How do I?
I made my first program and now I need to run it on the client. How do I? I made my database with SQL Server Express 2016. My windows is 64 bits. I thought of installing the same bank in the client,…
-
1
votes0
answers40
viewsWorking with Entity Framwork and Sql Express Database
I have an application with a database connection and need to create an installer that contains the database script for it to be installed together with the application or at some point…
-
1
votes4
answers949
viewsDay and month comparison on SQL Server
I need to filter a query of every client who has a birthday between two informed dates. How can I make a comparison of dates disregarding the year registered with the client? The current…
-
1
votes3
answers283
viewsNo Fill new column as Null, yes with specified value in script
I have a specific table in the database, in it I keep information of classes that are created, swimming classes, futsal classes, weight training classes and so on, it is already in use and with…
-
1
votes2
answers421
viewsMy C# software with SQLEXPRESS Localdb database does not open on another PC, even installing all dependencies
1 - My C# software with SQLEXPRESS Localdb database does not open on another PC, even installing all dependencies. NOTE: My Development PC works perfectly. 2 - Programs I have already installed in…
c# sql-server sql-server-2014 sql-server-express sql-server-localdbasked 6 years, 3 months ago Dener Portela 9 -
1
votes1
answer45
viewsHow to make a select where the order "Group" is shown after "Child Groups"
As it is a system that contains registration of Product Groups. I want to know how to make a select that brings me the information in the following order inside SQL and ordering everything…
-
0
votes0
answers133
viewsSync Sqlserver Express 2014 with Sqlserver Localdb using C#
I’m making an application Windows Forms using C# which will be connected to a bank SqlServer Express 2014 remote, however, I need some features to be available offline due to the poor quality of…
-
0
votes1
answer1370
viewsNetwork SQL Database Communication
I have an application working perfectly with the BD in a notebook. But I would like to be able to access this database with my application through another device. So I thought I’d do this network…
-
0
votes2
answers44
viewsChanging positions of an integer
Citation I am building an sql where I have the following information yyyymmdd 20190327 is in the database as integer, I need to convert into ddmmyyyy 27032019 continuing to be an integer in select.…
-
0
votes1
answer351
viewsError trying to open SQL connection - Server Version - System.Invalidoperationexception - Connection is closed
Hello. When trying to open a connection using the class SqlConnection of lib SqlClient my class conexao - formerly null - is as follows: That class conexao is the type SqlConnection and receives the…
-
0
votes1
answer265
viewsHow to disable Identity with Linked Server?
How to disable Identity in Linked Server to not generate increment? Server table must equal local base. SET IDENTITY_INSERT [ServidorLincado].[BD_TESTE].dbo.Produto ON --Desabilita o IDENTITY INSERT…
-
0
votes1
answer711
viewsCheck the frequency of records in the table
I have a table where are saved all services performed in several cars. The key is the car plate. A car can have more than one service performed per day. And for each service performed a new service…
-
0
votes0
answers241
viewsUncaught Pdoexception error: could not find driver
I’m trying to connect the sql server with php7, insert the database data into the php class, insert the extensions into the php folder in xamp, and in php.ini, but this error appears when I run the…
-
0
votes1
answer40
viewsDoubt in self-relational table modeling
I need to make a system where the business rule is this: One card must duel against another card The same duel between two equal cards can happen more than once Each letter should contain only two…
-
0
votes1
answer346
viewsWhy does SQLSERVER Express not recognize accented words when creating a bank using sqlcmd?
Problem In some databases(SQLSERVER) I am often needing to popular the tables with some data, which usually comes from a file .txt or .xlsx, I need to do this as quickly as possible. The first thing…
sql-server-expressasked 4 years, 11 months ago Lone Tonberry 525 -
0
votes0
answers29
viewsImport Simple File by SQL Server Magement Studio giving Expired Run Time Out error
Hello. I am using the "Import Simple File" wizard from SQL Server Magement Studio to import a 2GB TXT file into a SQL Server Express database. I follow the entire process of the wizard, it…