BY TOPIC▼
SQL SERVER BLOGS▼
SQL BLOGS▼
- General (15)
- Tables and columns (11)
- Selecting data (8)
- WHERE criteria (5)
- Calculations (8)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (7)
- Programming tables (4)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (5)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Tables and columns in SQL
Showing blogs 1-11 (out of 11)
In SSMS, how to add multiple aliases to tables using the ALT key
Posted by Andy Brown on 23 March 2016
It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.
Creating computed columns in SQL tables
Posted by Andy Brown on 10 December 2012
This short blog explains how you can create calculated formulae for fields in an SQL table (known as "computed columns").
SQL Server - create databases, tables and relationships
Posted by Andy Brown on 19 November 2012
A guide to how to create databases in SQL Server Management Studio, including creating tables, indexing columns and using database diagrams to create relationships between tables.
Using SELECT INTO and INSERT to insert SQL rows
Posted by Andy Brown on 12 October 2012
There are various ways to insert data into new or existing tables in T-SQL - this blog gives examples of each.
Using T-SQL to create tables programmatically
Posted by Andy Brown on 05 October 2012
SQL doesn’t just select data; you can also use it to create tables and link them together with relationships. This blog shows you how!
T-SQL data types - int, float, decimal, varchar, etc.
Posted by Andy Brown on 05 October 2012
Whether you're creating tables in SQL Server, using SQL variables or passing parameters to stored procedures, you'll need to understand what the possible data types that you can use are.
Introduction to SQL Server Management Studio
Posted by Andrew Gould on 30 April 2012
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.
Designing databases for SQL Server and Access
Posted by Andy Brown on 23 April 2012
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!
Scheduling Data Imports in SQL Server
Posted by Andrew Gould on 27 February 2012
If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!
How to Edit all Records in a SQL Server 2008 Table
Posted by Andrew Gould on 16 February 2012
This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.
Temporary Tables in SQL - a Training Blog
Posted by Andy Brown on 20 October 2011
If you want training in how to use temporary tables in SQL, read on! This blog shows how to create temporary tables and how to drop them safely whether or not they exist. Finally, the blog lists the pros and cons of using temporary tables in SQL.