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

cross tabulation Msg 8120, Level 16, State 1, Line 8

I'm trying to execute the following in sql server express 2012 SELECT t, MAX(CASE ItemID WHEN 1 THEN qun ELSE '' END) AS [Item-A], MAX(CASE ItemID WHEN 2 THEN qun ELSE '' END) AS [Item-B], MAX(CASE ItemID WHEN 3 THEN qun ELSE…
Husam Khiry
  • 108
  • 2
  • 11
0
votes
1 answer

ERROR attaching adventureworks2012_data.mdf file with sql server 2012

I have been trying to add adventure works database to my SQL server 2012..I tried to attach the database using SQL Server Management Studio as follows: I Right Clicked on Databases > Attach and clicked Add... > selected the AdventureWorks2012_Data…
Akhil
  • 511
  • 1
  • 8
  • 13
0
votes
2 answers

Unable to Install SQLEXPR_x64_ENU 2012 on windows 8 (vc_red.msi)

This error occurs every time when I try to install SQL Server 2012 on Windows 8 64bit,The Feature you are trying to use is on a network resource that is unavailable SQL Server Setup has encountered an error when running a Windows Installer…
Narasegowdakr
  • 31
  • 1
  • 5
0
votes
1 answer

Cannot insert to more than one table

I am trying to execute a stored procedure via excel VBA, however the stored procedure only inserts a record into a single table and throws an error message when the other 2 records are to be inserted to their respective tables The error message is…
CBoolMe
  • 41
  • 8
0
votes
1 answer

How to pull First Date of a Fiscal Week calendar

I have a Fiscal Calendar table in SQL Server 2012 Express. I would like to be able to pull the first date of each week and display them in a row starting from next week. Meaning, I want the first row to display 9/2/2013, then 9/9/2013, 9/16/2013,…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

fetching single value form database in vb.net

this my database table id name 1   abc 2    xyz it i enter 1 then respective value "abc" display in different text box??? Private Sub butsea_Click(sender As Object, e As EventArgs) Handles butsea.Click Dim dset As New DataSet …
Parth Akbari
  • 641
  • 7
  • 24
0
votes
2 answers

Update a value from one table to another using a Proc

I have two tables with identical structure. One is a Temp table and one is the main table. The table names are PurchaseOrders_TEMP and PurchaseOrders respectively. Each day I refresh the temp table with new data and run a PROC to update the main…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

Query referencing aliased column in order by in SQLServer 2012

I have a SQL Select query that's embedded in a piece of C# code which I don't want to change. My problem is that the query executes fine on SQLServer 2008 but not 2012. The offending line of code is: Select code as SiteCode from TimeSheetContracts…
user2707324
  • 1
0
votes
1 answer

SQL Server Express - invalid cursor state after backup

I'm encountering a "strange" problem and I have no idea of what is happening (I'm new to SQL Server). I'm doing a database backup to a backup device which I created in SQL Server Management Studio. I'm running a simple query BACKUP DATABASE abc TO…
André Moreira
  • 1,669
  • 4
  • 21
  • 35
0
votes
0 answers

How to pass multiple values to a single parameter in a Reporting Services report

I have a report in Reporting Services with a text box field in a table that has a Go to report Action. I need a Parameter for specific values to be able to pass to that report. The IN (@Parameter) will not work with multiple values. I have two…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

Cannot Connect to SQL Server Express

I tried to connect to SQL Server 2012 Express through Visual Studio 2012. It was working before until yesterday when it gave this error Cannot connect to FRANCISPEDS\SQLEXPRESS. ADDITIONAL INFORMATION: The type initializer for…
Francis Pedro
  • 11
  • 3
0
votes
2 answers

How to pull most current date from two fields

I have a table that contains two Due Date fields. Sometimes they both can match, sometimes one of them is blank, sometimes one of them is greater than the other. I need how I can pull the most current Due Date into just one field from both fields.…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

How to change my SQL2012 server name to localhost?

After I installed SQL 2012 Express, I can't connect to localhost or (local) to local server. I have to put my computername/instance name in order for me to connect to server. Can anyone help me with this?
user2502947
  • 69
  • 1
  • 4
0
votes
1 answer

Developing C# Winforms software using SQL Server 2012 in Visual Studio 2012 and running it on other system without installing SQL Server 2012

I wanted to develop a C# application oriented software using SQL Server 2012 in Visual Studio 2012. But if I install the software on another computer with out installing SQL Server 2012 database, how will this software work and access the data? Is…
srinivasateja
  • 1
  • 1
0
votes
1 answer

How do I UPDATE a field from another table

I have two tables that have the same data and fields except for one. I want to UPDATE the table that is missing the field 'SBCMP'. Here is the definition of the table I want to add the field and data to: [dbo].[SalesData]( [SBLOC] [varchar](3)…
tsqln00b
  • 355
  • 1
  • 4
  • 20
1 2 3
…
26 27