method
insert
insert(sql, name = nil, pk = nil, id_value = nil, sequence_name = nil)
public
Hide source
# File activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb, line 251 def insert(sql, name = nil, pk = nil, id_value = nil, sequence_name = nil) begin table_name = get_table_name(sql) col = get_identity_column(table_name) ii_enabled = false if col != nil if query_contains_identity_column(sql, col) begin execute enable_identity_insert(table_name, true) ii_enabled = true rescue Exception => e raise ActiveRecordError, "IDENTITY_INSERT could not be turned ON" end end end log(sql, name) do @connection.execute(sql) id_value || select_one("SELECT @@IDENTITY AS Ident")["Ident"] end ensure if ii_enabled begin execute enable_identity_insert(table_name, false) rescue Exception => e raise ActiveRecordError, "IDENTITY_INSERT could not be turned OFF" end end end end


