1.
SQL
Server Management Studio Overview
2.
Windows
Authentication in SQL Server
4.
Creating
a New User in SQL Server
5.
GRANT/REVOKE
Permissions to User in SQL Server
7.
SQL
Server Naming Conventions
9.
Adding
Columns to a Table in SQL Server
11.
Rename
Column and Table in SQL Server
12.
Drop
Columns from a Table in SQL Server
14.
Relations
between tables in SQL Server
15.
IF
ELSE Statement in SQL Server
17.
Built-in
Functions in SQL Server
18.
Insert
Data into Table in SQL Server
20.
Delete
Data from a Table in SQL Server
21.
Select
Query in SQL Server
22.
WHERE
Clause in SQL Server
23.
GROUP
BY Clause in SQL Server
24.
HAVING
Clause in SQL Server
25.
ORDER
BY Clause in SQL Server
31.
Build
Dynamic SQL Queries in SQL Server
33.
Modify/Delete
Primary Keys in SQL Server
34.
Foreign
Keys in SQL Server
35.
Modify/Delete
Foreign Keys in SQL Server
36.
Check
Constraints in SQL Server
37.
Unique
Constraints in SQL Server
39.
Modify/Delete
Views in SQL Server
41.
Stored
Procedures in SQL Server
42.
Stored
Procedure Parameters in SQL Server
44.
Non-clustered
Indexes in SQL Server
45.
Modify/Delete
Indexes in SQL Server
47.
LOGON
Triggers in SQL Server
48.
DDL
Triggers in SQL Server
49.
Enable/Disable
Triggers in SQL Server
50.
Modify/Delete
Triggers in SQL Server
53.
How
to Reset Identity Column Values in SQL Server
54.
How
to Find Gaps in Identity Column Values in SQL Server
55.
DateTime
vs DateTime2 in SQL Server
56.
Difference
between Functions and Stored Procedures in SQL Server
0 Comments