I have been asked by many customers and partners,especially those migrating from Oracle, this question: how to create an autonomous transaction in SQL Server?
It turns out to be a tricky thing to do since SQL Server doesn’t have built-in autonomous transaction support like Oracle.
Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with database schemas, and an explanation follows. Read more…
When creating a new user login in SQL Server, you get the option of assigning the login one or more server roles.
Stored procedures are a powerful part of SQL Server.They can assist programmers and administrators greatly in working with the database configuration and its data.
In SQL Server, a view is a pre-written query that is stored on the database. A view consists of a SELECT statement, and when you run the view, you see the results of it like you would when opening a table. Some people like to think of a view as a virtual table. This is because a view can pull together data from multiple tables, as well as aggregate data, and present it as though it is a single table. Read more…
In the previous lesson, we created a SQL script using SQL Server Management Studio (SSMS). In this lesson, we will look at how to write SQL scripts using the graphical query designer. Read more…
In the previous lesson, we added data to our database table using the “Edit Top 200 Rows” option. In this lesson, we will look at how to write SQL scripts to update and run queries against our database. Read more…
In the previous lesson, we created a new table in our database. We now have a database table, columns and all, but with no data. Read more…
This lesson demonstrates how to create a table in a SQL Server database using SQL Server Management Studio (SSMS). Read more…
One of the first things we should look at with SQL Server/Management Studio is how to create a database. After all, most of the tasks you perform with SQL Server will evolve around one or more databases. Read more…
Recent Comments