Stack Overflow
Stack Overflow

Questions tagged [sql-server-2000]

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server. Note that as of April 9, 2013, Microsoft no longer supports this version of SQL Server, to the point that even security patches are no longer created.

SQL Server 2000 (codename Shiloh, version 8.0), released in September 2000, is the successor to SQL Server 7.0.

2588 questions
0
votes
1 answer

how can i use a dataset for refinement

how can dataset filtering be done?
saurabh
  • 271
  • 1
  • 6
  • 18
0
votes
4 answers

How to change the date format

Table: Dates (nvarchar) == 23/02/2009 (dd/mm/yyyy) 24/02/2009 25/08/2009 28/12/2011 .... I want to change the date form like this (yyyymmdd) Tried query select cast(dates as datetime) from table1 Showing error ЮArithemetic expression…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
1 answer

How to extract current stock from table in SQL Server 2000

I'm making and application in vb.net using Visual Studio 2005 and SQL Server 2000. I have to keep track of the stock. The stock when added has its status set as "Unsold". When some stock is removed then the transaction keeps the status of stock as…
user944591
  • 69
  • 2
  • 8
  • 18
0
votes
1 answer

Get the name of a columns default constraint on SQL Server 2000?

How do I get the name of a columns default contraint on a SQL Server 2000 installation? As far as I know sys.default_constraints is not available. Its different on every DB, the structure is like DF_table_column__3DE8FB0E for example. Thanks :)
grady
  • 12,281
  • 28
  • 71
  • 110
0
votes
1 answer

How to get a break time for the days

Table ID Date Time 001 12/01/2011 08:00:00 001 12/01/2011 08:30:00 001 12/01/2011 11:30:00 001 12/01/2011 12:35:00 001 12/01/2011 03:30:00 001 12/01/2011 04:30:00 002 12/01/2011 08:30:00 002 12/01/2011 09:30:00 .... I want to select intime,…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
1 answer

SQL Server 2000 SQL Profiler filters ignored

I am not able to filter events in my database. When creating a trace, I specify a "Database Name" in the filters tab and add my database name, "pr200". However, the profiler seems to ignore this information and keeps showing events from all…
AgostinoX
  • 7,477
  • 20
  • 77
  • 137
0
votes
1 answer

Get SQL Server 2000 instance path using C#

I need to relocate files to SQL Server 2000 default data folder programmatically using C#, I have searched a lot but couldn't find a solution. Given below link only works for SQL Server 2005 and above versions. C# How to get SQL Server installation…
Satya Vinod
  • 1
0
votes
1 answer

BCP... queryout execution erroneously returns zero rows where data is know to exist

I have written a BCP process with queryout as option. As a result the query is exectuted and the results are (or should be) written to the designated output file. The query that is being used has been confirmed in SQL Query Analyzer (using MS SQL…
user774512
  • 1
  • 3
0
votes
2 answers

How do I create and synchronize a combined reporting-only db from two live dbs?

I need to quickly implement a read-only database containing data pulled from two identically structured live databases. The live dbs are actually company dbs from a Dynamics accounting system so I'm happy for any Dynamics specific advice but this is…
tetranz
  • 1,932
  • 3
  • 24
  • 32
0
votes
1 answer

Why does this simple SQL query from SQL Server 2000 have different results in SQL Server 2008?

Using MS SQL 2000 it was possible to have a query such as: SELECT (Code + ' = ' + EdiNumber + ',') AS MyResult FROM tblCountry Which would give you a list of results like: MyResult ======== ZW = 263, ZA = 27, ... However, in MS SQL 2008 that…
Jimbo
  • 22,379
  • 42
  • 117
  • 159
0
votes
1 answer

SQL Server 2000 - decode base64 string to image file, or to a file system

Is is possible from a stored procedure in SQL Server 2000 to decode a base64 binary string to an image file? I have to save it to a file system, and that part is solved, I need to get the data in an image file
opensas
  • 60,462
  • 79
  • 252
  • 386
0
votes
2 answers

SQL Server 2000 (creating all dates given a daterange)

I was wondering if there is a way in SQL Server 2000 to create all dates given a start and end date as a result. I know I can achieve this with T-SQL looping. I am looking for a non looping solution. Also in 2005 you can use the recursive with…
user94967
  • 91
  • 1
  • 8
0
votes
1 answer

Generate Script in SQL Server 2000 (in Order)

I want Generate script of all views and functions in my database, but when i execute this script i find a problem of ("object xxx doesn't exist") because i have many views select data from other views, so they should be created before the first…
kamal1899
  • 1
0
votes
1 answer

SQL Server 2000: how to save an Image variable to a file in the file system from a stored procedure

I have a stored procedure that receives a @Data image parameter. And I want to save it to the file system from a stored procedure. Any idea how to do it?
opensas
  • 60,462
  • 79
  • 252
  • 386
0
votes
3 answers

How to insert a string value in the table

Using VB6 and SQL Server How to insert a string value in the table Dim a as string a = 0008", "0009", "1011", "1208 I want to insert this string values in the table Expected Output Table1 ID 0008 0009 1011 1208 How to make a query for the above…
Gopal
  • 11,712
  • 52
  • 154
  • 229
1 2 3
…
99
100