DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE – to create objects in the database
Category: Sql Server
Retrive data from xml in Tabular Format from SQL Server
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
Fixing database is in use error while restore database from backup
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 On SQL Server 2008. How To Solve?
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
Enabling Change Data Capture (CDC) on newly added columns on underlying table
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
SQL Server Date Formats
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.
