Senior software architecture working over 20 years. Familiar wide range development experience as database, service, game, multiplatform etc applications.
-
Contributor of Github
- İstanbul/TR
- http://halityurttas.com.tr
- @halityurttas
- in/halit-yurttaş
Highlights
- Pro
Pinned Loading
-
Satır bazında random number üretme
Satır bazında random number üretme 1SELECT (((CAST( ABS(CHECKSUM(NewId())) % 10 AS DECIMAL) 1)/10) 1), * FROM table1
-
Remove duplicate sql (for example no...
Remove duplicate sql (for example nop commerce specification attributes) 1WITH duplicates AS (
2SELECT
3*,
4ROW_NUMBER() OVER (
5PARTITION BY SpecificationAttributeId, Name
-
List table with scheme (where in tab...
List table with scheme (where in table names) 1select schema_name(t.schema_id) '.'
2t.name as table_name,
3t.create_date,
4t.modify_date
5from sys.tables t
-
Update table with join
Update table with join 1UPDATE t1
2SET t1.CalculatedColumn = t2.[Calculated Column]
3FROM dbo.Table1 AS t1
4INNER JOIN dbo.Table2 AS t2
5ON t1.CommonField = t2.[Common Field]
-
Rename all files to lowercase
Rename all files to lowercase 1dir . -r | % { if ($_.Name -cne $_.Name.ToLower()) { ren $_.FullName $_.Name.ToLower() } }
-
copy hiearchical git diff another fo...
copy hiearchical git diff another folder 1for file in $(git ls-files --others --exclude-standard --modified); do mkdir -p d://BACKUP/unstageds/$(dirname $file) ; cp $file d://BACKUP/unstageds/$file ; done
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.