Lab Sql

Possible Duplicate: how do find the number of rows in a table when the table name is in a variable?… Read more Use A Variable For Table Name

I have a bunch of orderIds '1, 18, 1000, 77 ...' that I'm retreiving from a nvarchar(80… Read more How To Parse A Comma Delimited String Of Numbers Into A Temporary Orderid Table?

I have an Audit database(created by someone else). Something is polulating it, with table sizes dat… Read more Sql Server Table Population Source

Plain and simple, does anybody know why this: Select 30 * 220 / 30 Returns 220, which is the corre… Read more Sql Server 2000 Integer Truncating

I'm trying to alter a table to add a new column, then insert a new row into it. ALTER TABLE Rol… Read more Sql Server 2000 - Alter Table + Insert Into = Errors?

i'm faced with having to add 64 new columns to table that already had 32 columns. For examples … Read more Sql Server: Any Value In Vertical Partitioning When I'm Always Going To Re-join Them?

At work we have two servers, one is running an application a lot of people use which has an SQL Ser… Read more Linked Server Performance And Options

I have 2 tables. lets just say its records and numbers the records.number contains a number which I… Read more Longest Prefix Match In Sql Server 2000