Microsoft Data Access Blocks (SqlHelper) - Executing 2 SQL commands

[FyinsFlip]

Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
the new row ID without using a stored procedure?

DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());

Is there a new line symbol I can add before the SELECT, like a ';'
or something?

--
Sincerely,
David Dimmer

Quality Builders of ASP.NET Web Sites

B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/

[Curt_C [MVP]]

";"
or
";GO"

--
Curt Christianson
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"FyinsFlip" <go********@fyin.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
the new row ID without using a stored procedure?

DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());

Is there a new line symbol I can add before the SELECT, like a ';'
or something?

--
Sincerely,
David Dimmer

Quality Builders of ASP.NET Web Sites

B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/

[Karl Seguin]

Also, a word to the wise don't use @@Identity in SQL Server 2000:

http://weblogs.sqlteam.com/travisl/a...10/29/405.aspx

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:uS**************@TK2MSFTNGP15.phx.gbl...

";"
or
";GO"

--
Curt Christianson
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"FyinsFlip" <go********@fyin.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
the new row ID without using a stored procedure?

DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());

Is there a new line symbol I can add before the SELECT, like a ';'
or something?

--
Sincerely,
David Dimmer

Quality Builders of ASP.NET Web Sites

B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/

[bruce barker]

your syntax is correct, no linebreaks are required to seperate statements, a
space is fine. ExecuteScalar returns the first column of the first row of
the first result set. the way you have the sql coded, you get two result
sets, but thats easily fixed. try:

DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"set nocount on INSERT INTO tCar (name) VALUES ('Ford') SELECT
CAST(scope_identity() AS
INTEGER) ",
FillSqlParameter());
-- bruce (sqlwork.com)
"FyinsFlip" <go********@fyin.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
| Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
| the new row ID without using a stored procedure?
|
| DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
| "INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
| INTEGER) ", FillSqlParameter());
|
| Is there a new line symbol I can add before the SELECT, like a ';'
| or something?
|
| --
| Sincerely,
| David Dimmer
|
| Quality Builders of ASP.NET Web Sites
|
| B: 414.769.1233
| M: 414.688.3941
| W: http://www.milwaukeewebdesigners.com/
|

[Cowboy (Gregory A. Beamer) - MVP]

You can separate commands with a ";", if you want to string commands.
Personally, I would go to stored procedures, but you can string any number of
commands. WHen you complete the batch, add a "; GO" to the end to make sure
the entire batch runs.

Also, use "SCOPE_IDENTITY" instead of "@@IDENTITY", as high traffic sites
could yield a wrong answer.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"FyinsFlip" wrote:

Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
the new row ID without using a stored procedure?

DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());

Is there a new line symbol I can add before the SELECT, like a ';'
or something?

--
Sincerely,
David Dimmer

Quality Builders of ASP.NET Web Sites

B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/