Programming SQL

ASP connection string to SQL2005
I am trying to connect to SQL2005 server, and the script is written in ASP. I am trying to figure out why I am getting this error as below; Microsoft VBScript runtime error '800a0005' Invalid procedure call or argument: 'Mid' I currently have following connection string; "Provider=SQLDB; User ID=f... 27 Jun 2008 18:20

SSIS packages export to file
Hello, I have a stored procedure to export DTS packages to files and I'd like to modify it to do same for my SSIS packages, so I have modified the procedure like that: CREATE procedure [dbo].[s_SavePackages_90] @Path varchar(128) as set nocount on declare @objPackage int declare @PackageName varcha... 26 Jun 2008 17:44

OPENROWSET, Dynamic SQL, and Run Parameters
Ok. I think I'm close here. I have a Stored Procedure defined as... USE [Dev_Database] GO CREATE PROCEDURE Test_SP (@testVariable varchar(10)) AS BEGIN SELECT TOP 1000 * FROM Dev_Database.dbo.Patient WHERE PatientID = @testVariable END GO Now I am trying to run this via Dynamic SQL with ... 26 Jun 2008 20:48

Adjacent Model - Delete Node
Hello, I am using an Adjacent Model to create a 4 level categories: http://www.sqllessons.com/categories.html When I delete a node I need to delete all nodes under it. How can I do this? Thanks, Miguel ... 26 Jun 2008 17:44

ROBUST PLAN hint?
Hi, I have a pretty standard SELECT query (no inserts) that return only 3 columns. Their total size in a row is definitely less than 8K. Any idea why I am receiving error "Could not insert a row larger than the page size into a hash table. Resubmit the query with the ROBUST PLAN hint."? This query uses a pr... 27 Jun 2008 19:21

convering column values to row
I'm having problem converting column values into row. that is without knowing the length nor the values in the column, for instance column A B C D E and so on I want to convert it to A B C D E F G and so on without knowing the initial values in the column and the number of values Thanks Henry... 26 Jun 2008 18:45

SQL Read Only User Permissions Problem via web (asp)
I have a site that's been working fine for a few years. Of late I got hit with a SQL injection attack. I am putting defenses in place as articels state. One of those is to create a user account for the DB that is read only. We got that set and are able to do select calls via enterprise manager. However, from th... 26 Jun 2008 14:38

update joined tables
Apparently this is not legal t-sql : update table1 t1 join table t2 on t1.t2id = t2.id set t1.col1 = 'new value 1', t2.col2 = 'new value 2' Why doesn't t-sql allow this ? Is this inability a function of the db engine ( i.e. peculiar to ms sql svr but other engines allow it .. ) ? Thanks. ... 8 Jul 2008 07:58

Querry problem after upgrade to SQL2005
We have a PHP web application that uses data from a SQL database. The old server was MS SQL2000 and was upgraded to SQL2005 on a new VMware virtual server. The querry: $summary_query = "select cast(request.REQUESTID as int(4)) as RequestId, cast((select CustFieldValue from azteca.ReqCustField as Cu... 26 Jun 2008 13:36

Is there an Identity that resets within a foreign key?
I hope the post title makes sense. What I want is a table like this: ID Pos ------ -------- 1 1 1 2 1 3 2 1 2 2 In other words, Pos is an "Identity" that resets every time ID changes. I guess many tables are like this. Can I do that automatically? ... 29 Jun 2008 17:17