sql-server-2000 Questions
4
Solved
Possible Duplicate:
How to get the record of a table who contains the maximum value?
I've got an aggregate query like the following:
SELECT TrainingID, Max(CompletedDate) as Complete...
Enstatite asked 17/10, 2012 at 19:55
7
Solved
How can I exit in the middle of a stored procedure?
I have a stored procedure where I want to bail out early (while trying to debug it). I've tried calling RETURN and RAISERROR, and the sp keeps o...
Certitude asked 7/12, 2009 at 21:3
1
Solved
2 FEB is the 33rd day of the year, for example.
Is there a built-in T-SQL function that returns the day-of-year (in SQL Server 2000)? Or do you have to roll your own using casts to get the first ...
Fourteenth asked 21/9, 2012 at 18:15
4
Solved
I'm trying to do a ALTER TABLE Signatures ALTER COLUMN HTML ntext; but I get a Cannot alter column 'HTML' because it is 'text'.
How do I go about altering the column?
Anisole asked 23/2, 2011 at 18:41
4
I work for a relatively small company less than 50 people and I'm probably the closest thing we have to a DBA...I'm actually a programmer but that's beside the point. We have a SQL Server 2000 with...
Astir asked 16/8, 2012 at 22:11
2
Solved
Let we have a table of payments having 35 columns with a primary key (autoinc bigint) and 3 non-clustered, non-unique indeces (each on one int column).
Among the table's columns we have two dateti...
Inconsumable asked 9/8, 2012 at 3:6
12
Solved
So our SQL Server 2000 is giving me the error, "The log file for database is full. Back up the transaction log for the database to free up some log space."
How do I go about fixing this without de...
Repulsion asked 16/9, 2008 at 14:32
14
Solved
I have a table in SQL Server 2000 that I am trying to query in a specific way. The best way to show this is with example data.
Behold, [Addresses]:
Name Street City State
------------------------...
Lamrouex asked 11/6, 2009 at 18:52
6
Solved
i have a series of T-SQL statements separated by the special Query Analyzer batch separator keyword:
GO
If one batch fails, i need Query Analyzer to not try subsequent batches - i want it to sto...
Apotropaic asked 29/5, 2009 at 17:8
1
Solved
Currently I am working on SQL Server 2000,2005 & 2008, my requirement is like,
the database available in SQL Server 2000 & 2005 will be available in 2008 using a linked server.
Let's say I...
Agglomeration asked 1/5, 2012 at 18:17
1
Solved
I am making some tweaks to a legacy application built on SQL Server 2000, needless to say I only want to do the absolute minimum in the fear that it may just all fall apart.
I have a large table o...
Expiation asked 24/3, 2012 at 14:9
8
Solved
Have you ever seen any of there error messages?
-- SQL Server 2000
Could not allocate ancillary table for view or function resolution.
The maximum number of tables in a query (256) was exceeded.
-...
Borderland asked 5/8, 2008 at 14:54
6
Solved
I need to hash (MD5) all the password in our Sql Server 2000 database. I can easily generate a C#/VB.NET program to convert (hash) all the passwords, but I was wondering (more for my education than...
Cloying asked 26/5, 2009 at 13:16
3
i want to generate scripts for database objects, e.g.
tables
views
stored procedures
functions
Since:
SQL Server Management Objects (SMO)
SQL Distributed Management Objects (SQL-DMO) (depric...
Sudanic asked 26/11, 2009 at 15:43
2
Solved
Consider the following query:
SELECT operation, [...] FROM tableName
The operation field will retrieve an integer from 1 to 4. What I would like to do is assign a string value to a variable in th...
Diba asked 8/2, 2012 at 10:23
1
Solved
When I run the sql query I got something like this :
Disallowed implicit conversion from data type varchar to data type
varbinary.... Use the CONVERT function to run this query. (severity
16)...
Frederiksen asked 26/1, 2012 at 16:49
1
Solved
For example I have two tables (temp tables). One of them contains only IDs, and the other contains real information. They have exactly the same row number.
#Table1
ID
14
15
16
#Table2
CarModel Ye...
Vertebra asked 18/1, 2012 at 19:29
2
Solved
I am trying to figure out a way to update / replace only text between two strings.
For instance I need to be able to update the field and replace only what's in between the following script tags ...
Wodge asked 13/1, 2012 at 12:46
4
Solved
I know that I can get a list of tables with
SELECT TABLE_NAME FROM information_schema.tables
WHERE NOT TABLE_NAME='sysdiagrams'
AND TABLE_SCHEMA = 'dbo'
AND TABLE_TYPE= 'BASE TABLE'
...
Withindoors asked 3/3, 2011 at 21:44
7
string st = '01/2012' (MM/yyyy)
I want to get the data between 01/01/2012 and 31/01/2012
How to create a start date and end date according to month and year format?
For Example
st = 02/2012
S...
Bethsaida asked 10/1, 2012 at 4:54
5
The Problem
i'm trying to import data into a table using SQL Server Management Studio's Import Data task. It only brings in 26 rows, out of the original 49,325. (Edit: That's where 99.9% comes from...
Weslee asked 10/9, 2010 at 19:58
4
Solved
I want to check table PREMIUM_SERVICE_USER if any records exists for
strClientID update timeValid for +30 if no records for strClientID insert to premium_service_user table.
What am I doing wron...
Franglais asked 6/7, 2010 at 18:52
3
Solved
I've been tasked with creating an application that allows users the ability to enter data into a web form that will be saved and then eventually used to populate pdf form fields.
I'm having troub...
Praefect asked 18/11, 2011 at 18:53
4
Solved
i have a query that returns rows that i want, e.g.
QuestionID QuestionTitle UpVotes DownVotes
========== ============= ======= =========
2142075 Win32: Cre... 0 0
2232727 Win32: How... 2 0
187...
Demodulator asked 9/3, 2010 at 16:8
3
Solved
I'm trying to figure out how to insert a .JPG file into a SQL Server 2000 database field of type image using Transact SQL. Thanks.
Describe asked 31/7, 2009 at 19:36
© 2022 - 2024 — McMap. All rights reserved.