Programming SQL

SQL Dynamic Table
I have a temp table #Output with 3 fixed columns. I have to add some columns to the #Output dynamically based on a variable @max. Is it possible to add columns dynamically to a temp table? If yes whats the syntax. Also can someone suggets a way to add records to the temp dynamic table based on @max. ... 16 Jul 2008 19:15

Trying to convert an Access 2003 SQL to SQL Server 2000 that has an EXISTS
Hello My problem is I have a SQL statement that works great in Access 2003, but when I try to transfer to SQL 2000 it errors on me mainly around the EXISTS section. I have tried multiple scenarios, but seem unable to get it to work. Can anyone explain why an EXISTS in the SELECT statement of an SQL works in A... 15 Jul 2008 13:21

script to drop/add FKs
What are people using to generate scripts to drop/add all FKs referencing a table ? Thanks. ... 14 Jul 2008 22:59

Images & Video
http://www.k00n.com/xxxxl.htm Sex sexy sexo sex teen sexs teens shemale Video a preto e branco downloadGay Sex Videos Click Here http://www.k00n.com/2008.htm http://www.k00n.com/xxxxl.htm Sex sexy sexo sex teen sexs teens shemale Video a preto e branco downloadGay Sex Videos Click Here http://www.k0... 14 Jul 2008 13:42

Defining a decimal data type in a temporary table
Hi, I have a sql server table where a field (e.g.) field1 has length 9 and is of datatype decimal with precision 18 and scale 8 (I am getting this value from design view of sql server table). Now I need to create a temporary table in sql server stored procedure. The above field1 needs to be one of the field.... 14 Jul 2008 12:40

How to copy a table from one database to another
Hi! I have two databases, one for test and another for production purposes. Every night production database is being backed up and restored into a test database. I've mistakingly deleted one table from the test database. What is the best way to recreate deleted table from the production database? Thanks! ... 15 Jul 2008 10:14

Cannot update all rows via query analyzer or enterprise manage
There was an update trigger involved. Thanks for the help. "Roy Harvey (SQL Server MVP)" wrote: I would look for an UPDATE trigger that is rolling back the change. Roy Harvey Beacon Falls, CT On Mon, 14 Jul 2008 07:40:01 -0700, VMI <VMI(a)discussions.microsoft.com> wrote: Via query ... 14 Jul 2008 11:38

re raise error simplification
Is there a simpler way to re-raise an error than this? BEGIN CATCH ROLLBACK IF ERROR_NUMBER() = 50001 RETURN 6 DECLARE @msg VARCHAR(max), @sev INT, @st INT SELECT @msg = ERROR_MESSAGE(), @sev = ERROR_SEVERITY(), @st = ERROR_STATE() RAISERROR (@msg, @sev, @st) END CATCH ... 14 Jul 2008 11:38

Cannot update all rows via query analyzer or enterprise manager??
Via query analyzer: update my_table set target = 15 will only update certain rows. And when I run this query on a specific row, query analyzer will say that one row was, but when I requery, it contains the same value. The same thing happens if I do it directly through the Enterprise Manager: I change the ... 14 Jul 2008 11:38

CopyDatabase wizard
hey all, i'm doing a copydatabase on my producation to create a test database. Once this is done do I need to modify anything on the new test database to make sure I'm not affecting the producation database in anyway? thanks, rodchar ... 14 Jul 2008 14:45