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
-1
votes
1 answer

How do I combine my two queries?

I'm trying to combine these queries but having no luck. I need to be able to maintain all columns in the result. How can I do this? These are my queries: SELECT c.CustomerID, EmailAddress, LastName, FirstName, Line1 AS BillLine1, Line2 AS…
CandyCane
  • 29
  • 5
-1
votes
1 answer

T-SQL Query not returning proper results

I have a query that I want to capture Sales for Parts. I am expecting to get the full results from the Parts table and if there are no Sales for that Part in the timeframe, I want to see a 0 in the Sales column. I am not seeing that. I am just…
tsqln00b
  • 355
  • 1
  • 4
  • 20
-1
votes
1 answer

TSQL DEFAULT CURRENT_TIMESTAMP

I have the following table CREATE TABLE T3 ( DD DATETIME DEFAULT CURRENT_TIMESTAMP ) When start to insert rows to T3 via this: INSERT T3 SELECT 1; I get 1900-01-02 00:00:00.000 1900-01-02 00:00:00.000 1900-01-02 00:00:00.000 1900-01-02…
dan_l
  • 1,692
  • 2
  • 23
  • 40
-1
votes
1 answer

System.FormatException: 24201: Latitude values must be between -90 and 90 degrees

I am developing asp.net MVC4 application with Google maps API. I am using sql geography data type to store Point, polygon or polyline on the map. problem is when i am drawing small area map using polygon or polyline its working fine and saved in DB…
user2110346
  • 25
  • 1
  • 8
-1
votes
1 answer

AdventureWorks2012: For each customer, determine the number of orders created in year 2007. Show 0 for no order of that customer.

AdventureWorks2012: Sql For each customer, determine the number of orders created in year 2007. If a customer has not created any order in year 2004, show 0 for that customer. Show: customer ID, # of orders created in 2007.
user2223932
  • 13
  • 3
-1
votes
2 answers

SQL Server 2012 Error 26

I downloaded SQL Server 2012 Express. Using http://www.mssqltips.com/sqlservertip/2694/getting-started-with-sql-server-2012-express-localdb/. I created a local database. Now when I tried to connect to that database using Visual Studio 2010 it throws…
Cook
  • 71
  • 1
  • 8
-2
votes
1 answer

How to create a mobile app using xamarin connecting to a database with a form

I am new to microsoft visual studio xamarin I wanted to create a form with data source,username,database and password input test fields with a connect button to connect to a microsoft sql server database I have created the interfaces to connect to…
Thomas Koh
  • 213
  • 5
  • 17
-2
votes
2 answers

How i retrieve Data From MS SQL 2012 using Android App

I want to know is there any way to connect my android app with MS SQL Server 2012 and retrieve data from there instead of using phpmyAdmin. i know same type of question has been asked already but that was not clear and answers were not helpful as…
شبير البلوشي
  • 1
  • 1
  • 5
-2
votes
1 answer

How Table Can Be Emptied Which Has Got Related Column?

I use MSSQL 2012 Express.. There is two tables and they are related between two columns.. Suddenly one table is empty.. It happened 3 or more times.. How it can be possible?? I can't delete all rows on this table because of relation..
yusuf
  • 1,233
  • 1
  • 15
  • 29
-2
votes
1 answer

Is SQL Server 2012 express serverless

Hi I have installed Visual Studio 2012 Express Desktop. I am not sure if the sql server software that that came with Visual Studio 2012 Express Desktop is serverless or not. I have installed this at work and don't want a server installed on my…
Luke101
  • 63,072
  • 85
  • 231
  • 359
-3
votes
1 answer

SQL Server 2012 Express Connection Timeout Expired

Error Message Picture I installed SQL Server 2012 Express from scratch, but it is not working. Same problem again.
user2148324
  • 1
1 2 3
…
26
27