Programming SQL

deleting a fields content
I have a situation in which a user will need to delete only the content of one field for a record. For each record in the table there is a column (field) called IsChildOf. On the webpage there will be a button that will delete only the content (a number) of the field IsChildOf for the record. So, if record I... 24 May 2010 03:41

concatenating and two decimal places
Hello: Below is my query, and I need help with two things. First, I am trying to get each field in this query to be concatenated together. But, there is a space between the field "CMTrxNum" and "CASE WHEN TRXAMNT....". How do I get rid of this spacing? Secondly, I need for the two fields that contain the... 23 May 2010 23:24

Order By String Problem
I have a field named itemSize that contains values like the below example. When I do a regular "ORDER BY" itemSize, SQL sorts the 10" through 14" first, then it goes to 4" through 8" and finishes with the "n/a". In vb, I have used the Val() function to overcome this issue, but SQL doesn't contain a Val() functi... 24 May 2010 15:44

A severe error occurred on the current command. The results,if any, should be discarded
On 2010-05-22 17:39, Paarthy wrote: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. This indicates a bug in SQL Server; your session has crashed. when we use a return statement in the stored procedure. Below the stored pr... 22 May 2010 13:52

2008R2 Views with ORDER BY clause
I migrated a SQL Server 2000 database to 2008R2 and now my Views don't return the rows in the order specified by the ORDER BY clause. In researching this I found this article http://support.microsoft.com/kb/926292/. I have applied SP1 and the cumulative package 8 for SP1 and the view still returns rows in ra... 26 May 2010 02:41

How do I run this xpath query?
Hi, I'm running SQL Server 2005. One of the columns in my view is called "category_xml" and contains data similar to the following ... <categories> <info_type id="3" name="Restaurant"> <category id="13" name="Steakhouse"/> <category id="14" name="Seafood"/> </info_type> </categories> I am trying t... 22 May 2010 07:17

Replication from SQL2008 to SQL2005
Hi All, I want to setup a replication of a table from SQL2008 to SQL2005. The table in the SQL2008 is having a date data type which is not valid in SQL 2005. I thought I can create a UDT in subscriber - but the snapshot itself error out even before touching subscriber The snapshot agent fails Target Site:... 21 May 2010 16:08

Reminder - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 21 May 2010 06:14

Exception: permission of type 'System.Security.Permissions.Secur f
Using VS 2008 to develop a C# CLR Stored Procedure for an SQL2005 DB (Express). I can successfully run and debug the skeletal SP that prints "hello world" but when I add the code below to open a connection to a MS Access database file I get the following exception in the debugger: "Request for the permission ... 21 May 2010 04:05

Stored Procedures
I have to copy quite a few Stored procedures from a database. Is there a quicker way I could do this? thx ... 20 May 2010 17:14