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

SQL Server 2012 Express Database Engine Service failed

I am currently taking a class for SQL. The class requires me to download SQL Server 2012 Express W/tools. I am have an issue with the download that is causing all sorts of problems and I am stumped. This part is not graded or anything, it is just to…
Derrick Wearmouth
  • 1
  • 1
  • 1
0
votes
1 answer

how to find what values were passed onto a store procedure at the last run

My web application is calling a store procedure but not returning the desired results in the ASP.net page. When i execute the store procedure in sql server by providing the same values, i get the desired result. Is there any way i could tell what…
GROVER_SYAAN
  • 355
  • 1
  • 5
  • 18
0
votes
0 answers

Error while deploying thee cube in SSDT SQL 2012

I have created a simple cube through SSDT of SQL Server 2012. While trying to deploy the cube below exception is thrown: Error 11 The project could not be deployed to the 'ARW-MUM-WK-1022' server because of the following connectivity problems : …
Dhanish Jose
  • 739
  • 1
  • 8
  • 19
0
votes
3 answers

select record with any kind of writing a username / field

I want to create a sql statement which does accept any writing of an given name select * from Mytable where username='Peter'; I did not take care in the database to write Peter the correct way. Now I also want to select records with this content :…
Franz
  • 1,883
  • 26
  • 47
0
votes
1 answer

How to use Triggers in SQL Server 2012 to archive and delete

I will be honest, I know nothing about SQL Server other than what I have tried to pack into my brain in the last two days.... I have found a couple of scripts on your website that sounded like they would work What are ways to move data older than…
user3155025
  • 1
  • 1
0
votes
0 answers

cte doesn't show parentid correctly

db: menuid Name Url Parentid Value 1 Products node NULL 0 2 Windows node …
user3139644
  • 1
0
votes
1 answer

SQL Server 2012 Express / VB.NET Database Application Issue

Please forgive me if I am overlooking something really obvious here, as I am totally new to programming. I have spent the last couple of days trying to troubleshoot an issue I have been having. Long story short, I have a CRM app that I am building…
ocsean
  • 35
  • 7
0
votes
2 answers

How to create a unique ID for each database entry from multiple users

I am working on a c# program that will be used by 20 to 60 users concurrently. The users will input information into various text fields and select from combo boxes and then save the information to a shared database. My question is how can I create…
Bob Ezuba
  • 510
  • 1
  • 5
  • 22
0
votes
1 answer

SQL Server - Pass Table as Parameter to function within select

Have setup a TableType as create type KeyPairTable as Table (KeyValue nvarchar(50), [Description] nvarchar(500)) I have a table which can be simplified to create table Elements (SharedKey int, …
Mark Milford
  • 1,180
  • 1
  • 15
  • 32
0
votes
1 answer

How do I utilize a multi-value Parameter in a query for SSRS report?

I am working on a report in SSRS that has a Parameter that can have multiple values. I can pass one Parameter value to the query just fine. I am using IN @Paramter in the query for multiple values and I also made the Parameter accept multiple…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

delay the commit of multiple sql queries

so i have this wierd question.. as fare as i know, the database server got a validation process to only commit new data, when the data is all stored. now my question is, can i run multiply sql queries, and delay the commit, until all queries have…
Droa
  • 427
  • 7
  • 15
0
votes
1 answer

Sql Server Times Out Twice - Connects on 3rd Attempt

I have a WinForms application installed on multiple PCs in an office, and a SQL Server 2012 Express database on the server to which the client application connects. Each machine fails to connect on the first two attempts giving an error - Timeout…
PJW
  • 5,197
  • 19
  • 60
  • 74
0
votes
1 answer

UPDATE column from one table to another

I need to update a column in a table to the latest date/time combination from another table. How can I get the latest date/time combination from the one table and then update a column with that date in another table? The two tables I am using are…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

SQL Server 2012 Express Edition Database Size

We have a requirement in our project to store millions of records(~100 million) in database. And we know that SQL Express Edition 2012 can maximum accommodate 10GB of data. I am using this query to get the actual size of the database - Is this…
Subasish
  • 92
  • 11
0
votes
2 answers

How do I JOIN another table to this code in SQL?

I need to JOIN a table named IB to the code below. I need to pull in the following fields from IB: QOO, QOH, QCM and AVG. The JOIN conditions are IJ.IJITEM = IB.IBITEM and IJ.IJLOC = IB.IBLOC ;WITH cte AS ( SELECT IJLOC, IJITEM,…
tsqln00b
  • 355
  • 1
  • 4
  • 20
1 2 3
…
26 27