Search notes:
SQL Server: SQL
select
T-SQL functions
update
create table
null
go
executes the
current
batch
of
SQL
and
T-SQL
statements.
The
number of records
that were affected by the most recently executed sql statement is recorded in
@@rowcount
.
See also
sp_executesql(…)
allows to execute dynamically created or assembled SQL statements.
In
MS access
, ANSI 92 syntax can be enabled under the menu
File -> Options -> Object Designers -> Query Design -> SQL Server Compatible Syntax
Index