thorsman99

## DataRowToXML.cs
static string RowToXML(DataRow DRInput)
{
    DataSet myDS = new DataSet();
    myDS.Tables.Add(DRInput.Table.Clone());
    myDS.Tables[0].ImportRow(DRInput);
    return myDS.GetXml(); ;
}


## InsertNotPresent.sql
Insert into [server].database.dbo.table
select src.* from table src
	left join [server].database.dbo.table sta
	ON sta.Key = src.Key
	where sta.Key IS NULL

## CurlForWindows.txt
powershell -Command "(new-object net.webclient).DownloadString('https://api.ipdata.co')"

## AvgTime.sql
Select AVG(CAST(DATEDIFF(MINUTE,B.TimeStamp,A.TimeStamp) AS int)) AvgTime
from tblLoadPoint A
OUTER APPLY (SELECT TOP 1 *
			FROM tblLoadPoint
			Where TimeStamp < A.TimeStamp
			Order By TimeStamp DESC) B

## DTwithMS.sql
PRINT (CONVERT( VARCHAR(24), GETDATE(), 121))

## CheckTable.sql
IF OBJECT_ID(N'SqlHintsDemoDB.dbo.Customers', N'U') IS NOT NULL
BEGIN
  PRINT 'Table Exists'
END

## TempTableDrop.sql
IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results

## Tbl&ColList.sql
SELECT db_name() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION,
       COLUMN_DEFAULT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
       NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE,
       DATETIME_PRECISION
FROM INFORMATION_SCHEMA.COLUMNS

## rebuildallindexes.sql
ALTER INDEX ALL ON Production.Product
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
              STATISTICS_NORECOMPUTE = ON);

## ShowForeignKeys.sql
EXEC sp_fkeys 'TableName' --Show all foreign key relationships
	static string RowToXML(DataRow DRInput)
	{
	DataSet myDS = new DataSet();
	myDS.Tables.Add(DRInput.Table.Clone());
	myDS.Tables[0].ImportRow(DRInput);
	return myDS.GetXml(); ;
	}
	Insert into [server].database.dbo.table
	select src.* from table src
	left join [server].database.dbo.table sta
	ON sta.Key = src.Key
	where sta.Key IS NULL
	Select AVG(CAST(DATEDIFF(MINUTE,B.TimeStamp,A.TimeStamp) AS int)) AvgTime
	from tblLoadPoint A
	OUTER APPLY (SELECT TOP 1 *
	FROM tblLoadPoint
	Where TimeStamp < A.TimeStamp
	Order By TimeStamp DESC) B
	IF OBJECT_ID(N'SqlHintsDemoDB.dbo.Customers', N'U') IS NOT NULL
	BEGIN
	PRINT 'Table Exists'
	END
	SELECT db_name() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION,
	COLUMN_DEFAULT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
	NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE,
	DATETIME_PRECISION
	FROM INFORMATION_SCHEMA.COLUMNS
	ALTER INDEX ALL ON Production.Product
	REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
	STATISTICS_NORECOMPUTE = ON);