Articles & Tutorial for MCITP: Database Developer certification
All articles for MCITP: Database Developer certification
Tips and How Tos for MCITP: Database Developer certification
Tip for using the COUNT() function
When the COUNT(*) function is used, it includes NULL values, whereas if the COUNT(expression) function is used, it ignores NULL values. In order to avoid the counting of NULL values, a user should use the COUNT(expression) function.
continue reading "Tip for using the COUNT() function" »
What is a local system account?
A local system account is an account through which a user logs on to a system. The user can directly connect to SQL Server without providing a password. Such a user does not have the permission to connect to remote servers.
continue reading "What is a local system account?" »
What is a self-referencing table?
A self-referencing table is a table in which the table is related to itself. The type of join with which the data can be retrieved from such a table is known as self-join. The table is joined to itself by a primary key column.
continue reading "What is a self-referencing table?" »
What is the ADD COLUMN clause?
The ADD COLUMN clause is used to add a column to a table. This clause is used with the ALTER TABLE statement. The syntax of adding a new column to a table is as follows: ALTER TABLE <table_name> ADD COLUMN <column_name>
continue reading "What is the ADD COLUMN clause?" »
What is the FOR XML EXPLICIT clause?
The FOR XML EXPLICIT clause is used to display the result set of a SELECT statement in XML format. A user can perform the following actions with this clause: Display the result in a desired format. Create a parent-child relationship. Specify the elements of his choice.
continue reading "What is the FOR XML EXPLICIT clause?" »
What is the FOR XML PATH clause?
The FOR XML PATH clause is used to display the output of a query in XML format. The query() method is used to display the output. A user can use this clause to display the desired output.
continue reading "What is the FOR XML PATH clause?" »
What is the syntax of using the WITH CHECK and WITH NOCHECK arguments?
The syntax of using the WITH CHECK and WITH NOCHECK arguments is as follows: ALTER TABLE <table_name> WITH CHECK | WITH NOCHECK ADD CONSTRAINT <constraint_name> CHECK <column name=(format)> The WITH CHECK and WITH NOCHECK arguments can only be applied to the check constraint.
continue reading "What is the syntax of using the WITH CHECK and WITH NOCHECK arguments?" »
What is the XSINIL argument?
The XSINIL argument is used to display the NULL values in the XML output. It can be used with the FOR XML clause and the ELEMENTS directive. The following example will demonstrate the use of the XSINIL argument: SELECT AuthID,AuthName FROM Authors FOR XML RAW, ELEMENTS XSINIL
continue reading "What is the XSINIL argument?" »