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)
    SQL Server Tips & Tricks Part - 2 Click here or below for you tube Answer Tip 1: Tip 1: Shuffle/Move Result set Columns post ...
  • (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)
    Running Total & Avg or Cumulative Sum & Avg in SQL    Part - 8 Click here for you tube  answer DROP TABLE IF EXI...
  • (no title)
    Differences Between Truncate, Drop and Delete ( Click here for You tube video link ) Here are the major differences between Trun...
  • (no title)
      Printing Star (*) Pattern using SQL    Part - 26 --********************************************************* -- 26 - Printing Star (*) Pat...
  • (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)
    Sorting Interview Questions Part 3 Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting (Click below for y...
  • (no title)
    Tricky CASE Statement Interview Questions  Part 6 ( Click below for you tube video answer ) A case expression can only manipulat...