freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Performing subqueries for inserting into MS-SQL
- From: "Peter Matulis" <pmatulis AT gmail.com>
- To: freetds <freetds AT lists.ibiblio.org>
- Subject: [freetds] Performing subqueries for inserting into MS-SQL
- Date: Mon, 2 Oct 2006 14:03:42 -0400
How can I perform subqueries for inserting into MS-SQL Server 2000?
My current code fragment is here:
my $sqlStatement = "
declare @a varchar(10)
set @a = (select top 1 agent_id from ent_domain where domain_name = '1.2.3.4')
INSERT INTO
table1 (agent_id)
VALUES (@a)
";
-
[freetds] Performing subqueries for inserting into MS-SQL,
Peter Matulis, 10/02/2006
- <Possible follow-up(s)>
-
Re: [freetds] Performing subqueries for inserting into MS-SQL,
Lowden, James K, 10/02/2006
- Re: [freetds] Performing subqueries for inserting into MS-SQL, Peter Matulis, 10/02/2006
Archive powered by MHonArc 2.6.24.