sql-server-2000 Questions
3
Solved
Is it true that SQL Server 2000, you can not insert into a table variable using exec?
I tried this script and got an error message:
EXECUTE cannot be used as a source when inserting into a table v...
Incommensurate asked 31/1, 2013 at 9:56
2
Solved
My customer is running MS SQL Server 2000.
I completed a project, but I failed to realize that MS SQL Server 2000 will not allow a select inside insert into values thus giving the error:
Subquerie...
Easterling asked 9/3, 2014 at 16:17
3
Solved
I am using SQL server MSDE 2000. I have a field called notes of type nvarchar(65).
The content is 'Something ' with an extra space after the content (quotes for clarity) in all the records. I use...
Fleabag asked 8/12, 2009 at 5:37
4
Solved
How can I export a table from a SQL Server 2000 database to a .sql file as a bunch of INSERT INTO statements?
One of the fields in the table is a Text datatype and holds HTML so doing this by hand...
Lussier asked 3/11, 2010 at 1:8
2
Solved
I am developing an ASP.NET application in VS 2010 with a SQL Server 2000 backend (I know, I know . . .)
I have been working just fine with this setup for the greater part of the last 3 months. How...
Maroc asked 6/9, 2012 at 21:2
1
Solved
I have a legacy business application built on MS SQL Server 2000. I have some webbased utilities that access this database using PHP 5.2 with mssql extension.
I need to reinstall the web server, a...
Gianna asked 5/11, 2013 at 7:14
8
Solved
I've done this before somewhere I'm sure of it!
I have a SQL Server 2000 table that I need to log changes to fields on updates and inserts into a second Logging table. A simplified version of the ...
Toulon asked 4/3, 2009 at 6:6
3
Solved
I came across some code with this *= operator in a WHERE clause and I have only found one thing that described it as some sort of join operator for Sybase DB. It didn't really seem to apply. ...
Resin asked 15/8, 2013 at 16:2
2
Solved
In the process of trying to help out an app dev team with performance issues on a SQL 2000 server (from a bunch of Java applications on separate app servers), I ran a SQL trace and discovered that ...
Hapte asked 1/9, 2010 at 22:13
6
Solved
(This is related to Floor a date in SQL server.)
Does a deterministic expression exist to floor a DATETIME? When I use this as a computed column formula:
DATEADD(dd, DATEDIFF(dd, 0, [datetime_col...
Groot asked 21/11, 2008 at 17:17
7
Solved
I have a database working on SQL Server 2000. We are now migrating to a new server with SQL Server 2008 r2. Can anyone please point me to some resource or howto?
I'm not really finding my way aroun...
Myosin asked 11/4, 2011 at 10:54
2
Solved
I have an input date and I need to convert it to format 112 (yyyymmdd) for use later on in my SQL statement.
declare @day varchar(10)
set @day = '6/21/2013'
select @day
I've done this before.....
Tektite asked 25/6, 2013 at 15:22
4
Solved
I'm using SQL 2000. A string column 'Password' is there in a table 'Users'. It has around 3k rows. My requirement is to encrypt all the values of the 'Password' column.
Also, I should be able to de...
Auto asked 30/5, 2013 at 7:25
2
Solved
In T-SQL (SQL Server 2000). How can I list all tables and columns in a database?
Also, in a separate query is there a way to list all columns along with data type and constraints (NULLS, etc). Than...
Insufferable asked 15/5, 2013 at 19:20
4
Solved
I need, if possible, a t-sql query that, returning the values from an arbitrary table, also returns a incremental integer column with value = 1 for the first row, 2 for the second, and so on.
This ...
Chavira asked 10/2, 2009 at 21:16
2
Solved
I'm migrating a legacy SQLS2k to 2008R2, and it seems all data access was done through stored procs, and any custom queries use the legacy *= =* outer join syntax. There are upwards of a hundred pr...
Annikaanniken asked 15/6, 2011 at 7:10
1
Solved
i'm trying to run a query against a remote 2000 server; but the query that the local server is generating is incorrect, and causes the remote server to return the error:
The column prefix 'Tbl10...
Tommi asked 17/4, 2013 at 20:57
1
Solved
I have got following error message while restoring a backup from SQL Server 2000 to the latest version. I do not know the old version, now I am using SQL Server 2012 (11.0.3128.0).
The error messa...
Suber asked 3/4, 2013 at 13:25
2
Solved
I want to call stored procedure from a trigger,
how to execute that stored procedure after x minutes?
I'm looking for something other than WAITFOR DELAY
thanks
Messiaen asked 28/6, 2012 at 7:50
2
Solved
I discovered SUDDENLY that in SQL Server (2000) any field type value may be treated as quoted string (in query or DML).
Question:
Is it normal behavior or accidentally successful result?
Example...
Yuu asked 28/2, 2013 at 12:8
5
Solved
I have to update a big table with over 270 update fields.
I am relative new to .NET and need advise what is better to use in this case: SqlCommand, some kind of memory-mapped table or DataSet or m...
Sexuality asked 27/2, 2013 at 22:20
4
Solved
Possible Duplicate:
is there an advantage to varchar(500) over varchar(8000)?
I understand that a VARCHAR(200) column containing 10 characters takes same amount of space as a VARCHAR(...
Shovelhead asked 15/12, 2012 at 17:36
2
How can I construct the SQL that I need to query the Projects_dim table using the Linked Server "idwd"?
To test the connection, I ran a sample query using the linked server name. To acces...
Zetta asked 20/8, 2010 at 20:1
1
Solved
I have a table of a little over 1 billion rows of time-series data with fantastic insert performance but (sometimes) awful select performance.
Table tblTrendDetails (PK is ordered as shown):
PK T...
Langham asked 23/10, 2012 at 19:15
5
Solved
I'm working on a rather complex report in Sql Server Reporting Services. My SP returns a dynamic number of columns each of which are dynamically named.
Basically think of a time keeping applicati...
Seismism asked 20/5, 2009 at 15:34
© 2022 - 2024 — McMap. All rights reserved.