June 3, 2023
  • Facebook
  • Twitter
  • Youtube
Expert-Only

  • Database
    • Create database with SQL Server Management Studio
    • Create SQL database with a script
    • Drop SQL Server database script
  • Tables & views
    • Table
      • Create SQL Server table
      • Create table with primary key
      • Create customer table
      • Alter SQL table
      • Truncate SQL Server table
      • Drop SQL table
      • Check if SQL table exists
    • View
      • Create SQL Server view
      • Alter SQL view
      • Drop SQL view
      • Create SQL partitioned view
  • Procedure & functions
    • Procedure
      • Create stored procedure
      • Alter stored procedure
      • Create procedure with parameters
    • Function
      • Manage SQL function
      • Create SQL function
      • Call SQL function
      • Alter SQL function
      • Delete SQL function
  • Indexes & partitions
    • Index
      • Clustered SQL index definition
      • Create SQL index
      • Rebuild SQL index
      • Reorganize SQL index
      • Disable SQL index
      • Drop SQL index
      • List all SQL indexes
    • Partition
      • SQL Server partition definition
      • Create SQL table partition
  • MS Office tips
    • Excel tips
      • Best cell selection shortcuts for Excel
      • Display the day in all letters with Excel
      • Excel shortcut to select an entire column
      • Disable the direct edit option in Excel
      • Turn off Excel Scroll Lock option
    • Word tips
      • Create an automatic table of contents with Word
      • Delete a horizontal line in Microsoft Word
      • Insert a comment in Word margin
  • IT concepts
    • Dimension table definition in Business Intelligence
    • DSS or Decision Support System definition
    • EPM or Enterprise Performance Management definition
    • OLTP and Transactional Databases definition
  • MS-DOS commands
  • Useful SQL
    • Insert into from a select query
    • SQL Server insert or update query example
  • Time and dates
    • Display full month name in SQL Server?
    • Time difference in hours minutes
  • Strings
    • Split text after character with SQL Server Substring
    • Remove SQL line break from text
    • Split long SQL Server text in lines
  • SQL Server
    • SQL Server Abbreviations
    • SQL Server Downloads
    • SQL Server Errors
  • DAX functions
Home2017May

Month: May 2017

SQL Server Strings

Split a delimited text with SQL Server

May 31, 2017

How to split a delimited text in SQL Server? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of …

SQL Server

Display SQL Server version with a query

May 31, 2017

How to display the SQL Server version exact number with a simple SQL Server query? Using SQL Server Management Studio, to get the exact version of the SQL Server installation, it is possible …

SQL Server Errors

SQL Server Violation of unique key constraint

May 31, 2017

How to insert or update data in an SQL Server table with a simple query? Here are two simple solutions to execute an update or insert and avoid errors. The SQL Server error …

SQL Server Time and Dates

SQL Server time difference in hours minutes and seconds

May 30, 2017

How to calculate the time difference in hours minutes or seconds in SQL Server? The SQL Server function DATEDIFF() allows us to calculate the difference between two timestamps, but only in one unit. …

SQL Server Errors

Invalid object name SQL Server CTE Error

May 30, 2017

How to execute multiple SELECT queries on the same CTE? As a reminder, a CTE is a temporary object that only exists between its creation and the first time it’s used. It means …

2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.

x
x