Both primary key and unique enforce uniqueness of the column on which they are defined. But, there are some differences
Author: Dhruv Sheth
Hello friends, My self Dhruv Sheth, I have more than 10 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.
Difference between delete and truncate in sql server
Difference between delete and truncate in sql server : Truncate and Delete both are used to delete data from the
Ping in C#
Hello friends, We have already explain regarding Call method after specific time interval C#, Alert from code behind asp.net,required field validator
Call method after specific time interval C#
Hello friends, We have already explain regarding Right Join in Alert from code behind asp.net,required field validator in asp.net,Difference between
Sql Server – Find installed path and details of Data and log file for database
I have already explain regarding Right Join in SQL Server,left join in SQL,Self Join in SQL Server, RANK(), DENSE_RANK(), ROW_NUMBER() and Aggregate functions in sql
Inner Join in SQL Server
I have already explain regarding Right Join in SQL Server,left join in SQL,Self Join in SQL Server, RANK(), DENSE_RANK(), ROW_NUMBER() and
Right Join in SQL Server
I have already explain regarding left join in SQL,Self Join in SQL Server, Inner Join in SQL Server,RANK(), DENSE_RANK(), ROW_NUMBER() and
Self Join in sql server
I have already explain regarding left join in SQL,Right Join in SQL Server, Inner Join in SQL Server,RANK(), DENSE_RANK(), ROW_NUMBER() and Aggregate
The dynamic SQL statements with multiple output parameters
For single output parameter : DECLARE @PARAM_1 INT DECLARE @PARAM_2 INT DECLARE @STRQUERY NVARCHAR(MAX) DECLARE @OUTPUTPARAMETER VARCHAR(2000) SET @OUTPUTPARAMETER =
identity column in sql server
I have already explained you regarding RANK(), DENSE_RANK(), ROW_NUMBER() and Aggregate functions in sql server. Today I am going to
Change default date format in sql server
I have already explained you regarding RANK(), DENSE_RANK(), ROW_NUMBER() and Aggregate functions in sql server. Today I am going to
Aggregate functions in sql server
I have already explained you regarding RANK(), DENSE_RANK() and ROW_NUMBER(). Today I am going to explain some of the aggregate functions