Programming SQL

FILESTREAMING SQL 2008 R2
Hi all, I am using filestreaming technology for saving images into database, my issue is when im altering tbl structure like adding a column, then link goes break and , new folder created, when im rollbacking then file still exist on the same folder, pls help what is going wrong with me These all tak ... 16 May 2010 05:58

Covering index
I am looking at a SP that has a select statement where the Query Analyser suggests a covering index: CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[ORDER] ([EID]) INCLUDE ([OrderID],[ModID],[Type],[IsLinkable]) There already is one that is not covering index on the table for other SPs... 12 May 2010 17:00

Connections and ##temp tables
Hi, using Access 2003 and SQL 2005. I have an Access application that uses a combination of pass-through queries and dao recordsets to load forms and reports. This is not an Access Project. My question is about design. A search populates a table with parent record IDs. I then have a bunch of stored procedures ... 11 May 2010 17:56

Multiple Items in Listbox
I've never had to deal with multiple items in a listbox control. Would it best to store the comma-seperated id integers within 1 varchar field? The other thought was possibly build a junction table and have multiple rows for each comma-seperated integer. What's the best way to store multiple items collected f... 10 May 2010 02:18

c# and "Select ID,Data FROM [Data$]"
I'm going thru some C# code that iconnects to an excel object. I've never seen a slq construct like this. Would someone please decipher the "[Data$]" part? Thank you. "Select ID,Data FROM [Data$]" (used in a constructor like: new OleDbDataAdapter(query, connection)) ... 9 May 2010 12:09

Todays Date in Template Parameter
Hi All I'd like to use a Template Parameter with SQL Server 2005 which inserts todays date. <parameter_name, data_type, default_value>. You guys know a way to achive this to get "default_value" to be filled with todays date? Thanks for any help. Martin ... 8 May 2010 02:36

GROUP BY in WHERE
I have a stored procedure that is suppose to find duplicate entries in a table. I am using a subselect and GROUP BY to check for duplicates. The code below is the section of my WHERE clause that is suppose to find duplicates but a few are showing up that are not duplicates. The GROUP BY in the subselect indic... 8 May 2010 14:31

Nedd help to run this script on all DBs
I'm struggling to get this script to run on all DBs. It runs on a single DB just fine. Tried sp_msforeachdb but can't get the syntax quite right when using it in conjunction with @sql. Any ideas please. Thanks very much - SET QUOTED_IDENTIFIER OFF DECLARE @sql VARCHAR(4000) SET @sql = " set nocount on cre... 7 May 2010 18:58

Dividing a problem into parts and can't get the parts back tog
Thanks for helping me take the final step toward the solution! It looks so easy. All I had to do was delete the Order By lines in the subqueries and add an Order By at the very end, and now it works just fine! Thanks again for your help! ... 7 May 2010 10:03

Access frontend with SQL Server backend: my solution for ODBCCall error
hi Arvi, My solution: [..] Cool, nice piece of work. mfG --> stefan <-- ... 7 May 2010 08:56