July 4, 2022
  • 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
Home2019January

Month: January 2019

SQL Server

Remove SQL Server new line feed

January 13, 2019

How to remove SQL Server new line? This post propose a simple SQL Server query to process a string variable and remove the new line character. Technically we replace the new line by …

Follow Us

Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
WhatsApp

SQL Server Database

  • Empty the SQL Server transaction log to fix error 9002
    January 3, 2022
  • Create SQL Server database with a script
    June 17, 2021
  • Time economy is key when you create a SQL Server partition.
    Create a new database with SQL Server Management Studio
    June 16, 2021
  • Delete SQL Server database with a script
    June 15, 2021

SQL Server functions

  • Manage SQL Server user defined functions
    October 20, 2018
  • How to create a SQL Server function ?
    October 19, 2018
  • How to call a SQL Server function?
    October 18, 2018
  • How to modify a SQL Server function?
    October 17, 2018
  • How to delete a SQL Server function ?
    October 16, 2018

SQL Server stored procedures

  • Execute SQL Server procedure with parameters
    January 11, 2022
  • Create a SQL Server stored procedure
    August 16, 2020
  • Alter a SQL Server stored procedure
    August 15, 2020
  • Create a SQL Server stored procedure with parameters
    August 14, 2020

SQL Server Tables

  • Empty a table with truncate table in SQL Server
    January 8, 2022
  • List all SQL Server tables with a query
    December 29, 2021
  • Create a SQL Server table
    June 19, 2018
  • Create table with primary key in SQL Server
    June 18, 2018
  • Create a customer table with SQL Server
    June 18, 2018
  • Modify a SQL Server table
    June 17, 2018
  • Delete a SQL Server table
    June 16, 2018
  • Check if SQL Server table exists before delete
    June 15, 2018

SQL Server Views

  • Create a view with SQL Server
    July 19, 2020
  • Create partitioned view in SQL Server
    July 18, 2020
  • How to delete a SQL Server view?
    July 16, 2020
  • How to modify a SQL Server view?
    June 17, 2020

SQL Server Indexes

  • Clustered index in SQL Server
    August 21, 2020
  • Create an index in SQL Server
    August 19, 2020
  • How to list all SQL Server indexes?
    August 19, 2020
  • How to rebuild a SQL Server index?
    August 18, 2020
  • How to reorganize a SQL Server index?
    August 17, 2020
  • How to disable a SQL Server index?
    August 16, 2020
  • How to drop a SQL Server index?
    August 15, 2020

SQL Server partitions

  • Create a SQL Server table partition
    August 26, 2020
  • What is a SQL Server table partition?
    August 24, 2020

POPULAR POSTS

  • Calculate last month value in DAX with Power BI
    September 3, 2020
  • Time economy is key when you create a SQL Server partition.
    Create a SQL Server table partition
    August 26, 2020
  • SQL Server Violation of unique key constraint
    May 31, 2017
  • Delete Windows files recursively in cmd
    January 27, 2022

LATEST POSTS

  • Delete Windows files recursively in cmd
    January 27, 2022
  • Delete a file in Windows cmd
    January 26, 2022
  • Ralph Kimball’s bottom-up business intelligence modelling
    January 25, 2022
  • Download and install the OLEDB driver for Excel 2010
    January 24, 2022

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