Chuotit - chuotit.com - Chuotit
General Information:
Latest News:
How to create an autonomous transaction in SQL Server 2008 19 Dec 2011 | 09:59 pm
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 s...
SQL Server – Database Schemas 17 Dec 2011 | 09:45 pm
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. What is a Databas...
SQL Server – Server Roles 17 Dec 2011 | 09:00 pm
When creating a new user login in SQL Server, you get the option of assigning the login one or more server roles. Server roles (not to be confused with database roles) are available for various databa...
SQL Server – Stored Procedures 17 Dec 2011 | 06:23 pm
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. A stored procedure is a precompiled ...
SQL Server – Views 17 Dec 2011 | 06:01 pm
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 t...
SQL Server – Query Designer 17 Dec 2011 | 05:49 pm
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. About The Query ...
SQL Server – SQL Scripts 17 Dec 2011 | 05:46 pm
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 databas...
SQL Server – Adding Data 17 Dec 2011 | 05:30 pm
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. Editing Table Rows We can use the “Edit Top 200 Rows” option to add dat...
SQL Server – Create a Table 17 Dec 2011 | 05:28 pm
This lesson demonstrates how to create a table in a SQL Server database using SQL Server Management Studio (SSMS). Ensuring you have the right database expanded, right click on the “Tables” icon and s...
SQL Server – Create a Database 17 Dec 2011 | 05:25 pm
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 databas...
