Tuesday, July 14, 2020

SQL Server Tips & Tricks


1. Sql Server (SSMS) Tips Part 1 (You tube Video Link) (Click here for Text version Answer)
     Edit Multiple rows vertically

 2. Sql Server (SSMS) Tips Part 2 (You tube Video Link) (Click here for Text version Answer)
     Shuffle / Move Columns of result set post querying
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

  Printing Number Pattern using SQL Link for video answer: SQL: --********************* --PRINT Pattern --********************* -- 1 -- ...

  • (no title)
    Running Total & Avg or Cumulative Sum & Avg in SQL    Part - 8 Click here for you tube  answer DROP TABLE IF EXI...
  • (no title)
    Importing tables from One Server to another server  Using SQL Server Management Studio (SSMS)    Part - 12 Click here or below for...
  • (no title)
      Finding Missing Sequence Dates using SQL    Part - 28 Link for video answer: Queries: CREATE TABLE tblEmployee_HireDates (HireDate DATE) I...
  • (no title)
      Printing Star (*) Pattern using SQL    Part - 26 --********************************************************* -- 26 - Printing Star (*) Pat...
  • (no title)
      Printing Fibonacci Series in SQL    Part - 25 --********************************************************* -- 25 - Printing Fibonacci Serie...
  • (no title)
    Differences Between Truncate, Drop and Delete ( Click here for You tube video link ) Here are the major differences between Trun...
  • (no title)
    Temporary Tables in SQL Server (Temp Tables)    Part - 9 Click here or below for you tube Answer  → Temporary tables or Te...
  • SQL Interview Questions
    SQL Interview Questions 1. What is the logical order of execution of SELECT statement? ( You tube Video Link ) ( Click here for Text ve...
  • (no title)
    Find Employees Whose Salary is Higher Than  Their Manager Salary    Part - 14 YouTube Video Link: Below are the Steps to solve the Question:...
  • (no title)
    Sorting Interview Questions Part 3 Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting (Click below for y...