Yes, MS DTC is running ! I execute the statement with Query Analyzer. In the Query Analyzer, I'm connect with my local machine. I execute the query on my local SQL Server! I don't understand Help me Thanks
2003-06-17
1 reads
Greetings. One of the guys here has created an app which generates all the common procs for you. You give it a DB and tell it you want the inserts or deletes or selects etc. It creates the script which you can then customise if required. When he gets in I'll grab it and post […]
2003-06-16
Hi mlwang, quote: What is the different between SELECT and SET DECLARE @var varchar(100) SELECT @var = 'select * from tablename' SET @var = = 'select * from tablename' results are in both cases the same. However, MS recommends using SET for variable assigment Cheers, Frank
2003-06-06
1 reads
What is the different between SELECT and SET DECLARE @var varchar(100) SELECT @var = 'select * from tablename' SET @var = = 'select * from tablename'
2003-06-06
1 reads
Creating a temp table (or table variable) is probably the best way, especially if the procedure is going to get large, or you want to manipulate the output with a sort...
2003-06-05
1 reads
You might try something like this. This is how to return variables to calling program from dynamic SQL. set nocount on create table foobar (id int, theid int) insert into foobar values(1,1) insert into foobar values(1,2) insert into foobar values(1,2) insert into foobar values(1,3) insert into foobar values(1,3) insert into foobar values(1,3) go create PROCEDURE […]
2003-06-04
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers