Introduction
In this article, I would like to explain the fastest way to save c# data table into sql server table using user defined table type.
👉 Download project from :
🎞 video tutorial :
Basics
I have created a demo table product.
Category: Sql Server Tutorial
Joins in Sql Server
Introduction
This is an article about joins in sql server . The article covers all aspects of joins using proper examples and Venn diagrams.
What is meant by joins in SQL server ?
Joins are the commands used to combine data from two or more tables based on relation between them. The relation between them is specified using columns from each tables and relational operators like =,<,> and <>.
General Syntax : –
|
1 2 3 4 |
SELECT <column_list> FROM table_1 type_of_join table_2 ON table_1.column_name Operator table_2.column_name --Valid Operators =,<,>,<> |
Delete Vs Truncate in SQL Server
Introduction
This article is about comparing delete Vs truncate in SQL server, It is one of the most discussed topic on all SQL server forums, So there is no point in just discussing their basic difference, this article will be an elaborate one with supporting explanations.
Both delete and truncate command is used to for removing records from tables, the main difference between them lies in the way they perform this operation.
Delete Vs Truncate
Difference between delete and truncate can be summarized as below
| Delete | Truncate | |
| Command Type | DML | DDL |
| Where Condition | support | does not support |
| Reset Identity Column | no | yes |
| Acquired lock | row lock | table and page lock |
| Transaction log | for each deleted row | one log indicating deallocation of page |
| Performance(Speed of execution) | slow | much faster than Delete |
Delete Duplicate Rows in Sql Server
Article will cover some best practices on how to delete duplicate rows from sql server table.
We’ll be using a student table. Query for the table creation
|
1 2 3 4 5 6 |
CREATE TABLE tbl_Student ( rollNumber INT, studentName VARCHAR(MAX), address VARCHAR(MAX) ) |