I have a file that gets exported from an Excel spreadsheet. The time in the spreadsheet is saved in 24 hour format as a number in Excel (ex: 0900 or 1530). When import SQL simply sees these ...
Hi
I use microsoft SQL server 2000
I have a table of person names and I have the follwing SQL
SELECT FirstName FROM Names
This gives me one column with a row for each person.
Now I ...
I am getting this error on my database server.
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was fo...
I'm a bit confused with the 4 properties in SQL properties page. Currently our database has following properties;
In General tab:
Database Size: 35000MB
Available space: 9500MB
Files ...
I was wondering if anyone knows how to implement an iteration counter in SQL. Heres what Im talking about:
Imagine you have a table called IntegerNumbers with a single field called ii. ...
Hi,
Sometimes some of our fields in a SQL Server database contain characters like ö, Ç ä, Ö etc.
One of our applications that has to work with this data really doesn't like these.
I am loo...
I have a stored procedure that I have been using for a while that grants execute rights to all the stored procedures in my database (see the attached code snippet).
The input parameter is o...
I received a post from an anonymous guy. According to him:
===========================================================
"........... Stored Procedures are now-a-days not a choice for enterpri...
I'm trying to delete data from Excel spread sheet from SQL Query analyzer and getting following error message.
I tried following query to delete the data in spread sheet.
delete
FROM E...
I maintain an aging Windows 2000 server. It has an 8GB C: partition. Every so often, the server hangs because the free space on C: drive was filled. EE research yielded the information in the ...
I have a new application that is connecting to SQL 2005. Every time I run I get the following error:
A network-related or instance-specific error occurred while establishing a connection to S...
Hi experts,
I need help to convert the following SQL statement in Oracle using DECODE into MS SQL SERVER version.
Thanks
Herman
Recently we have big discussion in company why to use or not to use Select * in our SP's and there were many "for and against" so i need some expert opinions.
We all agreed that additional ...
Good Day:
I am using SQL Server 200. I need to change a user password. I looked at the following example and it says I must login into the Query Analyzer using the SQL Server Username tha...
I am migrated a DTS package from SSIS. I get this error
[OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E21.
[OLE D...
I am seeing the error below in my logs and have tried to run the DBCC Checkdb command on the database. I could use assistance from someone who knows SQL much better than me.
The error:
**...
Hi experts!
I had an issue where I needed to rename variable / text in all stored procedures where found. I looked everywhere (i think) for a solution and could not find one so I came up wi...
Hi,
I have a table with a TIMSTAMP column. I am tring to create a view on this table and want to cast/convert this column to something that is "readable".
I understand this is a binary...
Hi,
I'm looking for a bit of help writing an SQL query similar to http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21982550.html. I'm using MS SQL server 2000, which may be...
I have just installed SQL Server 2005 Evaluation on a Windows Vista Home Premium PC. I downloaded the application and Service Packs for SQL Server 2005 and Visual Studio 2005. I would like t...
Sorry if this has been asked before....my searching skills couldn't find the answer today :)
So my question is: How do I concatenate subquery rows into a single field. I may not be using...
I am experiencing a problem with my maintenance plans running under SQL Server 2000 running on Windows 2000. I suspect that the error (below) is occurring due to permissions problems with the ...
I would like to order a set of points based on gps locations, such that the driving distance is the shortest. When I have three points it would bot matter going form A to B to C back to A or ...
Hi there,
I using KenicoCMS software to manage website , installed MS SQL Server 2005 and restored all the files from bak db . Firstly it can works but afterward i facing the following erro...
I am trrying to create logins to a few database servers, i tried two scripts, some of them work on a particualr server while the second works on some servers.
here are the scripts
USE [...
