I\'m developing an ETL application with batch processing.There is low (i.e. no) concurrency for updates.I\'d like to avoid the overhead of granular locks and lock escalation by merely locking the enti
What is the locking granularity used for local temp tables in MSSQL?Given that local temp tables are local to sessions, and sessions are the same as connections in MSSQL2K, and that there is no way to
I\'m trying to write a query that will return all QUERY_I开发者_如何转开发D values alongside all matching TABLE_ID values, where QUERY_ID is not specified in any table, and I can\'t create tables, so
I have a table with a column that needs the 开发者_运维知识库data type upgrading.However running any alter script causes errors due to a unnamed unique constraint.
Is there a way to retrieve all the data from an IN clause? Let\'s assume my table got (ID,Name): 0 Banana
I am writing an application that will call a SQL Server job on all our client\'s systems. I\'m able to execute it, and wait until it\'s finished. It has an output file that\'s save location is hard c
I have one database that has a bigg开发者_开发问答er size than expected, how can I query it to retrieve the fields that take more space.
What\'s the easiest way to export data to excel f开发者_运维百科rom SQL Server 2000. I want to do this from commands I can type into query analyzer.
I have an sp named \'FolderSttructure\'.It returns t开发者_C百科he following result - FolderID 1 2 3
I have pretty much no experience with SQL Server\'s Enterprise Manager so I am not sure if this is even possible (or hopefully laughably simple!)
加载中,请稍侯......