Technical Article

Script to return datetime as just date

You can return the date as a string (varchar) in whatever date format you like by adding a 'style' to the CONVERT statement. Exmaples of style values are (two left hand columns):1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd […]

3.33 (3)

You rated this post out of 5. Change rating

2005-02-18 (first published: )

191 reads

Blogs

AI World

By

this month is the big month and a month to remember their are so...

Using Flyway with Feature Flags

By

There is a nice article at Harness.io on their use of feature flags and...

Microsoft Build event announcements on Fabric

By

There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...

Read the latest Blogs

Forums

Calculating moving moving averages for different ranges in one query

By Sezam

I have this query, which is gives result I want (may be not, i...

Monitoring if something is deleted in DB

By Martass

Hello, I have long-term task, which came one year ago, and just now I...

LOGON Trigger Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item LOGON Trigger Count

Visit the forum

Question of the Day

LOGON Trigger Count

I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?

See possible answers