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 >>
|