Programming SQL

Cleaning varchar 50 fields
I have a varchar 50 field that contains periods and underscores. I want to return only the alphanumeric characters. Unfortunately, the periods and underscores do not always appear in the same position. I worte a public function is Access that does this: Public Function AlphaNumericReturn(xVal As String) As ... 15 Jul 2008 15:25

Writing SQL data out to a text file
I am looking a stored procedure that writes SQL data out to a text file from a stored procedure. The existing code is doing this: ------------------------------ Some code to create #QSBonuses and fill it with data ------------------------------ -- Create a control record insert into #QSBonuses (txt) select ... 16 Jul 2008 03:45

Solution
where myname like 'David' + char(39) + 's' OR myname like 'David' + char(34) + 's' -- char(39) is the ASCII for ' -- char(34) is the ASCII for " For my search, if I wanted to search for the single quote in a text field I used: where myname like '%' + char(39) + '%' Hope this helps. ... 15 Jul 2008 13:21

Querying ExecutionLog Table
I'm writing a quick and dirty report to give to the powers that be showing just how often - or not - certain reports are run. I'm also going to include some other anecdotal information. One of the things I'd like to include are average times (rendering, data retrieval, etc.). Here's what I've got so far that wo... 15 Jul 2008 17:30

Lookup table structure preferences
Hello, As DBA's, do you have a preference to how code lookup tables are built? For example, say I have the need for a number of lists of selectable values in an application. The first is customer status, the second is salutation, etc etc. As a DBA, do you typically require a separate table for each list typ... 28 Jul 2008 11:02

Problem prefixing object with dbo. when using system stored procedures
The first issue you have to correct is that the qualified name requires single quotes around it. This could fail, but I don't see how it could fail with the "Incorrect syntax near '.'." error. EXEC sp_help 'dbo.myFunction' The [square brackets] are optional if the names follow the standard naming conventions,... 15 Jul 2008 14:23

T-SQL Query Help
I have 2 rather important database updates that I need to make today, and I want to make sure I get the syntax, actually more importantly the update correct! It's query 2 I am more concerned about. Requirements 1. Update 1: Update CustomChar4 in the Outlet table to the value in tTempTable. 2. Update 2: Update... 15 Jul 2008 14:23

ADO Command parameterized queries
For something that Microsoft, and the world, wants me to do, they sure make it difficult to figure out how. i want to use paramaterized queries with a command object against SQL Server. Note: i don't really want to use parameterized queries, i'm just asking a question. Is there a syntax for the replaceme... 18 Jul 2008 08:13

Sql Server 200x Stress Tools?
I currently have Sql Server 2005 Standard Edition. I have a few legacy Sql Server 2000 Standard Edition databases as well. ... I have implemented the Sql Server 2005 Performance Dashboard Reports as well. Those have helped some. ... I am looking for suggestions on tools which can artificially stress... 15 Jul 2008 15:25

Problem prefixing object with dbo. when using system stored procedures
use [mydb] go sp_help dbo.myFunction Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '.'. but the following executes with no problem. use [mydb] go sp_help myFunction I've noticed this problem for a long time with system stored procedures, there must be a reason. Please give me a hin... 16 Jul 2008 17:11