Skip to content
January 27, 2023
  • Twitter
  • Facebook
  • Github
Filjan

Filjan, Inc.

Software Development

  • Home
  • Mobile Apps
    • Droid Device Info
    • Parentology – Ovulation and Period Tracking
    • Compass Pro
  • Blog
  • Portfolio
    • SuiteTalk Web Service Scheduled Application
    • School District Insurance Portal
    • School Claims, Safety, and Loss Control
    • Behavioral Health Member Portal
    • Health Benefits Portal
  • About Us
Main Menu

SQL Server

SQL Server

Primary Key

August 3, 2019December 21, 2022 - by filjan

A primary key is used to identify a record uniquely. A key is used to sort, compare and create a relationship between records. There are some basic rules to follow …

Primary Key Read More
SQL Server

Using The SQL IN and NOT IN

September 30, 2018 - by filjan

If you wanted to search a bunch of values, you would write a WHERE clause with the values joined by the OR operator. A more readable WHERE clause would be …

Using The SQL IN and NOT IN Read More
SQL Server

Renaming The Output Columns In SQL

September 10, 2018September 10, 2018 - by filjan

If you need to change the name of the column returned by a query use can use the “AS” clause. Without the AS clause, the returned column name will be …

Renaming The Output Columns In SQL Read More
SQL Server

Northwind Sample Database

October 15, 2014October 15, 2014 - by filjan

To download the Northwind sample database, go here. http://www.microsoft.com/en-us/download/details.aspx?id=23654   To download the Adventure Works sample database, go here. http://www.microsoft.com/en-us/download/details.aspx? Id=10679

Northwind Sample Database Read More
Copyright © 2023 Filjan, Inc..
Powered by WordPress and HitMag.
We use cookies to understand how you use our site and to give you the best experience. If you continue to use this site we will assume that you are happy with it.Accept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT