Scope of temporary tables in SQL Server -


i wrote stored procedure import , transform data 1 database another. each import take single company id , import data related company.

to transformation step use temporary tables. part of script review, told use table variables rather temporary tables. reviewer claims if run 2 different imports @ same time, temporary table shared , corrupt import.

questions:

  • is true temporary table shared if run 2 different imports @ same time?
  • does each call exec create new scope?

here contrived example of script.

create proc [dbo].[importcompany] (     @companyid integer ) exec [dbo].[importaddress] @companyid = @companyid  --import other data  create proc [dbo].[importaddress] (     @companyid integer )     create table #companies (oldaddress nvarchar(128), newaddress nvarchar(128))     insert #companies(oldaddress, newaddress)     select         address oldaddress,         'transformed ' + address newaddress             [olddb].[dbo].[addresses]             companyid = @companyid      --do stuff transformed data      drop table #companies  exec [dbo].[importcompany] @companyid = 12345

from create table:

local temporary tables visible in current session

and (more importantly):

if local temporary table created in stored procedure or application can executed @ same time several users, database engine must able distinguish tables created different users. database engine internally appending numeric suffix each local temporary table name.

which rebuts point of whoever said shared.

also, there's no need drop table @ end of procedure (from same link again):

a local temporary table created in stored procedure dropped automatically when stored procedure finished


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more