Archived Months
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
all groups > sql server programming > january 2005 > threads for sunday january 30

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

copy field from one table to another
Posted by Aleks at 1/30/2005 11:29:14 PM
I am trying to copy the values of one table to another one: Select ProdNum, Name,NYUSAPrice,MPN into ProductsQuartz [ProdNum,Name,Price,MPN] from productswithprice Both table already exist, trying to map the fields but I get an error ?? A ...more >>


Query help
Posted by Rachel Devons at 1/30/2005 10:47:05 PM
I'm trying to build a somewhat complicated query, well for me at least, and I just can't figure it out. I have a table called Inventory and a table called Auctions. The Auctions table has a foreign key called InventoryID that links back to the Inventory table. What I want to be able to do is t...more >>

EXEC Permission
Posted by Mike L. at 1/30/2005 2:41:57 PM
Hi, I got this 'EXECUTE permission denied on object <mySproc>' error message everytime I try executing my SQL server Sproc. What's this and how to fix this err? many thnaks in advance, mike ...more >>

need help: new at store procedure
Posted by m_peled NO[at]SPAM yahoo.com at 1/30/2005 2:33:49 PM
HI, I want to create Store Procedure that Do: I have 2 tables (A,B) and i want to know if theres records equal between A.id1 in B.id2 or in B.id3 I want to call this Store Procedure from Asp (need to know how) I work with SQL Server. Regards...more >>

how to: non-admin user sending email from a SP ?
Posted by TR at 1/30/2005 12:06:48 PM
Whenever users insert a row into a particular table, I want an insert trigger to invoke a stored proc that sends an email. I want to have this email be sent right away and would prefer to avoid using a daemon process that examines a queue periodically. Nor do I want to use any client-side coding...more >>

Restore for the transaction files
Posted by Sharad at 1/30/2005 1:21:58 AM
Dear Friends We have two location where in one location the database is active and in the other location we only use the dabase for the analysis. There is no possiblity of replciation as we do not have the secured connection. So i need a solution which can temp work. The bakup file ...more >>



DevelopmentNow Blog