Abundant Code

  • C#
  • C++
  • Elastic Search
  • Entity Framework
  • F#
  • JavaScript
  • ASP.NET
  • C
  • Java
  • SQL Server
  • Assembly Lang
Home » SQL Server

How to Check if the table exists in SQL Server ?

December 14, 2013 by AbundantCode Leave a Comment

Do you want to know if the table exists in a in SQL Server ? . Below is a sample query that lets you know if the table exists or not. How to Check if the table exists in SQL Server ? Assume that the table name is Employee , run the below query to […]

Filed Under: SQL Server Tagged With: Check, exists, How to, SQL Server, table

Equivalent of IF Statement in SQL Server

December 13, 2013 by AbundantCode Leave a Comment

There are times when you want to perform conditional checks within a SQL Query in SQL Server . Below is a sample Query that demonstrates how to do it. Equivalent of IF Statement in SQL Server Assume that the Employee table contains a column called “Designation” and we might want to show a value 1 […]

Filed Under: SQL Server Tagged With: equivalent, How to, IF, SQL Server, Statement

What is the Difference between varchar and nvarchar in SQL Server?

December 13, 2013 by AbundantCode Leave a Comment

The SQL Server has the data type varchar and nvarchar . What is the main difference between the both ? Let’s explore it in this article. What is the Difference between varchar and nvarchar in SQL Server? varchar is a variable length and non-unicode data type which can take the 8-bit codepage. The collation of […]

Filed Under: SQL Server Tagged With: difference, nvarchar, performance, storage, varchar

How to Enable All Constraints back in the Database in SQL Server ?

December 12, 2013 by AbundantCode Leave a Comment

In one of the articles , we explained How to Disable All Constraints in the Database temporarily in SQL Server ? , let’s look at the option of how to enable back the constraints in the SQL Server Database. How to Enable All Constraints back in the Database in SQL Server ? Below is a […]

Filed Under: SQL Server Tagged With: constraints, enable, How to, SQL Server

How to Disable All Constraints in the Database temporarily in SQL Server ?

December 11, 2013 by AbundantCode Leave a Comment

There are times when you may want to disable all the constraints in the your SQL Server Database tables when importing the data from the external data source . How to Disable All Constraints in the Database temporarily in SQL Server ? Below is a sample query that lets you to quickly disable the constraints […]

Filed Under: SQL Server Tagged With: constraints, disable, How to, SQL Server, temporarily

How to Add a Column with Default Value to Existing Table in SQL Server ?

December 11, 2013 by AbundantCode Leave a Comment

Looking to add a column with default value to an existing table in SQL Server ? Below is an example and sample Data Definition Language Query for achieving the same. How to Add a Column with Default Value to Existing Table in SQL Server ? Assume that the table name is “ACEmployee” which already exists […]

Filed Under: SQL Server Tagged With: Add, Column, default value, How to, SQL Server, table

How to Update From Select Statement in SQL Server ?

December 11, 2013 by AbundantCode Leave a Comment

Below is a sample query that demonstrates how to update a table by getting the data from the select query in SQL Server. Assume that there are 2 tables AbundantCodeEmployee and AbundantCodeDepartment which contains the id . The id(in department) in this example refers to the department head . The columns “DepartmentName” is updated in the […]

Filed Under: SQL Server Tagged With: How to, select, SQL Server, Statement, Update

How to find if the Column Exists in a table in SQL Server?

June 10, 2013 by AbundantCode Leave a Comment

If you are looking to find if the column exists in a table in SQL Server, here’s a simple query to it. Assume that the table name is “Articles” and the column name is “AbundantCodeType”, below is a sample query to know if the column exists in SQL Server. How to find if the Column […]

Filed Under: SQL Server Tagged With: howto, SQLServer, tips, tutorials

What are the different Normalization form in RDBMS ?

March 6, 2013 by AbundantCode Leave a Comment

There are many different Normalization forms in RDBMS . Below are some of the most commonly used ones. 1. 1NF (1st Normal Form) 2. 2NF (2nd Normal Form) 3. 3NF (3rd Normal Form) 4. BCNF ( Boyce-Codd Normal Form) 5. ONF ( Optimal Normal Form) 6. 4NF ( 4th Normal Form)

Filed Under: SQL Server Tagged With: Normalization, RDBMS

What is Normalization ?

March 6, 2013 by AbundantCode Leave a Comment

Normalization in database is a set of technique applied to the data structures (tables) based on some predefined rules in building the database. The Normalization involves the process of organizing data in order to minimize redundancy. The Normalization generally involves splitting the database tables into multiple related tables .

Filed Under: SQL Server Tagged With: SQL Server

  • 1
  • 2
  • Next Page »
RSS
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet

Recent Posts

  • Collapsible links for subcategories in Docusaurus Sidebar
  • Python Program to Print Fibonacci Series
  • Python Program to Generate Multiplication Table
  • Python Program to Find the Factorial of a Number
  • Python Program to Print Prime Numbers in a Given Interval

Categories

Tags

.NET App Array ASP.NET ASP.NET MVC Assembly Language C# C# programs c lab programs Collection convert C program csharp database Example F# guide How to How to in Java integer Java Javascript Lab programs Lambda LINQ List Python lab programs Python programs SIC/XE SQL Server string tips tricks tutorial tutorials UWP visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 XAML

Blog Stats

  • 8,732,661 hits

Archives

Top Posts & Pages

  • C Program to Multiply Two Matrices Using Multi-dimensional Arrays
  • How to open display settings from command line in Windows 10 ?
  • System Software - SIC/XE Program to clear 20 byte string to empty
  • System Software - SIC program to set 100 elements of array to Zero
  • System Software – SIC/XE Program to arrange an array of 100 words in ascending order
  • C Program to display half-pyramid using alphabets
  • Top 10 Open source Full Text Search libraries
  • How to Convert a Stream to Byte Array in C# 4.0 ?
  • How to compare two Byte Arrays in C#?
  • System Software – SIC/XE Program to write a subroutine for SIC that writes record on to device 05

Categories

  • Android
  • Angular 2
  • ASP.NET
  • Assembly Language
  • C
  • C#
  • C++
  • Elastic Search
  • Entity Framework
  • Excel
  • F#
  • HTML
  • Interview Questions
  • Java
  • JavaScript
  • jQuery
  • Microsoft Office
  • MySQL
  • NETWORK
  • News
  • PHP
  • popular
  • PowerShell
  • Python
  • Ruby
  • SharePoint
  • SQL Server
  • SQL Server
  • Unix
  • VB.NET
  • Visual Studio
  • WebAPI
  • Windows
  • Windows Azure
  • Windows Forms
  • XAML

Top Posts & Pages

  • C Program to Multiply Two Matrices Using Multi-dimensional Arrays
  • How to open display settings from command line in Windows 10 ?
  • System Software - SIC/XE Program to clear 20 byte string to empty
  • System Software - SIC program to set 100 elements of array to Zero
  • System Software – SIC/XE Program to arrange an array of 100 words in ascending order
  • C Program to display half-pyramid using alphabets
  • Top 10 Open source Full Text Search libraries
  • How to Convert a Stream to Byte Array in C# 4.0 ?
  • How to compare two Byte Arrays in C#?
  • System Software – SIC/XE Program to write a subroutine for SIC that writes record on to device 05

Recent Posts

  • Collapsible links for subcategories in Docusaurus Sidebar
  • Python Program to Print Fibonacci Series
  • Python Program to Generate Multiplication Table
  • Python Program to Find the Factorial of a Number
  • Python Program to Print Prime Numbers in a Given Interval
  • Python Program to Check Prime Number
  • Python Program to Find the Largest Value Among Three Numbers
  • Python Program to Check If a Given Year is Leap Year
  • Python Program to Check if a Number is Odd or Even
  • Python Program to Check if a Number is Positive, Negative or Zero

Tags

.NET App Array ASP.NET ASP.NET MVC Assembly Language C# C# programs c lab programs Collection convert C program csharp database Example F# guide How to How to in Java integer Java Javascript Lab programs Lambda LINQ List Python lab programs Python programs SIC/XE SQL Server string tips tricks tutorial tutorials UWP visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 XAML