Skip to content

Instantly share code, notes, and snippets.

View mukarramjavid's full-sized avatar
🎯
Focusing

Mukarram Javid mukarramjavid

🎯
Focusing
7 followers · 17 following
View GitHub Profile
@mukarramjavid
mukarramjavid / init-git-and-link-to-remote
Created October 23, 2024 20:36
@mukarramjavid
mukarramjavid / GetSplitString_CTE.sql
Created March 26, 2024 09:56
Split string usig delimeter in SQL SERVER
CREATE FUNCTION dbo.GetSplitString_CTE
(
@List VARCHAR(MAX),
@Delimiter VARCHAR(255),
@ElementNumber int
)
RETURNS VARCHAR(4000)
AS
BEGIN
@mukarramjavid
mukarramjavid / duplicates-records-in-sql-server.sql
Created April 7, 2023 07:13
Find Duplicates using CTE in SQL Server
;WITH CTE_RugbyLeague AS(
SELECT ProviderMatchId,TeamId,PlayerId ,ROW_NUMBER() OVER (PARTITION BY ProviderMatchId,TeamId,PlayerId ORDER BY ProviderMatchId DESC) AS ROW_NO
FROM CTE_RugbyLeague WITH(NOLOCK)
)
SELECT *
FROM CTE_RugbyLeague
@mukarramjavid
mukarramjavid / create_condition_using_sql_server_table_fields.sql
Last active March 24, 2023 07:19
SELECT CONCAT('|| oldValue.', COLUMN_NAME, ' != ', 'newValue.', COLUMN_NAME) AS dataType
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table_name]'
@mukarramjavid
mukarramjavid / comma_separeted_col_names_in_mysql.sql
Created March 24, 2023 07:16
SELECT GROUP_CONCAT("m.",COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = '[database_name]' AND TABLE_NAME = '[table_name]';
@mukarramjavid
mukarramjavid / create_json_from_sql_server_table.sql
Created March 24, 2023 07:14
SELECT '"' + COLUMN_NAME + '":'+
CASE WHEN DATA_TYPE='NVARCHAR' THEN '"'+'VARCHAR(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') ' +
CASE WHEN IS_NULLABLE = 'NO' THEN 'NOT NULL' ELSE 'NULL'END+'",' ELSE '"'+DATA_TYPE+'(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') ' +
CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE 'NULL'END+'",'
END AS JsonFormat
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table_name]'
@mukarramjavid
mukarramjavid / CSharp_linq_tree_using_sql_table_property.sql
Created March 24, 2023 07:11
SELECT
CONCAT(COLUMN_NAME, ' = x.', COLUMN_NAME,',' ) AS [type]
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table]'
@mukarramjavid
mukarramjavid / Csharp_class_properties_using_sql_server_table.sql
Last active September 8, 2023 19:38
SELECT CASE WHEN DATA_TYPE = 'bigint' THEN CONCAT('public long', IIF(IS_NULLABLE = 'YES', '? ', ' ') , COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'nvarchar' THEN CONCAT('public string', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'int' THEN CONCAT('public int', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'datetime' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'datetime2' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'bit' THEN CONCAT('public bool', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'smallint' THEN CONCAT('public Int16', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
WHEN DATA_TYPE = 'date' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set;
@mukarramjavid
mukarramjavid / wrap_columns_names_in_double_qoutes.sql
Created March 24, 2023 07:05
From this script you can able to wrap Column names of any table in double qoutes in SQL Sever
SELECT STRING_AGG(CONCAT('"',COLUMN_NAME,'"'),',') AS AsDoubleQoutesCols
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table_name]'
@mukarramjavid
mukarramjavid / comma_separeted_col_names.sql
Last active March 24, 2023 06:55
From this query you can get comma separated column names in sql server
SELECT STRING_AGG(COLUMN_NAME,',') AS ColNames
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table_name]'