get all values separated by commas
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,257 reads
Scripts
2012-07-18 (first published: 2008-01-25)
2,202 reads
2012-07-17 (first published: 2007-11-21)
2,276 reads
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,819 reads
2012-07-13 (first published: 2008-03-20)
2,235 reads
TopBlocker
Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.
2012-07-12 (first published: 2007-10-30)
3,046 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
2012-07-11 (first published: 2012-07-04)
1,278 reads
2012-07-06 (first published: 2012-06-29)
1,009 reads
2012-07-05 (first published: 2012-06-15)
957 reads
Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,609 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Alamat Kontak Bank Central Asia Telp Cs 0817781222
Jl. Raya Pasar Minggu No.64, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta Selatan, Daerah Khusus...
Alamat BCA KCP Blok M Telp Cs 0817781222
Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers