SQL Server Summary
Recently I have got some free time and go over the knowledge about SQL Server.Write this acticle in order to review in the future.
1. Join Option
Join is important option in relational database.There are many types of Join including Inner join, Outer join and Cross join.
Some important Tips:
2. Transaction :
- Transaction Features(ACID):Atomicity, Consistency, Isolation and Durability
- Transaction Template
--Transaction Template CREATE TRANSACTION [Name] AS BEGIN TRY BEGIN TRANSACTION --Execute Code COMMIT TRANSACTION END TRY BEGIN CATCH IF(@@TRANCOUNT >0) ROLLBACK TRANSACTION END IF END CATCH
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步