Pinned

1. Satır bazında random number üretme Satır bazında random number üretme

   1

   SELECT (((CAST( ABS(CHECKSUM(NewId())) % 10 AS DECIMAL)+1)/10)+1), * FROM table1

2. Remove duplicate sql (for example no... Remove duplicate sql (for example nop commerce specification attributes)

   1

   WITH duplicates AS (

   2

   	SELECT

   3

   	*,

   4

   	ROW_NUMBER() OVER (

   5

   	PARTITION BY SpecificationAttributeId, Name

3. List table with scheme (where in tab... List table with scheme (where in table names)

   1

   select schema_name(t.schema_id) + '.' +

   2

          t.name as table_name,

   3

          t.create_date,

   4

          t.modify_date

   5

   from sys.tables t

4. Update table with join Update table with join

   1

   UPDATE t1

   2

     SET t1.CalculatedColumn = t2.[Calculated Column]

   3

     FROM dbo.Table1 AS t1

   4

     INNER JOIN dbo.Table2 AS t2

   5

     ON t1.CommonField = t2.[Common Field]

5. Rename all files to lowercase Rename all files to lowercase

   1

   dir . -r | % { if ($_.Name -cne $_.Name.ToLower()) { ren $_.FullName $_.Name.ToLower() } }  

6. copy hiearchical git diff another fo... copy hiearchical git diff another folder

   1

   for file in $(git ls-files --others --exclude-standard --modified); do mkdir -p d://BACKUP/unstageds/$(dirname $file) ; cp $file d://BACKUP/unstageds/$file ; done