If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:
“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”
All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.
Follow the screenshot below to disable it.
The if statement is used to execute code with condition. If the value of the condition is True then execute the statement else execute another statement or simply end the execution.
There are three combination of the If statement namely:
In every programming language, operators play an important role. It can be use in comparison statements like IF statement, loops statement like WHILE loops, assigning a value to a variable and a lot more.
In this tutorial I will teach you on how to rename an SQL Server Database and its filename.
For this purpose, we will use "LibSys" database on my SQL Server Management tools and rename it to "LibrarySystem". Remember that we have to rename the following:
As opposed to other tutorial, they only rename either Logical name or Filename of the database. In the case of this tutorial, we will rename all of them.
A string variable is used to manipulate any character stored in a variable you declared.
This chapter will discuss common function you can use to manipulate string variables.
Some common functions are:
The concatenation operator is very useful to combine two string values.
Example:
A variable is used to store any value that you like.
You can reuse variable in any block of code in your PHP script.
PHP variables must start with a dollar ($) sign.
PHP Variable Syntax
$variable_name = value;
Below is an example of how to use variables in PHP: