Skip to content
SeekTuts
    • Home
    • Blog
    • Tutorials
      • SQL
        • Database Development
          • Create Database
          • Create Table
          • Primary Key
          • Identity Attribute
          • Foreign Key
          • Unique Key
          • Default Constraint
          • Check Constraint
          • NOT NULL Constraint
          • Insert Data in Table
          • Select Data From Table
          • Filter Data From Table
          • Select Distinct Records
          • Sort Data Using Order By
          • Update Data
          • Delete Data
          • Truncate Table
        • Database Administration
          • Create SQL Full Database Backup
          • Restore Database From Full Backup
          • Import Data From Text File
          • Export SQL Table To A Text File
          • Import Data From Excel To SQL
          • Export SQL Table To Excel
          • Import Access Table To SQL
          • Export SQL Table To Access Database
          • Generate Database Script
          • Create SQL Server Login
          • Public Server Role
    • Schools
      • Computer Class 10
        • Unit-01: Programming
        • Unit-02: User Interaction
        • Unit-03: Conditional Logic
        • Unit-04: Data Repetition
        • Unit-05: Functions
      • Computer Class 9
        • Unit-01: Problem Solving
        • Unit-02: Binary System
        • Unit-03: Networks
        • Unit-04: Data and Privacy
        • Unit-05: Designing Website
      • Computer Class 8
        • Unit-01: Networks and Communications
        • Unit-02: Security Threats
        • Unit-03: Spreadsheets
        • Unit-04: Problem Solving
        • Unit-05: Programming
    • Guest Post
    • Toggle website search
    Menu Close
    • Home
    • Blog
    • Tutorials
      • SQL
        • Database Development
          • Create Database
          • Create Table
          • Primary Key
          • Identity Attribute
          • Foreign Key
          • Unique Key
          • Default Constraint
          • Check Constraint
          • NOT NULL Constraint
          • Insert Data in Table
          • Select Data From Table
          • Filter Data From Table
          • Select Distinct Records
          • Sort Data Using Order By
          • Update Data
          • Delete Data
          • Truncate Table
        • Database Administration
          • Create SQL Full Database Backup
          • Restore Database From Full Backup
          • Import Data From Text File
          • Export SQL Table To A Text File
          • Import Data From Excel To SQL
          • Export SQL Table To Excel
          • Import Access Table To SQL
          • Export SQL Table To Access Database
          • Generate Database Script
          • Create SQL Server Login
          • Public Server Role
    • Schools
      • Computer Class 10
        • Unit-01: Programming
        • Unit-02: User Interaction
        • Unit-03: Conditional Logic
        • Unit-04: Data Repetition
        • Unit-05: Functions
      • Computer Class 9
        • Unit-01: Problem Solving
        • Unit-02: Binary System
        • Unit-03: Networks
        • Unit-04: Data and Privacy
        • Unit-05: Designing Website
      • Computer Class 8
        • Unit-01: Networks and Communications
        • Unit-02: Security Threats
        • Unit-03: Spreadsheets
        • Unit-04: Problem Solving
        • Unit-05: Programming
    • Guest Post
    • Toggle website search

      Author: admin

      This author has written 71 articles
      1. Home>
      2. admin>
      3. Page 3
      Read more about the article How To Add Identity To SQL Server Table Column

      How To Add Identity To SQL Server Table Column

      In How To Add Identity To SQL Server Table Column we will learn what is identity and how to add an identity attribute to creating and altering a table.

      Continue ReadingHow To Add Identity To SQL Server Table Column
      Read more about the article How to add Primary Key Constraint in SQL Server

      How to add Primary Key Constraint in SQL Server

      In the Primary Key Constraint in SQL Server article, we learn what the Primary Key is and how to add the primary key while creating and altering the table.

      Continue ReadingHow to add Primary Key Constraint in SQL Server
      Read more about the article How To Create Alter and Drop Table in SQL Server

      How To Create Alter and Drop Table in SQL Server

      In this article, How To Create Alter and Drop Table in SQL Server we will see how to create the table, alter the table name and drop it using query and GUI.

      Continue ReadingHow To Create Alter and Drop Table in SQL Server
      Read more about the article How To Create Alter and Drop Database in SQL

      How To Create Alter and Drop Database in SQL

      In this article, we will learn how to create, alter, and drop databases in SQL Server using T-SQL and SQL Server Graphical User Interface(GUI).

      Continue ReadingHow To Create Alter and Drop Database in SQL
      Read more about the article How To Generate SQL Database Script With Data

      How To Generate SQL Database Script With Data

      In this article, we will learn how to generate SQL Database script with or without data using SQL Server Management Studio GUI (Graphical User Interface).

      Continue ReadingHow To Generate SQL Database Script With Data
      Read more about the article How to Import MS Access (.mdb) to SQL Database

      How to Import MS Access (.mdb) to SQL Database

      How to Import MS Access (.mdb) to SQL Database Earlier in How to Export SQL Server Table to Access Database post we learned how to export SQL Server table to Access…

      Continue ReadingHow to Import MS Access (.mdb) to SQL Database
      Read more about the article How to Export SQL Server Table To Access Database

      How to Export SQL Server Table To Access Database

      In this article, we will learn how to export SQL Server table data to MS Access Database using SQL Server Management Studio.

      Continue ReadingHow to Export SQL Server Table To Access Database
      Read more about the article How To Enable USB Port in Windows

      How To Enable USB Port in Windows

      In this article, we will learn how to enable USB port if it is disabled in windows. We can enable USB port either by using Registry Editor or by using Device Manager.

      Continue ReadingHow To Enable USB Port in Windows
      Read more about the article How To Disable USB Port in Windows

      How To Disable USB Port in Windows

      In this article, we learn how to disable USB port in Windows using Registry Editor or by using Device Manager.

      Continue ReadingHow To Disable USB Port in Windows
      Read more about the article How to Import Data From Excel (XLSX) to SQL Table

      How to Import Data From Excel (XLSX) to SQL Table

      In this article, we will learn how to import data from excel(xlsx format) to SQL Server table using SQL Server Management Studio Import and Export Wizard.

      Continue ReadingHow to Import Data From Excel (XLSX) to SQL Table
      Read more about the article How to Export SQL Table Data to Excel (XLSX)

      How to Export SQL Table Data to Excel (XLSX)

      In this article, we will learn how to export an SQL Server table to Excel (.xlsx) file using SQL Server Management Studio Import and Export Wizard.

      Continue ReadingHow to Export SQL Table Data to Excel (XLSX)
      Read more about the article How to Import Data From Text File to SQL Table

      How to Import Data From Text File to SQL Table

      In this article, we will learn how to import data from a text file to an SQL Server table using SQL Server Management Studio Import and Export Wizard.

      Continue ReadingHow to Import Data From Text File to SQL Table
      Read more about the article How to Export SQL Table Data To A Text File

      How to Export SQL Table Data To A Text File

      In this article, we will learn how to export SQL Server table data to a text file using SQL Server Management Studio Import and Export Wizard.

      Continue ReadingHow to Export SQL Table Data To A Text File
      Read more about the article How To Restore SQL Server Database From backup

      How To Restore SQL Server Database From backup

      In this article, we will learn how to restore a full database backup using SQL Server Management Studio Graphical User Interface.

      Continue ReadingHow To Restore SQL Server Database From backup
      Read more about the article How To Create SQL Server Full Database Backup

      How To Create SQL Server Full Database Backup

      In this article, we will learn how to take a full database backup using SQL Server Graphical User Interface.

      Continue ReadingHow To Create SQL Server Full Database Backup
      Read more about the article 10th Class Computer Unit-05: Functions

      10th Class Computer Unit-05: Functions

      In this unit, we will learn types of functions, advantages of functions, function signature, the definition of a function, and where to use these functions.

      Continue Reading10th Class Computer Unit-05: Functions
      Read more about the article 10th Class Computer New Course Data & Repetition Unit-04

      10th Class Computer New Course Data & Repetition Unit-04

      In PTB 10th Class Data and Repetition Unit-04, we will learn array, a loop structure, nested loops, and how to read and write data in arrays using loops.

      Continue Reading10th Class Computer New Course Data & Repetition Unit-04

      10th Computer New Course Conditional Logic Unit-03

      In this unit PTB 10th Class Conditional Logic Unit-03, we will learn conditional statements, selection statements and solve programming exercises and objective.

      Continue Reading10th Computer New Course Conditional Logic Unit-03

      10th Class Computer New Course User Interaction Unit-02

      10th Class Computer New Course User Interaction Unit-02 Q.1 Multiple choice questions.printf is used to print ____________________ type of data.a) intb) floatc) chard) All of them (Correct Answer)2. scanf is…

      Continue Reading10th Class Computer New Course User Interaction Unit-02

      10th Class Computer New Course ITP Unit-01

      In this unit, we will learn programming environment, tools for writing programs, who and how to write the computer program and how we get the require result.

      Continue Reading10th Class Computer New Course ITP Unit-01
      • Go to the previous page
      • 1
      • 2
      • 3
      • 4
      • Go to the next page

      SQL-Database Development

      • Create Database
      • Create Table
      • Primary Key Constraint
      • Identity Column
      • Foreign Key Constraint
      • Unique Key Constraint
      • Default Key Constraint
      • Check Constraint
      • NOT NULL Constraint
      • Insert Statement
      • Select Statement
      • WHERE Clause
      • Distinct Statement
      • Select Into Statement
      • Delete Statement
      • Truncate Statement
      • Having Clause
      • Group By Clause
      • Joins in SQL
      • Stored Procedures in SQL
      • Find Nth Highest Salary
      • Date and Time Functions
      • Row_Number() Function
      • Get Day From Date
      • Get Month From Date
      • Get Year From Date
      • Modify Date
      • IN and NOT IN Operators

      SQL-Database Administration

      • SQL Full Backup
      • Restore Full Backup
      • Export Table Data To Text File
      • Import Data From Text File
      • Export Table Data To Excel
      • Import Data From Excel
      • Export Table To Access Database
      • Import Data From Access Database
      • Generate Database Script
      • Create SQL Server Login
      • Create Database User
      • Change Schema Name
      • Public Server Role

      Categories

      Newsletter

      Get all latest content delivered to your email a few times a month. Updates and news about all categories will send to you.
      Email is required Email is not valid
      This field is required
      Thanks for your subscription.
      Failed to subscribe, please contact admin.

      SeekTuts

      SeekTuts main objective is to provide you quality education specially in computer science like Database Development and Administration, Servers Administration, and in other programming languages.

      Categories

      • Database Administration
      • Database Development
      • HTML
      • INTERVIEW QUESTIONS AND ANSWERS
      • Microsoft Excel
      • Programming in C
      • Schools
      • System Administration

      Navigation Menu

      • About Us
      • Contact Us
      • Privacy Policy
      • Terms and Conditions

      Newsletter




      Copyright 2023 - SeekTuts