tag
home / developersection / tag
Checking IF…ELSE condition in Stored Procedure SQL Server
SQL IF...ELSE Statement used to test a condition. IF...ELSE Statement using in execution of a Transact-SQL statement (Store Procedure or T-SQL) and Trigger.
SQL Server Security Tips
Some of these tips are quick and easy, others with take longer to implement. Not all of them will apply to your particular environment, and some apply to some types of server more than others. They do however apply to all versions of SQL Server.
REPLACE in an UPDATE statement
This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.
Tricks to Replace SELECT * with Column Names
You might have heard many times that one should not use SELECT * as there are many disadvantages to the usage of the SELECT *. I also believe that the
Transaction in SQL Server
In .NET environment we can define transaction boundary by Transaction object. 1. If you are using SqlClient (namespace System.Data.SqlClient) Managed
CURSOR in SQL Server
A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.
Stored Procedure in SQL Server
Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.
Difference between Function and Stored Procedure in SQL SERVER
SQL Server functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use.
Clustered – Non Clustered Indexing In Sql Server
Indexes in general increase performance by reducing I/O. Without indexes, SQL Server would always have to read all of the rows in a table to find the subset of rows that have the values specified in joins or WHERE clauses
Difference between TRUNCATE & DELETE statement in SQL Server
Truncate and Delete both is used to delete data from the table. Both these commands will only delete the data of the specified table; they cannot remo
JOIN in SQL Server
SQL JOIN's are used to query data from two or more tables, based on a relationship between certain columns in these tables.SQL joins are used to combi
CASE statement in SQL Server
The SQL Server CASE statement is a conditional statement that returns a single value based on the evaluation of a statement. CASE expressions can be u