Category: SQL

MS SQL Server, TSQL

Generate Guid

Flexible GUID-Generator. You can add Preamble and Suffix – use it like a Code Generator. Optional settings to get GUIDs for Windows or Linux, uppercase, with hyphens and semicolon.. Generate up to 10.000 GUIDs at once. http://newguid.dondilo.at/index.php

SQL Online Crash Course – Part 4 – Alter Table

SQL Online Crash Course – Part 3 – Select Statement, Filter, Summarize and Group Data

             

SQL Online Crash Course – Part 2 – Insert Into

SQL Online Crash Course – Part 1 – Create Table, Datatypes

You can imagine a TABLE in SQL as an Excel spreadsheet. It contains rows and columns with data in their fields. Let us create a table for pupils. The table should contain information about the pupils unique Id, the Name and the Date of Birth. The query for such a table will look like this: […]