Search In
Sys Commands :
1) How to count number of procedures in a table
USE [Database_Name]
SELECT COUNT(*) as procedures FROM sys.procedures
2) How to get the attributes of procedure in a table
USE [DatabaseName]
SELECT * FROM sys.procedures where name L
Few days ago, I was creating an ASP.NET Web API by generating Entity Framework scaffolding API controller. There were simply two tables in the database Product and Title. In the edmx file, the auto-generated classes were as follows:
public p
I have database of shapes, each shape has a color and value.
There are only 6 types of shapes and each shape can be used only once for a combination. Each shape in the database also has a different value, and a different color of shape. Ther
Here we will learn how to restore the database from a backup using mysql commands
we need to follow the following steps for the process
We must have a database dump that we want to restore on the machine with the correct
database name for
During your first attempt of installing Liferay with eclipse, if you were unable to set your database configuration as MYSQL and it still shows the default database.Then there is a quick solution to this problem.
Steps that should be followed :
1.
While importing databases dump that are of large sizes in GB you may find issues with PHPmyadmin and some other clients also.
To import the database you can use the command.
mysql -uusername -p databasename < sqldump.sql
where username is the
Below are the Top Ten Joomla Extensions
1. JCE (Joomla Content Editor)
Joomla Content Editor (JCE) is probably one of the most popular Joomla extensions. Specially for those who might not be technically inclined or have issues using the default J
Test factors can be defined as the categories which can affect the components of the project.In others words we can say, for desighning the test cases the following factors are considered:
1.Correctness: Correctness is the minimum requirement of th
DROP Statement:
With the help of drop statement we can easily delete a table or a database and it is a DML(Data Manipulation Language) command.
Syntax to drop a table:
DROP table tablename;
Example:
DROP table Employee;
It will delete Employ
Good businesses nowadays employ technology in many forms, whether that be through websites, software, or even digital marketing. Profitable technology is built by highly skilled dev teams. You get what you invest, in most cases. However, there are so
