IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact

How to Use SQL Server Express to Store ASP.NET Session State

ASP.NET Session State SQL Server Mode provides a good way to have a persistent session, especially for server farm configuration. Here are the steps to quickly configure the environment to do so using SQL Server Express edition (because sometimes, you don't need the full-blown version of SQL Server just to track sessions). Steps Download and install SQL Server Express. Open the file, … [Read more...]

January 5, 2016 Filed Under: How To Tagged With: ASP.NET, SQL Server

How to Show Field Values as Columns in SQL Server

One of the most asked questions by users when they pull data using T-SQL is whether or not there's a way to present the values of a field they're interested in as columns instead. The answer is of course it's "Yes." You can achieve this by using PIVOT relational operator if you use MSSQL 2005 or later. Without PIVOT With PIVOT Further Reading Using PIVOT and UNPIVOT SQL Server … [Read more...]

September 22, 2015 Filed Under: How To Tagged With: SQL, SQL Server

How to reset SA password on Microsoft SQL Server

If you happen to forget your sa password, you can still recover it as long as you have access to the server. Here are the steps to do it. Steps Launch Sql Configuration Manager under Configuration Tools folder. Look for your SQL Server instance (the default is MSSQLSERVER) and stop the service. You can click the stop button while having the SQL Server (MSSQLSERVER) row highlighted or you … [Read more...]

January 23, 2015 Filed Under: Database, How To Tagged With: Microsoft SQL Server, SQL, SQL Server

Ways to Upsert a Record in SQL Server

To continue the previous post, this article demonstrates ways to do Upsert (update and insert) and how MERGE statement in SQL Server 2008 (or later) can be more efficient to perform the two operations at once. First we'll create a table for this demo. We want to do update if the Id is found on the table and insert if it's a new Id number. 1. Conventional way of doing it is by using IF … [Read more...]

July 8, 2014 Filed Under: Database Tagged With: SQL, SQL Server

Perform Update, Delete and Insert using Merge Statement

In SQL Server, a better way to perform insert, update, or delete operations on a target table based on the results of a join with a source table is by using one MERGE statement. UPDELSERT using MERGE statement It's more efficient as you're doing just one statement instead of three individual (UPDATE, DELETE, and INSERT) SQL queries. More examples can be found on the next posting, Ways … [Read more...]

July 2, 2014 Filed Under: How To Tagged With: SQL, SQL Server

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • …
  • 6
  • Next Page »
Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure