Programming SQL

to upload image in visual web developer express 2005
i really need a very simple process to upload images using the fileupload tool provided in the (vwd) software into my database (microsoft sql server2005) i also need to display these images later and would like to know how in a simple process. here is what i really dont want: 1) ur replys in c# codes or links to p... 28 Feb 2006 07:03

Help with a CASE statement.
I am trying to get this case statement to work where it will concatenate the values into a single string. If I place anything with an equals sign such as (SELECT @status_message = @status_message + 'variable') it give me an error. Any ideas. It probably obvious but I am failing to see it. DECLARE @status_message... 5 Mar 2006 17:17

Check Constraint Expression
I'm using SQL Server 2005 and new to it. I'm wanting to modify a Check constraint expression to say that the field (a description) needs to be unique. I also want it to be null, but figure I can allow nulls or not within the field definition. Can I specify that in the constraint as well? Mainly, I need to b... 28 Feb 2006 05:00

Checking if column exists
Without throwing an error, how can I check if a column exists before performing some action that references the column in question? ... 26 Feb 2006 10:43

.NET Assembly, sql 2005 + sp_oaCreate
I've got an assembly (in house, writen in c# 1.1 framework) that I've gotten to work under SQL 2000, but I've I can't get it to work under 2005. Steps I've done to get setup: Step 1: Register the assemblies Regasm e.core.dll Regasm rrproxy.dll Step 2: Add them to the GAC: Add the assemblies: RRProxy.dll th... 24 Feb 2006 15:24

NOLOCK SQL Query Safety
Hi, I have a question that has to do with the safety of a NOLOCK SQL Query. The situation includes a database that is hit very heavily by a workflow engine. I have a request to build a app that will query the same tables as the workflow engine and generate reports. I am worried about the reporting applica... 24 Feb 2006 14:21

System Error: -2147217871 - Timeout expired
We are running SQL Server 2005 on a cluster in a moderately high traffic production environment. Recently during peak traffic times of the day we have started to get this error on the client application: "System Error: -2147217871 - Timeout expired" We were running fine under Jet but we have since converted... 24 Feb 2006 11:13

query performance question regarding ISNULL
I have a sql statement: SELECT A1.C_JOBBIDID, A2.ACCOUNTID A2_ACCOUNTID, A1.PROD_PR_GRP_C, A1.WON, A2.DESCRIPTION A2_DESCRIPTION, A1.OPPORTUNITYID, A3.USERFIELD5 A3_USERFIELD5, A2.STATUS A2_STATUS, A1.SPEC_PR_PROD_C, A1.SPR_ITEM_ALLOW_Q, A1.DISTPRICE1ST, A1.SUBPRICE1ST, A1.EXPDATE1ST, A1.DISTPRICE2ND, A1.S... 24 Feb 2006 18:02

Cast varchar to decimal
I am losing my hair....and my mind.... Is there any reason why I wouldn't be able to cast a varchar value of say 7.8 to decimal? I have a whole bunch of lab results that come with a bunch of garbage in the result column. I have stripped it away so that it is only a format [1-x].[0-9]. I want to make it a n... 23 Feb 2006 04:47

Calling a user function
I created a user function fn and MSSQL did not let me call it without a schema prefix. Do I need to create a synonym to get around this behavior? Thanks. select fn() error: 'fn' is not recognized built-in function name select dbo.fn() works fine. ... 23 Feb 2006 15:23