Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
SQL Code: Transfer values to another column Server/SQL/SQL-Code
SQL Code: Transfer values to another column
16.11.2021 990
Transfer the data of an existing column to another column via SQL command SQL script USE [Demo] GO

SQL Server Script for adding columns with data preservation Server/SQL/SQL-Code
SQL Server Script for adding columns with data preservation
16.11.2021 859
How to add a table with a column in SQL Servers without deleting the inventory data? Adding Single Columns ALTER

Speed up the database: Clustered Index Server/SQL
Speed up the database: Clustered Index
05.10.2021 570
Speed up the database: Clustered Index Databases are significantly accelerated when indexes to tables are properly built in and extended The fastest are clusted indexes, i e indexes in which several table fields are combined as primary key

Example of SQL Syntax for Update a Table with Inner Join on SQL Server Server/SQL
Example of SQL Syntax for Update a Table with Inner Join on SQL Server
15.07.2021 748
SQL Server Update Select Inner Join Sample Example SQL Update Command in SQL Server USE [codedocu_de]

A network-related or instance-specific error occurred while establishing a connection to SQL Server. Server/SQL/Errors
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
26.06.2021 817
A network-related or instance-specific error occurred while establishing a connection to SQL Server TITLE: Connect to Server Cannot connect to sqlexpress

Add full text in a database, enable it Server/SQL/Own-Fulltext-Search
Add full text in a database, enable it
15.02.2021 1818
What do you need full text for? To significantly speed up the search for words for large amounts of data How does Fulltext work? Each record in a table is stored by SQL Server as a single word in a word directory as an internal table

Estimation of database sizes Server/SQL
Estimation of database sizes
11.02.2021 808
How big is a SQL Datenbank in Microsoft SQL Server My example is a CMS database with 4000 blog posts The database will then reach about 300MB Once you create a full text index, the size quickly doubles to 500MB

SQL Commands Server/SQL
SQL Commands
24.10.2019 1692
SQL Transact Commands the following 4 SQL commands are required when accessing data in SQL Server tables SELECT INSERT UPDATE DELETE On a SQL server, data resides in tables The SQL Server tables are listed un

Install SQL Server Express Edition and Start login Server/SQL
Install SQL Server Express Edition and Start login
24.10.2019 1859
Download SQL SErver Express Edition at: version 2017 There are 2 versions: Express Edition SQL Server 2017 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications &eg

SQL exception unhandled Server/SQL/Errors
SQL exception unhandled
19.02.2018 3717
When trying to save a URL in a SQL database using sqlclient and T-SQL Error message: System Data SQLClient SqlException: 'Incorrect syntax near

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de