Search In
A stored procedure is a set of one or more SQL statements that resides on Sql Server.We create stored procedure to perform repetitive tasks
Types of Stored Procedure
System Defined Stored Procedure
These stored procedure are already defined
It is a common requirement in SQL server development to update top N records in SQL server.In this blog we will see two approaches to accomplish the same.
1) Using UPDATE with TOP
UPDATE TOP (100) Table1 SET field1 = 1
However without an ORDER
The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns.
Syntax:
SELECT AVG(column-name) FR
SELECT INTO Statement:
SELECT INTO statement is used to copy data from one table into another table. We can provide a condition while using SELECT INTO statement.
Syntax:
SELECT columnname(s)
INTO new_tablename
FROM tablename
While working with SQL you always face columns with NULL values. For avoiding that you can put a check on it. NULL value is something that is different from nothing and space
ALTER proc [dbo].[sp_GetMailToEmployee]
(
@EmployeeID int
)
as
begin
INTERSECT Clause:
It works similar like union clause as it is used to combine two SELECT statements, but it returns tuples only from first SELECT statement which are common to tuples in the second SELECT statement.
Syntax:
SELECT colum
Except Clause:
It combines two select statements and return tuples from first SELECT statement which are not returned by second SELECT statement. It is used to achieve Distinct and Not In queries operation in a single clause(Except).
Syntax:
Hello readers , this is a small blog on creating animated buttons using css3. In my example, I have created four buttons using "<ul> <li>" of different color but of same size. These buttons have width and height 100%, bord
If you want to be a good businessman it is essential to learn how to do business first. Learning how to do business strategically can take some time. Many strategies and techniques can lead to a successful rise in profit and a sustainable business.&n
Getting the approval from the Apple store for iOS App sometimes become a very difficult and long task. The reason for that is threefold:
