Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
3
votes
0 answers

How to encrypt a *.mdf file with a password with LocalDb?

I have a .mdf database file created with Visual Studio 2012 using Entity Framework. I tried to secure my database with a password but I don't find a way to do that, please help me. Thanks in advance
Henka Programmer
  • 433
  • 6
  • 18
3
votes
1 answer

Having a basic SQL issue using microsoft sql server 2012

I am new to SQL statements and I am guessing this is something obvious so I apologize ahead of time for the newbie question. Here is the code: use test; declare @time_24_2 int; declare @hours_diff_2 int; SELECT end_date_full FROM …
Bryce
  • 447
  • 2
  • 9
  • 24
3
votes
1 answer

*= and =* sql operators

There are *= and =* sql equalities in my application queries. What does it mean? I have investigated on google but i could not find sufficient information. For example : SELECT ODR_YO_ID, OGR_OKUL_NO, OGR_ADI+' '+OGR_SOYADI OGR, COUNT(ODR_YO_ID)…
rockenpeace
  • 1,011
  • 5
  • 18
  • 29
3
votes
1 answer

SQL Server 2012 Express checking and silent installation

We need to perform the following using InstallShield 2013, can someone please guide me: Check if SQL Server Express is installed in the user's machine or not. If present, what is the version that is present. If the version is not 2012, then we need…
Tech Solver
  • 513
  • 1
  • 5
  • 16
3
votes
1 answer

How to modify table once its created in sql server 2012?

I m trying to modify table its give me the following error: There is no data in this table.
aman khan
  • 83
  • 8
3
votes
1 answer

Add rows to SQL Server database from xml file

I'm busy converting a website from xml file base to a SQL Server 2012 express database, now I've managed to get most of the tags from the xml to import into SQL Server without hassle My issue now lies with a particular section of these xmls This is…
NapalmKnight
  • 33
  • 5
3
votes
1 answer

Import/Update data from Excel to SQL Server

I'm converting a database from Excel onto MS SQL server and am basically clueless. The Excel file has column headings of GroupID, Name, Members, Remarks The SQL table has the same fields. When I update the SQL some records are totally new, so need…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
3
votes
2 answers

Does SQL Server 2012 work with Visual Studio 2008 applications?

Does SQL Server 2012 or SQL Server Express 2012 work with Visual Studio 2008 applications?
xpda
  • 15,585
  • 8
  • 51
  • 82
3
votes
1 answer

Can I develop in SQL Server Express for later deployment in a full SQL Server?

Very new to SQL Server. I am needing to develop a SQL Server database to run with an iPhone app I am developing. It will ultimately be running with our full-fledged SQL Server database, which is administered by our IT guy, but I'd like to have a…
Bill Norman
  • 883
  • 11
  • 29
3
votes
2 answers

microsoft sql server 2012 express edition - limit of concurrent inserts

Is there any limit on the number of concurrent inserts when using Microsoft Sql Server 2012 express edition ? I am aware that are limitations on the number of cpus that can be use, the 1GB of Ram limitation and the 10GB disk space limitations (more…
cristian
  • 8,676
  • 3
  • 38
  • 44
2
votes
2 answers

Map JSONObject to SQL server

I know the title is quite cliched, but it is not about storing JSON data in SQL Server. I have a JSONArray with JSONObjects with keys that match the column names in SQL Server 2012. I want to save the data to the database into the proper columns. I…
Penman
  • 163
  • 3
  • 14
2
votes
1 answer

How to manage multiple tables, function, stored procedures and views (SQL Server)

I have multiple object in my database and i would like to list them give some description, accepted parameters and their types. The fastest way I know is to generate a database script and call it a day, but is there an easier way to archive this? I…
shanji97
  • 71
  • 1
  • 7
  • 19
2
votes
2 answers

Get size of an inserted row in SQL Server

I would like to know if there's a way to find out the total number of bytes used by a specific row in SQL Server. I am able to get the maximum row size by calculating the sum for all nvarchar columns, but it creates an issue when we have a…
Nitesh
  • 2,286
  • 2
  • 43
  • 65
2
votes
2 answers

Insert 2 values from two different tables into one table

I have a problem with insert 2 values from 2 different tables during inserting to third table. First table is: author_id (PK) author_name author_email Second table is: category_id (PK) category_name Third table…
n3stis
  • 37
  • 5
2
votes
2 answers

SQL Server 2012 Installation Error on Windows 2008 Server

I am facing an error while trying to install SQL Server 2012 EXPRESS ADVANCED EDITION(32bit) on Windows Server 2008 Enterprise(64bit). After passing Rule Check, at install updates section, error occurs about update could not be downloaded. On…
Hemal
  • 3,682
  • 1
  • 23
  • 54
1 2 3
…
26 27