I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

August 2005 Blog Posts

SQL Server IsGuid() function

A simple function that checks if a passed string is a GUID. create function IsGuid ( @testString varchar(38)) returns int as begin declare @ret int select @ret = 0, @testString = replace(replace(@testString, '{', ''), '}', '') if len(isnull(@testString, '')) = 36 and @testString NOT LIKE '%[^0-9A-Fa-f-]%' and -- check for proper positions of hyphens (-) charindex('-', @testString) = 9 and ...

posted @ Tuesday, August 16, 2005 5:02 PM | Feedback (6) | Filed Under [ SQL Server ]

a select trigger...

this is a select trigger on a table. found this in a blog of our first Slovenian Sql Server MVP (i think he's first :))). http://solidqualitylearning.com/blogs/dejan/archive/2004/11/25/214.aspx quite interesting...

posted @ Sunday, August 07, 2005 3:19 PM | Feedback (4) | Filed Under [ SQL Server ]

Beginner questions frequently asked... and answered...

This is a list of some stuff (mostly beginner) i've learned here on SQLTeam forums  and i've written them down over time... i've posted it in forums here and Madhivanan gave the idea to blog it... so i did. :)) maybe this will help in the planned beginners forum :)) 1. How to update a column with incrementing numbers: -- whole table (identity stlye) declare @table1 table (id int, name varchar(50)) insert into @table1 select null, 'text1' union all select null, 'text2' union all ...

posted @ Monday, August 01, 2005 11:34 AM | Feedback (19) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET