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

How do I add missing Months?

I have a query that pulls the Sales by Customer by Fiscal Month. However, I have some Customers that did not make purchases in a given month. For those situations, I would like the MonthNum field to have a 0 for the SalesDlr value, but the…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

I need to convert a string date to an actual date

I have a Date field in a table that is an int. The value looks like this: 20130618 I want to be able to convert that to an actual date like 06/18/2013 so I can do date calculations on it. How do I convert that field?
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

Using VS2010 with SqlClient and SQL Server 2012

I'm having a little problem inserting data from my application into my database. I do not get any errors while connecting or trying to insert into the database but data just doesn't get inserted. I use Visual Studio 2010 with C# and SqlClient and…
Blank EDjok
  • 732
  • 2
  • 14
  • 33
0
votes
1 answer

Bulk Insert Type Mismatch T-SQL

Am using this BULK INSERT command to insert a csv file in SQL Server 2012 Express. BULK INSERT dbo.TS_FX FROM 'c:\fxRates.csv' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR =',\n' ); The First Row on the fxRatesCSV file looks…
GreenyMcDuff
  • 3,292
  • 7
  • 34
  • 66
0
votes
1 answer

SQL insert, delete, update

So i see that SQL has some tables which hold the newly inserted and deleted data from tables one may refer. I didn't notice such a table for updated data. I am currently working with triggers and i need to apply a trigger to an update. How do i do…
morgred
  • 969
  • 5
  • 15
  • 26
0
votes
1 answer

Need to add a calculated field using T-SQL

I have a Query that I would like to add a Calculated field to. I need to add Projected Sales for 2013. The calculation would be the current count of months divided by the total year's sales times 12. I have a field for FiscalMonthNum that is not…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

GROUP BY Month Number and Year

I have a query that produces a Month Number and a Year. I want to sort the results by the Month Number and Year. So, Month Num 1, Year 2012 is first and then 2, 2012 so on and so forth. How can I do this? SELECT a.Vendor, vn.ACNAME, …
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

Linq to Entities - Get list of all unique related entities

asp.net mvc 4, Entity Framework 5, SQL Server 2012 Express, Code First I have a Place model: public virtual int PlaceID { get; set; } public virtual ICollection Tags { get; set; } public virtual string Name { get; set; } and a related Tag…
niico
  • 11,206
  • 23
  • 78
  • 161
0
votes
3 answers

How to specify two expressions in the select list when the subquery is not introduced with EXISTS

I have a query that uses a subquery and I am having a problem returning the expected results. The error I receive is..."Only one expression can be specified in the select list when the subquery is not introduced with EXISTS." How can I rewrite…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

GUID clustered PK's faster than BIGINT and INT identity PK's on SQL Server 2012 Express?

I'm developing a database-intensive application which maintains about 5 tables. These tables contain many thousands of records each. All the tables use GUID clustered primary keys. To make it efficient, I've dropped foreign-keys between the…
Herman Schoenfeld
  • 8,464
  • 4
  • 38
  • 49
0
votes
1 answer

SQL Server 2005 mdf file on 2012

I have a SQL Server 2005 .mdf file I need to install on a server. Can I simply install SQL Server 2012 Express and attach the .mdf file without any issues, or should I stick to 2005 Express to eliminate any issues that may arise? I should also add…
user346443
  • 4,672
  • 15
  • 57
  • 80
0
votes
1 answer

Entity Framework - Eager Load Related Entities' Related Entity

I'm writing a simple database application in C# (.NET 4.5) with Entity Framework 5. I have a situation where I may or may not need to load a single entity's related entities. If it happens that I need to load the entity's related entities, I would…
HydroPowerDeveloper
  • 3,302
  • 7
  • 31
  • 38
0
votes
1 answer

Copy SQL server database with .bak

I'm trying to copy a SQL Server database in VBA (MS-ACCESS). So I got this query to create the .bak DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for…
Marc
  • 16,170
  • 20
  • 76
  • 119
0
votes
1 answer

Implementation of SQL snapshot function in SQL Express 2012

I try to create a SQL Server database snapshot (MSSQL EXPRESS 2012 SP #1) from Delphi (XE2) code. The code is executed without any problem but actually no snapshot file is created Code example : .... LoadStringfromFile(sqlFilename,…
Franz
  • 1,883
  • 26
  • 47
0
votes
3 answers

Msg 4104 using INNER JOINS - SQL SERVER 2012

I have these tables: I am trying to get the article_id, article_name, article_title, article_description and article_date from articles and username from users by using a connecting table, user_articles. I have tried this code: SELECT E.article_id,…
Brian
  • 1,951
  • 16
  • 56
  • 101
1 2 3
…
26 27