Browse by Tags

a question

Boss told you to come up with a question to test new programmers? Here's one: you have a linked server and an openquery statement. What is the number returned by this query? select count(*) from openquery(LINKED_SQL, 'select count(*) from database.dbo.table1')

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 01-23-2008
changing collation of all columns without dropping them

Just this week I had opportunity to change collation of all objects using it in a database without dropping it. I like to computers to do what computers should do - work that is :). So I created a query that gave me script changing collation of all columns using collation - varchar, char and so on. I...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 12-14-2007
csv list of elements as parameter for stored procedure

A while ago, Tony Rogerson showed a way how to pass a list of integers (csv) to stored procedure. Approach of creating a script and executing it is OK for smaller amounts of data. I thought, that maybe, as xml is a form of text after all, it would be more appropriate? I crafted a stored proc based on...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 11-24-2007

Page 1 of 1 (3 items)

SQL Server Community Blogs