I am relying on @@SPID to create temporary data in my stored procedures.
The scope of temporary data is a single SQL Server session.
The technique is called Process-Keyed Tables and it is described here:
http://www.sommarskog.se/share_data.html#prockeyed

I have three result set Like
ID
----
5

I have a view in a sql server database. This view involves join on
project_num with associated with four entities (along with other joins)
tblSMI SM
prs.dbo.project PR

I need to update add rows in a table from the UI. Rather that call my
AddData stored proc 3 times to save 3 rows of data, I'd rather wrap
the data in XML and pass this to the stored proc. Then, I'd like to
iterate the XML block and perform 3 INSERTs. How can this be

Before I go buy this I want to make sure it will work.  I am running
Vista and I have seen that if you install SQL SP2 that it will work
correctly on this OS.  Just thought I would ask the experts before I
make a purchase.

Consider a variation of the classical order header and detail example:
CREATE TABLE OrderHeader (
   OrderID INT,             <- PK
   OrderNumber VARCHAR(10), <- uniqe (alternate key)

SQL Server 2005 SP1
After inserting into a table with an INSTEAD_OF trigger and an AFTER INSERT
trigger, the SCOPE_IDENTITY() function returns 0.
Is this per design ?

Maybe literal constraint isn’t the right word.  What I mean is a column
constrained to a constant instead of being constrained to a key.
Here are the example tables I am working with:
app1_rows table

Which book is Good Database Design(RDBMS)
Thanks
Raj

    Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i ...

After digging around, I found the source of the problem and I don't know how
to fix it.  I've recreated my DB and it's in this zip file.  The zip file is
here and it's really small.
http://www5.upload2.net/download/6e8cfbfa2d31009e2afe94e46b67a255/48864815/YAHQQ
hodIvOktxg/Test.zip

In access I have this Pass-Through Query
Select *
From RISK.TBL_DEMAND_FINAL
Where GROUPID = 2307689

What is the easiest way to create a user that has READ access to one
view (I am assuming if he can do a select on a view that contains
multiple tables, he can by default read the tables), and permission to
do a WRITE to one table (that table has a trigger also)?

Can a Oracle cron job call a SQLServer SSIS package? Has anyone tried this?
Thanks,
SQL_Help

I have a sp that delete teh records from the table, but I
got this message:
Remote tables are not updatable. Updatable keyset-driven
cursors on remote tables require a transaction with the