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 connection successful but error occured during login

I get the following errors accessing my local SQL Server 2012 Express data using VB.Net 2012. A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The…
Orintangio
  • 42
  • 6
0
votes
3 answers

How can I modify a table using SQL Server 2012 in design view

How do I modify a table with SQL Server 2012 in design view? I am not able to alter the table in design view, when I'm done with my changes it gives me the error on the image:
aman khan
  • 83
  • 8
0
votes
0 answers

Creating Universal Search with Winform and SQL Server

I need to create a universal search in a WinForms app that can search across multiple tables for certain columns and give results in categorized format. So if I type "James", I would get: - Clients James Taylor James Brown -Suppliers …
CogentP
  • 259
  • 1
  • 8
  • 17
0
votes
1 answer

ASP.NET Registration problems when inserting to 2 tables in SQL Server database

I am pretty new with ASP.NET and SQL Server so please provide support as much detail as possible, I really appreciate it. Here is my situation: I am doing the registration system for the website using ASP.NET and SQL Server 2012 Express. So when…
Ronaldinho Learn Coding
  • 13,254
  • 24
  • 83
  • 110
0
votes
1 answer

Join columns with ForeignKeys

I created an Entity-Bean which maps an order-table of my MSSQL Server 2012. So far it works fine, but I'd like to join some columns from an Article-View to provide more information for the selected articles. The order consists of several rows with…
Qohelet
  • 1,459
  • 4
  • 24
  • 41
0
votes
1 answer

Trigger on table update is firing for more than the number of rows updated

I have a trigger that is supposed to insert a new record into a audit history table (EmployeeSalaryHistory) upon the updating of the Employees table that the trigger is set to be on ON. If I do an UPDATE on Employees where all the rows in the table…
user2425056
  • 327
  • 2
  • 4
  • 14
0
votes
1 answer

Feedback for SQL DB Design

I'm trying to design a database for an application where users can submit and take tests. Here is what I got so far: https://i.stack.imgur.com/pgf7m.png I'm particularly unsure about the relation between Test_Testee and QuestionAnswer_TesteeAnswer.…
childonline
  • 1
0
votes
1 answer

Sending null parameter to querystring Stored Procedure

I have the following problem. I want to send null value to Stored Procedure with querystringparameter. This is my Stored Procedure CREATE PROCEDURE spGetAllProducts @catID int = null, @subcatID int = null AS BEGIN SELECT * FROM Products WHERE …
Kemal Umut
  • 23
  • 1
  • 9
0
votes
2 answers

Am looking for SQL conversion using substitution variables of Oracle statement

Am using SQL server 2012 and am looking for conversion of Oracle statement having substitution variable: UPDATE customers SET region = '®ion' WHERE state = '&state' Someone please help me on this.
Princess S
  • 89
  • 1
  • 1
  • 9
0
votes
1 answer

Can I use a TextAreaFor helper as an html editor?

Can I use a TextAreaFor helper to save html to a database and then load it onto a page where it is rendered?
Darren
  • 793
  • 5
  • 17
  • 30
0
votes
2 answers

how to call nested stored procedure sql

I'm trying to use the result of first stored procedure which gives me list of Proposals that are assigned to a particular expert. From that result I want the related projects of those proposals. my first query is: ALTER proc…
Salwa Mirza
  • 1
  • 1
  • 3
0
votes
1 answer

Use SQL Server database for code first migrations in ASP.NET MVC 4

I have been going around and around trying to use a SQL Server Database with code first migrations. For my latest attempt I: created a new ASP.NET MVC 4 Web Application project (yes, I want to use this template) created the model entities created…
Darren
  • 793
  • 5
  • 17
  • 30
0
votes
0 answers

Why would SQL Server 2012 SP1 installer fail when ran within a Burn boostraped setup?

I have a WiX Bundle that has an SQL Server 2012 SP1 ExePackage which correctly installs SQL Server in a VM. When booting the machine from a VHD with the same OS that works in the VM, the setup fails, yet when I run the command line specified in the…
Pablo Montilla
  • 2,941
  • 1
  • 31
  • 35
0
votes
1 answer

Looking for Query for NEXT_DAY for Oracle to SQL server 2012 migration

Looking for code in SQL SERVER 2012 to find out Next occurrence of 'WEDNESDAY' for all ORDERDATEs from ORDERS Table. I came up with the following, but it just gives the Orderdate + 7 days. Kindly help me on this. SELECT DATEADD(DD,7,…
Princess S
  • 89
  • 1
  • 1
  • 9
0
votes
1 answer

Slow SQL Connection

I am running an ASP classic website on a new dedicated server with SQL Server 2012 on it. All is running nicely but the database connection takes about 5.1 seconds to establish when a page is loaded. If the page is refreshed the connection is…
Mike Poole
  • 1,958
  • 5
  • 29
  • 41
1 2 3
…
26 27