Programming SQL

SELECT * FROM @Table not using Dynamic SQL (if exists)
I have asked in some question before about use a select by choosing table you want, this is like: DECLARE @Table VARCHAR(20) SELECT @Table = "tblSome" SELECT * FROM @Table But NOT using Dynamic SQL (if exists) Please, answer me if you have some way or theory to do so. Beforehand, thank you very much. ... 5 Jul 2008 19:40

How can I run big SQL files?
Hi, I have a big sql file and I need to run it in management studio. The file size is 248Mb. When I open the file and run it, I receive the following error: Cannot execute script. Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) What is the easiest way to run such script and track/se... 4 Jul 2008 18:12

Producing data from querying three tables
Hi all, I'm trying to run a query that produces data from three tables, in essence these are Location, Category and BannerPeriod, They all have a secondary key of SiteID and are linked by this, really there are two stages to this query, Stage 1 produce a complete combination of all categories and locations wh... 7 Jul 2008 09:25

query on max() - Moby
The query is working fine I tested in SQL Server Express 2005. My Database name is master and table name is TEST The query I tried both the queries SELECT MAX(CONVERT(INT, SUBSTRING(INTEGRATION_ID, 3, 10))) AS TEST FROM Test WHERE (LEFT(INTEGRATION_ID, 2) = 'SR') AND (X_CREATE_SOURCE = 'Sales')... 4 Jul 2008 12:04

How to optimize "Inserted Scan" in trigger code
Greetings, We're pulling values from a the "inserted" table that is created in an insert trigger. When we do an insert and view the execution plan in Query Analyzer, the "Inserted Scan" accounts for 98% of the entire query cost. How can this be optimized? There is very little documention on this operation. Any h... 14 Jul 2008 16:49

select statement - multiple values returned
Hi, How can I contruct a statement like such which may return many values (@type) select @type = "select type FROM hlsoccupancy WHERE hlscaseno = @hlscaseno = AND seqno = @seqno" I then need to feed this value into other queries as such: if @type = 'abc' then Do I use a transaction or what? Your he... 5 Jul 2008 12:31

Bug? Problem with query on linked server
I have a very strange problem. I'm working with 2 servers with sql 2000 SP3. Linked server has "Microsoft OLE DB Provider for ODBC Drivers" as provider. The code is listed below. The error is: Server: Msg 7320, Level 16, State 2, Line 4 Could not execute query against OLE DB provider 'MSDASQL'. [OLE/DB provid... 4 Jul 2008 19:13

Problem creating SqlServer object on 64 bit machines
Hi I'm working on an application that works with Sql server for creation/deletion/backup/restore of database. The code works fine on a 32 bit machine, but CreateInstance fails on a 64 bit platform with a runtime exception "R6034. An application has made an attempt to load the C runtime library incorrectly. P... 4 Jul 2008 15:08

fill factor
i am agree with the above details but i am getting little bit confused.. can u please tell me ...if i assigned fill factor 70% then what abt 30% My confusion 1. 30% will be used for insertion and updation process only. is it never holds the data. if new data stored in 30% area than when page is going to split.... 4 Jul 2008 08:59

fill factor
i am agree with the above details but i am getting little bit confused.. can u please tell me ...if i assigned fill factor 70% then what abt 30% My confusion 1. 30% will be used for insertion and updation process only. is it never holds the data. if new data stored in 30% area than when page is going to split.... 4 Jul 2008 10:00