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

I have created one database project in vb 6.0. I have created my database in sql server 2000. I a… Read more Sql Server + Vb 6.0

The Problem i'm trying to import data into a table using SQL Server Management Studio's Imp… Read more Sql Server Management Studio: Import Quietly Ignoring 99.9% Of Data

A colleague of mine discovered a behaviour in SQL Server which I was unaware of. CREATE VIEW dbo.vR… Read more Is This A Good Or Bad Way Of Generating Random Numbers For Each Record?

I've 'inherited' a well over 10-year old app, and it does show its age at times. I'… Read more Weird Sql Server View Definition

Suppose that I have this Time value: 09:00:00 And I have a table with a column Time, and I have thr… Read more How To Increment Datetime Column By A Second For Every Row?

I have a stored procedure in an old SQL 2000 database that takes a comment column that is formatted… Read more How Do I Tryparse In Sql 2000?

I want to call a webservice from TSQL in SQL Server 2000. I tried with the following code: Declare … Read more How To Call Webservice From Tsql? (sql Server 2000)

I need to convert a legacy SQL outer Join to ANSI. The reason for that being, we're upgrading f… Read more Convert Legacy Sql Outer Join *=, =* To Ansi

I am trying to update all records in a column so that they start with 'CD' e.g. DCE206 woul… Read more Update Statement Error: Subquery Returned More Than 1 Value

I have an application which connects to SQL Server 2000 (using a generic SQL Login and SQL Authenti… Read more How To Obtain Domain User Name When Connecting Via Sql Authentication

i have some customers with a particular address that the user is searching for: 123 generic way T… Read more Tell Me Sql Server Full-text Searcher Is Crazy, Not Me

(I wish I could have come up with a more descriptive title... suggest one or edit this post if you … Read more Efficient Sql 2000 Query For Selecting Preferred Candy