Database Tutorials

How to rename a query in Solution Explorer in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to rename a query, they should follow the next steps:

1. From the View menu, choose Solution Explorer.

2. In Solution Explorer, right-click the query they want to rename and click Rename …

Learn more

How to copy a query in Solution Explorer in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to copy a query, they should follow the next steps:

1. From the View menu, click Solution Explorer.

2. In Solution Explorer, right-click the query they want to copy and from the …

Learn more

How to delete a query in Solution Explorer in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete a query, they should follow the next steps:

1. From the View menu, choose Solution Explorer.

2. In Solution Explorer, select the query they want to permanently delete.

Learn more

How to verify an SQL statement in the SQL Pane in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to verify an SQL statement, they should do the next:

–¬†Right-click in the SQL Pane, and select Verify SQL Syntax from the shortcut menu.

Notes:

1. SQL Verification can detect some, but not …

Learn more

How to save a query in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to save a query, they should follow the next steps:

1. Create their query.

2. From the File menu, click Save <query_name>. A newly created query will be given a system name. …

Learn more

How to show constraint properties in the Properties window in SQL server

Developers can see properties for a constraint in the Properties window from Object Explorer, Database Diagram Designer, or Table Designer. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to see constraint properties, they should follow the next steps:

1. Select the column to …

Learn more

How to delete a check constraint in Table Designer in SQL server

Developers delete a check constraint when they want to remove the limitations on data values that are accepted in the column or columns included in the constraint expression. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete a check constraint, they should follow the next …

Learn more

How to modify a check constraint in SQL server

Developers modify a check constraint when they want to change the constraint expression or the options that enable or disable the constraint for specific conditions. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to modify a check constraint, they should follow the next steps:

1. …

Learn more

How to disable a check constraint for replication in SQL server

Developers can explicitly disable check constraints for replication, which can be useful if they are publishing data from a previous version of SQL Server. In this case developers should follow the next steps:

1. In Object Explorer, expand the table with the constraint they want to modify, and then expand the Constraints folder.

2. …

Learn more