Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Code
  • Presentations
  • Publications
  • Contact

Month: February 2011

Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

  • Posted onFebruary 25, 2011
  • sql sever syntax

update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname

Continue Reading

excel remove leading space

  • Posted onFebruary 25, 2011
  • excel and others

=TRIM(B2)

Continue Reading

excel extracting characters to left of comma

  • Posted onFebruary 25, 2011
  • excel and others

Select cells Select the menu choice Data Select the menu choice Text to Columns

Continue Reading

good sql server pivot example

  • Posted onFebruary 10, 2011
  • sql sever syntax

SELECT tID , [Country] , [Day] , [Month] FROM ( SELECT t2.tID , t1.ColName , t2.Txt FROM Table1 AS t1 JOIN Table2 AS t2 ON t1.ColId = t2.ColID ) p PIVOT ( MAX([Txt]) FOR ColName IN ( [Country], [Day], [Month] ) ) AS pvt ORDER BY tID ;

Continue Reading

list of system stored procedures

  • Posted onFebruary 10, 2011
  • sql server administration

select SPECIFIC_NAME from msdb.information_schema.routines where routine_type = ‘PROCEDURE’ order by SPECIFIC_NAME

Continue Reading

no auto reboot after windows updates

  • Posted onFebruary 10, 2011
  • network administration

•In the Start Menu go to Run type “gpedit.msc” and press Enter •Now a Group Policy editor will open. In this window navigate to: Computer Configuration -> Administrative Template -> Windows Components -> Windows Update •Double click on No auto-restart for scheduled Automatic Updates installations…

Continue Reading

finding duplicates with sql

  • Posted onFebruary 9, 2011
  • sql sever syntax

SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )

Continue Reading

create auto increment column

  • Posted onFebruary 9, 2011
  • sql sever syntax

P_Id int PRIMARY KEY IDENTITY

Continue Reading

rename column

  • Posted onFebruary 9, 2011
  • sql sever syntax

sp_RENAME table.field’, ‘newfieldname’ , ‘COLUMN’ GO

Continue Reading

add auto datetime field

  • Posted onFebruary 9, 2011
  • sql sever syntax

alter table table_name add requestdatetime int, myDate datetime DEFAULT(getdate())

Continue Reading

Posts pagination

Page 1 Page 2 Next Page

Newletter Signup

Loading

Recent posts

  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
  • Using SQLFluff

Categories

  • audit (2)
  • azure (44)
  • containerization (14)
  • datawarehousing (4)
  • dba (51)
  • editorial (8)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (7)
  • other (8)
  • performance (1)
  • postgresql (16)
  • powershell (1)
  • security (3)
  • sql server (22)
  • sql server administration (124)
    • jobs (4)
  • sql sever syntax (78)
  • terraform (5)
  • tsql2sday (1)
  • web dev (6)
  • zen (2)

Archives

  • May 2025 (2)
  • April 2025 (2)
  • March 2025 (3)
  • February 2025 (3)
  • January 2025 (4)
  • November 2024 (3)
  • October 2024 (1)
  • September 2024 (2)
  • August 2024 (1)
  • July 2024 (5)
  • June 2024 (4)
  • May 2024 (4)
  • April 2024 (3)
  • March 2024 (2)
  • February 2024 (1)
  • January 2024 (5)
  • December 2023 (2)
  • November 2023 (5)
  • October 2023 (1)
  • September 2023 (1)
  • August 2023 (2)
  • July 2023 (2)
  • June 2023 (3)
  • May 2023 (4)
  • April 2023 (3)
  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (4)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
  • Using SQLFluff
© Copyright 2025 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress