how to insert one Parent and Multiple child records into SQL Serve
Tue, 15 Apr 2008 08:34:01 -0700
Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.
Please help, as I urgently need to solve my problem...
T ...
|
Sprocs v. embedded queries
Mon, 14 Apr 2008 12:08:00 -0700
I've read that the advantages of sprocs over embedded queries is that the
former are compiled once.
Does one loose the advantages of stored procedures when one concatentates a
lot of strings together and then uses the EXEC function to execute the
subsequent query? I'm seeing a lot of this in the stored proc ...
|
SQL Licensing
Mon, 14 Apr 2008 11:51:19 -0700 (PDT)
Hi All,
I have some programmers that are writing a custom Time/Attendance/Time
Billing software for us and they are writing it in VisualStudio. All
data collected from this program will be stored in an SQL database.
My question is how do I need to license? Do I need a CAL for every
computer with the timeclo ...
|
How to Install SQL Server Management Studio on Client
Mon, 14 Apr 2008 10:21:11 -0700
Sql Server 2005.
I have tried installing the SQL Server Management Studio tool on my client
workstation from the SQL Server 2005 installation CDs to no avail. How can I
install this tool on my client or any client, so that I do not have to logon
to the server to do these tasks? Thanks for the help.
--
...
|
Handle Transaction
Sat, 12 Apr 2008 18:30:49 -0400
Just want to clarify one thing before i have to BEGIN DISTRIBUTED
TRANSACTION on production boxes. here is an example.
SET xact_abort ON
BEGIN DISTRIBUTED TRANSACTION
UPDATE Table on LocalServer
UPDATE Table on RemoteServer
COMMIT
Should I implement the error handling right after each updates? to ma ...
|
DTC & Distributed Transaction Server.
Sat, 12 Apr 2008 17:17:48 -0400
Dear Professionals.
What are the major difference between DTC, this is the services running on
our local box and what if I have to installed Distributed Transaction Server
separately?
Any website where i can get the major difference?
Thanks
...
|
Error Handling.
Sat, 12 Apr 2008 17:16:21 -0400
Just want to clarify one thing before i have to BEGIN DISTRIBUTED
TRANSACTION on production boxes. here is an example.
SET xact_abort ON
BEGIN DISTRIBUTED TRANSACTION
UPDATE Table on LocalServer
UPDATE Table on RemoteServer
COMMIT
Should I implement the error handling right after each updates? to m ...
|
|
|
DISTRIBUTED TRANSACTION.
Fri, 11 Apr 2008 19:45:22 -0400
Dear Professional..
I would highly appreciate if anyone can guide me about
SET BEGIN DISTRIBUTED TRANSACTION
update first server table
update second server table
COMMIT TRANSACTION
Just want to understand, before doing the above SET command I have to create
linked Server first?
Let's assume I have a ...
|
attempting to connect locally
Wed, 9 Apr 2008 08:34:01 -0700
Hello,
I am running SQL server on my machine for the first time and have very
little experiance with this application. I am running this app on my machine
only (the client) and am attempting to log on using the Management Studio.
Unfortunately, the application does not seem to recognize my computer
ide ...
|
Webservice in SQL Server 2005
Tue, 8 Apr 2008 20:07:18 -0400
Dear professional,
I am working with Flex development team, they are development a flex
interface and we are using this in the front end and in the back end we are
using SQL Server 2005 but the only problem is Flex can't call stored
procedure directly, they need web services and I have to pass one of my
s ...
|
