Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • Reply To: How to Improve Database Design to Speed Up SQL Queries

    Yeah. I'm no expert but SSN is one of the classic examples of a trap for a natural unique ID. Your average person probably thinks they are unique, static and...

    May 15, 2023 at 3:57 pm

    #4190177

  • RE: The Hibernate ORM and SQL Server

    This was basically my introduction to SQL. Doing Tech Support for an app build on Java using Hibernate. It was a small team with a couple of developers and no...

    December 19, 2016 at 10:46 am

    #1918728

  • RE: Coalesce and empty strings to replace NULL - need help

    As was mentioned the problem with your coalesce is the first N'',. Coalesce chooses the first thing that is not null and uses that and the N'' will never be...

    February 1, 2016 at 1:27 pm

    #1855811

  • RE: SQL to Tsql

    Igor Micev (1/20/2016)

    newbieuser (1/20/2016)

    Thanks got it.

    declare @weekday varchar(10)

    declare @in_date date='01/20/2016'

    select @weekday=datename(weekday,CONVERT(VARCHAR(10),@in_date,101))

    select @weekday

    Even if you don't convert it with a style, sql server will recognize it and return the day-name from...

    January 26, 2016 at 2:20 pm

    #1854554

Viewing 4 posts - 1 through 4 (of 4 total)