63.Static Pivot in SQL Server

63.Static Pivot in SQL Server

62.SQL Server OFFSET FETCH

61.Simple Method to Generate OTP Using Random Function

60.Computed Column in SQL Server

59.Change default databae file and backup Path in SQL Server

58.Synonym in SQL Server

57.EXCEPT / INTERSECT / UNION / UNION ALL Operators in SQL Server

56.Network-related or instance-specific error

55.Exception Handling in SQL Server

54.Scalar Value Function in SQL Server

53. Enable and Refresh IntelliSense in SQL Server Management Studio

52.Modify multiple lines at once using vertical region select

51.How to Uninstall an Instance of SQL Server

50.Connect SQL Server from Excel and retrieve data

49.Backup and Restore Database in SQL Server

48.Find and Delete duplicates Records from a table in SQL Server

47.Union and Union all

46.Create Missing Index From Execution Plan

45.DBCC CHECKIDENT RESEED

44.SQL Cloning a Table / Duplicate a Table / Backup a Table

43.How to turn IDENTITY_INSERT ON and OFF using SQL Server

42.Password Encryption and Decryption in SQL Server

41.IDENT_CURRENT vs @@IDENTITY vs SCOPE_IDENTITY in SQL Server .

40.RANK, DENSE_RANK and NTILE in SQL Server