Tips from the Team

Discussion List

• 
  Simplify String Literals with Dollar-Quoted String Literals

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Re-Compute a Table Column’s Default Value Immediately

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Re-Compute a Table Column’s Default Value

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Derive a Table Column’s Default Value from another Column

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Default a Column’s Value

  Jim_Knicely 3.4K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Display View Column Data Types

  Jim_Knicely 3.2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Insert Text Into Text

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Reset Your Session

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Conveniently Display Key Projection Info

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Generate an Auto-Incrementing Alphabetical Series Using SQL

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely October 2018
• 
  Viewing Previously Generated Explain Plans

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Display Null Query Result With an Alternate Text

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Special Date/Time Formatting

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Change the VSQL Result Set Border

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Find Which System Tables Have a Particular Column Name

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Find Which Tables Have a Particular Column Name

  Jim_Knicely 2.8K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Display Last SQL Run Time

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Renaming a View

  [Deleted User] 5.4K views 2 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Displaying the Administration Tools Process ID

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Rotating Column Data Using SQL Analytics

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Return Zero Instead of NULL

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Display the Current Statement Number Within the Current Transaction

  Jim_Knicely 2.3K views 1 comment 0 points Most recent by Jim_Knicely September 2018
• 
  Changing the Owner of a View

  Jim_Knicely 3.9K views 0 comments 0 points Most recent by Jim_Knicely September 2018
• 
  Setting Variables on the VSQL Command Line

  Jim_Knicely 2.9K views 0 comments 0 points Most recent by Jim_Knicely September 2018
• 
  Enabling Inter-Node Spread Encryption

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely September 2018
• 
  Exiting a DbVisualizer Script Following an Error

  Jim_Knicely 2.2K views 0 comments 1 point Most recent by Jim_Knicely September 2018
• 
  Exiting a vsql Script Following an Error

  Jim_Knicely 2.7K views 0 comments 1 point Most recent by Jim_Knicely September 2018
• 
  The Parts of a Session ID

  Jim_Knicely 2.2K views 0 comments 1 point Most recent by Jim_Knicely September 2018
• 
  Faster Data Loads with Apportioned Load

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely September 2018
• 
  Self-Descriptive Constraint Names

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely September 2018