Technical Article

Script to Define User-Defined Data Types

Our DBA and I (I'm a PowerBuilder programmer) decided to plunge head-first into UDTs. After reading the message boards, I thought maybe we could come up with a way to make them work. My solution is this stored proc. There are some assumptions made that work for our needs and some extra work that was […]

You rated this post out of 5. Change rating

2003-02-20

298 reads

Blogs

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission

By

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Read the latest Blogs

Forums

High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

get week number of month

By GrassHopper

I want to query a table that has a datetime column ([CreateDateTime])  and get...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers