Advertisement

Advertisement

Results for SQL
What is SCOPE_IDENTITY() and Why we use SCOPE_IDENTITY() in SQL Server ? What is SCOPE_IDENTITY() and Why we use SCOPE_IDENTITY() in SQL Server ? Reviewed by Rikesh on December 26, 2024 Rating: 5
How to remove Foreign Key Constraint in SQL How to remove Foreign Key Constraint in SQL Reviewed by Rikesh on December 03, 2024 Rating: 5

SQL Index

November 28, 2024
 1. CLUSTER INDEX:- best optimization search on primary key.  Syntax - Create Cluster Index Ix_EmpId ON Employee(eid). 2. Non- Cluster Index...
SQL Index SQL Index Reviewed by Rikesh on November 28, 2024 Rating: 5

Rank in SQL

October 21, 2024
  In SQL, you can use the ROW_NUMBER() function to assign a unique row number to each row in the result set. Additionally, you can use RANK(...
Rank in SQL Rank in SQL Reviewed by Rikesh on October 21, 2024 Rating: 5

SQL Interview

October 07, 2024
0. How to rename column name in Sql table  ? EXEC sp_rename 'Users.PANNumber', 'PanNumber', 'COLUMN'; database  tabl...
SQL Interview SQL Interview Reviewed by Rikesh on October 07, 2024 Rating: 5
Normalization Denormalization in Sql Normalization Denormalization in Sql Reviewed by Rikesh on October 07, 2024 Rating: 5

Trigger Enable & Disable in SQL

October 06, 2024
Triggers automatically execute when you perform actions like insert, update, or delete on a table. Triggers can be used for auditing, valida...
Trigger Enable & Disable in SQL Trigger Enable & Disable in SQL Reviewed by Rikesh on October 06, 2024 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.