sql-server-2000 Questions
9
I have a SQL file/SQL string which is about 20MB. SQL server simply cannot accept this file. Is there a limit on the maximum size of the .SQL file or variable which is used to query or insert data ...
Dyspepsia asked 17/11, 2013 at 8:24
2
Solved
Working in MS2000, I have a table called JobOwners that maps Jobs (JPSID) to the Employees that own them (EmpID). It also contains the date they started owning that job (DateStarted), date they sto...
Dyestuff asked 21/8, 2012 at 17:21
8
Solved
I'm trying to get the last datetime record from a table that happens to store multiple status.
My table looks like so:
+---------+------------------------+-------+
|filename |Dates |Status |...
Glazed asked 14/5, 2013 at 18:55
5
Solved
A slightly tricky SQL question (we are running SQL server 2000).
I have the following table, StoreCount -
WeekEndDate StoreCount
2010-07-25 359
2010-07-18 359
2010-07-11 358
2010-07-04 358
2010-...
Viola asked 4/8, 2010 at 23:34
14
Solved
I have a query doing something like:
SELECT FieldX, FieldY FROM A
WHERE FieldW IN (108, 109, 113, 138, 146, 160,
307, 314, 370, 371, 441, 454 ,457, 458, 479, 480,
485, 488, 490, 492, 519, 523, 525...
Dateless asked 18/6, 2009 at 16:41
3
Solved
I have a very simple INSERT statement being executed from a PHP script running on a Linux Apache web server. I can run the query fine from within SQL Management Studio and it normally runs fine fro...
Laxative asked 16/6, 2010 at 13:31
11
Every now and then in a high volume .NET application, you might see this exception when you try to execute a query:
System.Data.SqlClient.SqlException: A transport-level error has
occurred when...
Marpet asked 19/8, 2008 at 17:36
2
Solved
Previously used this SQL Agent Jobs, how to document to get information about all SQL Scheduled jobs.
How can I find out the duration of the last run for each job? I need seconds, minutes, and ho...
Pendragon asked 30/6, 2011 at 17:41
5
Solved
I realize that temporary tables are session/connection bound and not visible or accessible out of the session/connection.
I have a long running stored procedure that creates temporary tables at va...
Jamin asked 16/8, 2011 at 8:29
3
Solved
I have been looking into this for a while now and I cannot find a way to remove duplicate strings from a comma-separated string in SQL Server 2000. I can find a lot of examples of this for SQL Serv...
Counterpane asked 2/1, 2014 at 12:1
4
Solved
I have some code of ADO.NET to dynamically detect the database schema, what I need is how to get unique columns constraints and Primary key constraints using the GetSchema method on SqlConnection. ...
Caracaraballo asked 1/5, 2011 at 16:30
5
Solved
Our system runs on SQL Server 2000, and we are in the process of preparing for an upgrade to SQL Server 2008. We have a lot of trigger code where we need to detect a change in a given column and th...
Surrealism asked 16/3, 2009 at 18:5
4
Solved
How can I find out the date a MS SQL Server 2000 object was last modified?
I need to get a list of all the views, procs, functions etc that were modified since Aug 15th. In sysObjects I can see th...
Philina asked 16/9, 2008 at 23:55
3
Solved
What is the difference between the following two statements?
alter table [dbo].[Demo] add constraint [UC_Demo_Code] unique ( [Code] )
go
create unique nonclustered index [UK_Demo_Code] on [dbo].[D...
Deborahdeborath asked 20/4, 2010 at 13:33
2
I have some T-SQL code using multiple if statements (about 100) as below. If the first IF statement condition evaluates to TRUE it still evaluates the rest of 99 statements.
IF(@check = 'abc') SET...
Presentable asked 10/10, 2013 at 16:30
4
Solved
The requirement is to execute SSIS package, when a file is arrived at a folder,i do not want to start the package manually .
It is not sure about the file arrival timing ,also the files can arrive...
Doc asked 29/1, 2014 at 16:7
8
Solved
I have to move an entire database from a SQL Server 2008 machine to a SQL Server 2000 machine.
I created a backup using Management Studio 2008, copied it to the hard drive of the 2000 box, and fro...
Delectate asked 16/11, 2009 at 20:57
5
Solved
For a stored procedure, I have its full source code. But the name of that stored procedure has been lost. In this database, there are hundreds of stored procedures.
So is there a way by which I ca...
Beautify asked 10/1, 2013 at 15:5
5
Solved
Is it possible using Try-Catch in SQL Server 2000?
Boykins asked 24/12, 2010 at 6:12
1
I am working on migrating functions from SQL Server 2000 to MySQL.
The following statement executed in SQL Server 2000, gives the output as 109.
SELECT DATEDIFF(wk,'2012-09-01','2014-10-01') AS N...
Custody asked 1/10, 2014 at 9:27
3
Solved
I'm using
convert(varchar(20), getdate(), 112)
to convert getdate() to yyyymmdd format (ISO format), which works great. Now I need to do something similiar to get the time in hhmm format. How c...
Tallent asked 14/11, 2011 at 18:11
1
Solved
There is a Union All query as shown below. When fired in SQL server, I get an error
"Cannot resolve collation conflict for column 1 in SELECT statement."
Please, where do I add the Collate da...
Lawry asked 12/8, 2014 at 9:23
2
Solved
Anybody knows if SQL Server 2000 is supported in EF 6 for Code First? In the official websites I haven't found anything about which SQL Server versions are supported in EF 6. In some blogs I've fou...
Tentacle asked 11/8, 2014 at 9:38
3
Solved
This question could easily take multiple paths, so I will hit the more specific path first. While working with SQL Server 2005, I'm trying to create a scalar function that acts as a 'TryCast' from ...
Agrapha asked 27/5, 2010 at 15:59
4
I have a table which has a column 'CompanyID int not null' and its default value is set to 10. Now I want to write a query which will alter this default value to 1. How can can I do it?
Any help w...
Haplology asked 8/12, 2009 at 9:0
© 2022 - 2024 — McMap. All rights reserved.