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

DCL (Data Control Language)

October 06, 2024
  DCL (Data Control Language) in SQL is used to control access to data within the database. It includes commands that control the permissio...
DCL (Data Control Language) DCL (Data Control Language) Reviewed by Rikesh on October 06, 2024 Rating: 5
TCL (Transaction Control Language) SQL TCL (Transaction Control Language) SQL Reviewed by Rikesh on October 06, 2024 Rating: 5

SQL index

October 06, 2024
In SQL, an index is a database object that improves the speed of data retrieval operations on a table. Indexes are created on columns to he...
SQL index SQL index Reviewed by Rikesh on October 06, 2024 Rating: 5

SQL Cursor

October 06, 2024
SQL Cursor ek database object hota hai jo result set (query ka output) par row-by-row operations karne ki suvidha deta hai. Cursors ka istem...
SQL Cursor SQL Cursor Reviewed by Rikesh on October 06, 2024 Rating: 5

ALL SQL QUERY IN ONE PAGE

October 06, 2024
 SELECT TOP 1000 [Id]       ,[UserId]       ,[Pass]       ,[CreatedOn]   FROM [IPEA_IN].[MASTER].[UsedPass] where UserId = 'rikeshkumar...
ALL SQL QUERY IN ONE PAGE ALL SQL QUERY IN ONE PAGE Reviewed by Rikesh on October 06, 2024 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.