🌌

Josiah Siegel JosiahSiegel

🌌

JosiahSiegel / quick_analysis.sql

Last active May 31, 2024 14:15

#MSSQL #Research #OneStop Quick Analysis

	SELECT
	req.session_id AS [session],
	ses.program_name AS [program],
	jobs.name AS [job],
	sqltext.TEXT AS [query],
	DB_NAME(req.database_id) AS [database],
	req.status,
	wg.name AS [resource_group],
	req.command,
	CONVERT(varchar(10), (req.cpu_time / 86400000)) + ':' +

JeremyMorgan / states.sql

Last active October 3, 2023 12:55

An SQL Query to insert 50 U.S. States into a database.Make sure your auto increment is set in MySQL, and Identity_insert is set in MS-SQL.

	CREATE TABLE [state](

	[stateID] [int] IDENTITY(1,1) NOT NULL,
	[stateCode] [nchar](2) NOT NULL,
	[stateName] [nvarchar](128) NOT NULL,

	CONSTRAINT [PK_state] PRIMARY KEY CLUSTERED
	( [stateID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY])
	ON [PRIMARY]