Skip to Content.
Sympa Menu

freetds - [freetds] Performing subqueries for inserting into MS-SQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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)


";




Archive powered by MHonArc 2.6.24.

Top of Page