DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE – to create objects in the database
If you have a table structure like following : stdData contain following data: ‘<student> <row> <subject>Physics</subject> </row> <row> <subject>Biology</subject> </row> </student>’ For retrieving all
When performing a full restore over an existing database, SQL Backup sometime report that the database cannot be restored because it is currently in use,
Saving changes is not permitted occurs when doing alter table (table structure is changed): change data type on existing columns or change allow nulls on
When CDC is turned ON against a table and the underlying table schema changes, such as adding/removing a column, changing datatype etc, these changes are
One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format.