Nahidur Rahman Rifath

Here is the command for SQL update column with value from another table UPDATE t1 SET      t1.Column = t2.Column, FROM      TableOne t1      INNER JOIN TableTwo t2      ON t1.Column = t2.Column; Go

For Those who have problem using  string_split function in SQL Server 2008R2 CREATE FUNCTION dbo.string_split (     @stringToSplit VARCHAR(MAX),     @separator VARCHAR(MAX) ) RETURNS   @returnList TABLE ([value] [nvarchar] (500)) AS BEGIN  DECLARE @name NVARCHAR(255)  DECLARE @pos INT  WHILE CHARINDEX(@separator, @stringToSplit) > 0  BEGIN   SELECT @pos  = CHARINDEX(@separator, @stringToSplit)    SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)   INSERT INTO @returnList   SELECT @name   SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)  END  INSERT INTO @returnList  SELECT @stringToSplit  RETURN END

Though its a rare situation when we need to know the number of columns in a table. You can get the number of columns information for a particular table by running the following query on SQL Server SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_catalog = ' Your_Database_Name '  AND table_name = ' Your_Table_Name ' Good luck!

Those who wants to generate random dates between two date ranges in SQL Server can use the following query: DECLARE @FromDate DATETIME = DATEADD(DAY, -2, '2011-01-01') DECLARE @ToDate   DATETIME = DATEADD(DAY, -1, '2017-01-01') DECLARE @Seconds INT = DATEDIFF(SECOND, @FromDate, @ToDate) DECLARE @Random INT = ROUND(((@Seconds-1) * RAND()), 0) DECLARE @Milliseconds INT = ROUND((999 * RAND()), 0) SELECT DATEADD(MILLISECOND, @Milliseconds, DATEADD(SECOND, @Random, @FromDate)) Hope it works for you!

Many of us some times wants to know that where a specific column is located as reference to other tables or views. If this is the case for you, then you can execute the following query:  Just replace the YourColumnName with your desired column name.  SELECT      COLUMN_NAME AS 'ColumnName' , TABLE_NAME AS  'TableName' FROM          INFORMATION_SCHEMA.COLUMNS WHERE       COLUMN_NAME LIKE '% YourColumnName %' ORDER BY  TableName , ColumnName; Please note that, if you follow the convention to place every where with same column name, then it will brings good output result for you. Thanks

Sometimes we need some sql server query which is really hard to find from the internet in one place. Here in this link, you can find  50 Important Queries in SQL Server.