Loading
Topic
SQL Operations
3 posts about SQL Operations by 3 contributors.
Know SQL Operations? Share what you know with developers who are learning it.
+ Follow SQL OperationsBe the first to follow this
- Articles
- 3
- Contributors
- 3
Everything about SQL Operations
- Article · SQL Server
Differences Between TRUNCATE and DELETE in SQL Server
Learn the key differences between TRUNCATE and DELETE in SQL Server, two commands used to remove data from tables. Understand their syntax, performance impact, transaction logging, and use cases.
- Article · SQL
Inner Join vs Cross Apply and Left Outer Join vs Outer Apply
In SQL, INNER JOIN and CROSS APPLY differ in functionality; INNER JOIN merges rows based on a condition, while CROSS APPLY uses a table-valued function for dynamic row operations. LEFT OUTER JOIN includes unmatched rows as NULL, whereas OUTER APPLY combines this with table-valued functions for enhanced flexibility.
- Article · C#
Real Life SQL and .NET: Part V
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
