Skip to content
View halityurttas's full-sized avatar

Highlights

  • Pro

Block or report halityurttas

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

Pinned Loading

  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