Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

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 under Tables under the SQL_Server.

 
SQL commands look up
you can call the basic SQL commands to a table with the right mouse click on a table in sql Server STudio

 
 
SELECT
Select or fetch data from a table
 
Example

SELECT [IDTest]

,[TestData]

,[DtEdit]

FROM [dbo]. [tblTest]


 
Im SQL Server Management Studio (in der

 
INSERT
With Insert you can attach data to a table. The append takes place at the end of the table.
Insert Data

INSERT INTO [dbo]. [tblTest]

([TestData] )

VALUES

('my first INSERT' )



 
UPDATE
Update updates the value to individual rows of data
Update Data

UPDATE [dbo]. [tblTest]

SET [TestData] = 'changed it'

WHERE IDTest=2



 
DELETE
Delete deletes individual rows from a table

DELETE FROM [dbo]. [tblTest]

WHERE IDTest=2



 
Mobile
SQL
»
SQL Commands
»
Install SQL Server Express Edition and Start login
»
SQL Server Warning: Data loss could occur
»
SQL Server: Default default current time
»
Instr(..) in SQL Server
»
Access, SQL : Duplikate oder doppelte Ergebnisse ausblenden mit DISTINCT
»
Verschachtelte, komplexe Abfragen mit Detailfeldern erweitern
»
Verschachteln von komplexen Abfragen
»
SELECT Abfrage als geschlossenes neues Datenset, Tabelle ausgeben
»
Kapseln eines SQL-Ergebnisses / Werte-Tabelle in einer neuen Tabelle

.

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