Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-web]

SQL Server 2012 Web Edition is a specialized edition on SQL Server targeted towards web hosting.

As on the MSDN -

SQL Server 2012 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.

It is available under the SPLA (Services Provider License Agreement) license with Microsoft.

7 questions
1
vote
1 answer

asp net gridview resets all date fields to null when editing (using SQL Server 2012, c#, VS 2017)

ASP.NET with gridview resets all date fields to null when editing (using SQL Server 2012, c#, VS 2017) I have looked at the one post regarding this, but the answer does not resolve the problem. Code Snippet below: aspx.cs protected void…
Jim Farnworth
  • 51
  • 7
1
vote
3 answers

Cursors Or While Loop what will be a good option to work on 6,00,000+ rows data

I have a table_A where i imported a data from .csv file. I want to compare some of the columns from table_A with table_B and accordingly insert a data into a table and update a status to table_A. what should i use While loop or Cursor.. Plz do…
user8518165
  • 31
  • 8
1
vote
0 answers

Finding date difference within a string

I'm using Microsoft SQL Management Studio 2012 and I'm trying to find a function to find the date difference within a string that is grouped by another field. Below the query is grouped by Encounter. There are multiple tests per patient encounter.…
user3791638
  • 11
  • 1
0
votes
1 answer

Bulk update in SQL stored procedure with select and join in where clause

I have two tables in SQL Server 2012 with the following structure: customer - internalId - listingStatus - inactive membership - custIntneralId - regDate Here is the SELECT statement I am using: USE [dbOne] SELECT…
scocon
  • 3
  • 4
0
votes
1 answer

MS SQL Server 2012 change tracking auto cleanup not working

I enabled change tracking in my database Trans and table Employee ALTER DATABASE [Trans] SET CHANGE_TRACKING = ON ( CHANGE_RETENTION = 5 MINUTES , AUTO_CLEANUP = ON) ALTER TABLE [Employee] ENABLE CHANGE_TRACKING WITH ( TRACK_COLUMNS_UPDATED = OFF…
Dipesh Jain
  • 33
  • 9
0
votes
5 answers

Enable/Disable stored procedures

I am working with a large group of stored procedures (~300) in SQL Server 2012 Web Edition and I need to enable/disable some of the stored procedures at various times. Is there a way to create a sub-folder under "Programmability" in SQL Server…
webworm
  • 10,587
  • 33
  • 120
  • 217
-1
votes
1 answer

Move data from an on-premise SQL server to SQL Azure with Azure Data Factory

Scenario: I need to: 1) Run a job on my sql server(Source) through Azure Data Factory. 2) Maintain consistency across Sql Server 2012 (Web Edition) and SQL Azure for 7 of my tables Current Approach: I was opting to use azure data factory, but need…
Anurag Raj
  • 1
  • 3