Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit
Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.
2008-11-13
11,455 reads
Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.
2008-11-13
11,455 reads
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,691 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,765 reads
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
2007-10-16
7,988 reads
The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
2007-09-18
5,675 reads
While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.
2007-09-06
10,315 reads
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
WhatsApp:083179431313 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
WhatsApp:083179431313 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa Timur 66217
WhatsApp:083179431313 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik, Jawa Timur...
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers