Collections of items stored at the contiguous memory. Arrays can store items of the same data type.  Why we use arrays?…

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' ORDER BY modify_date DESC

What is null in Java Script? Null represents absence of an value. It represents an object with no value. It is primi…

SELECT * FROM sys.viewS select count(*) as ProceduresCount from sys.procedures select count(*) as TablesCount from …

declare @temp varchar(max) set @temp='' select @temp=@temp+ [invoice document no#]+',' from Table …

Such errors can be resolved HTTP could not register URL http://+:8000/ServiceModelSamples/Service/. Your process does…

Delete LU FROM   (SELECT *,                Row_number()                  OVER (                    partition BY Do…

Create Proc usp_SelectItems ( @TableName nvarchar(100) ) as begin DECLARE @Sql NVARCHAR(MAX); SET @Sql = N'…

USE  dbname-- CHANGE THE DATABASE NAME only HERE, I am using dbnamefor example, rest code will as it  is GO SEL…