Alter Table is a DDL (Data Definition Language) statement which is used to add, drop, or alter existing columns. With this statement, you can also rename a table or column and make constraints. Using a table as an example, this tutorial demonstrates alter table statements with syntax.
Category SQL Server
While browsing the web with Google Chrome or Mozilla Firefox, many users have experienced latency issues and have complained about videos and web pages loading slowly. The best solution to this problem is to disable the hardware acceleration setting which is available in the three major browsers: Mozilla Firefox, Internet Explorer, and Google Chrome.
A replace function in SQL Server is used to replace single or multiple characters with another single or multiple-character string.
SQL Server backup and restore operations are closely associated with recovery models. Recovery models are ways to manage how transactions are logged, whether or not the transaction log allows and requires backups, and what types of restore operations are possible. Recovery models helps us to bring back and preserve a database after any unexpected failure […]
By default, SQL server has added some limitations. For instance, changing data types in design mode, adding a column in the middle of two existing columns, and changing the null-ability of an existing column are not permitted to change from design mode in SQL server management studio (SSMS) because they require a table to be […]
As the number of stored procedures increases in a database, the burden of managing those stored procedures increases, too. On a production database, thousands of procedures are executed daily, so you are required to know why a stored procedure failed at a certain time. This can be done by implementing error logging and reporting within […]
Google Chrome is currently the reigning champ of the web browser war, but it is not optimally pre-configured. Follow the steps in this tutorial to use Chrome’s expanded settings to power up the performance and increase the degree of security.
The Windows operating system is full of hidden features and tricks. Using these hidden features can save you a lot of time and increase your productivity. One of the most useful features which is not widely known in Windows 7 and Windows 8 is God Mode.
You have two types of graphics memory in your computer systems: internal graphics memory and external graphics memory. The internal graphics memory is part of the system’s motherboard. The external graphics memory belongs to the hardware of a dedicated graphics card which is installed separately on the motherboard. Graphics memory is needed to run high […]
Today, privacy is a hot topic. The technique of hiding files and folders comes in handy when you are using a computer which is used by more than one person. This article will show you a techie way to hide files and folders in Windows 7 using command line.