For questions specific to the 2005 version of Microsoft's SQL Server.
0
votes
0answers
5 views
Can I install SQL Server 2005 Enterprise on Windows Server 2008 R2 Web Edition?
So, as the title says .. Will it be possible to install SQL Server 2005 Enterprise on Windows Server 2008 R2 Web edition or just R2 ?
Kind Regards.
0
votes
2answers
17 views
SQL Error mesage relating to length of identifier
I get the following error, but not quite sure what it means:
Error message: System.Data.SqlClient.SqlException: The identifier that
starts with '[DEFAULT], 1 AS rowJoiner FROM ...
0
votes
0answers
17 views
SQL Server 2005: Arithmetic overflow error converting int to data type numeric
I have to filter a column called [Order] (data type = decimal(3,1)) in my final view for 1.0.
List of unique values for [Order] are:
1.0
2.0
3.0
4.0
5.0
7.0
8.0
9.0
11.0
12.0
13.0
My SQL ...
0
votes
0answers
9 views
Web-App using Hibernate that queries a SQL Server 2005 encrypted column
we are devolping a web-application using Spring 3.1.2 and Hibernate 4.1.7 with a database SQL Server 2005.
On a table we've got a column encrypted and we need to perform some queries like, for ...
0
votes
0answers
6 views
BCP Utility to output contents into CS
I have a stored procedure that gets a SQL query, file path (to output) and file name as parameter which I'm using to build a bcp command and finally executing the same e.g
SET @sql = 'bcp "'
+ ...
0
votes
2answers
31 views
Tips on generating dynamic form fields from a string of data?
So here's what I want to do. I want to take a list of phrases, and in certain parts of the phrases, indicate that user input is required.. be it a dropdown list, a textbox, a date field, etc. Kind ...
0
votes
2answers
45 views
SQL Select, selecting a row off of a column condition
Division Department Dept. Head
1 1 Mr. Anon
2 1 NULL
3 1 NULL
1 2 NULL
2 ...
1
vote
0answers
18 views
Flush print statements to client (SQL Server Management Studio)
Please see the code below:
USE [Test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Test]
AS
BEGIN
begin tran
begin try
SET NOCOUNT ON;
DECLARE @ID int
...
0
votes
0answers
13 views
File name generated by query used in attachment
I have this query that runs in SQL Server Agent and I need to be able to pick up the correct file. Currently I have it picking up a random file that is on the D drive but I need it to pick up the file ...
0
votes
1answer
6 views
Attach text file created by SQL Server Agent to email
Hello I am trying to figure out how to set up an SQL Server Agent Process that will pick up a file that was created by the step and send an email with the attachment. The first step is below. Would ...
1
vote
1answer
32 views
Want to read file retrieved from database in the same format it was being saved in C# windowsForm
I am using C# Windows Form application to insert a document file (word, pdf & text) in to SQL server database,The below code I used to convert the file into binary and after ward I upload this ...
0
votes
2answers
36 views
SQL Query to find the last day of the month
I need to find the last day of a month in the following format:
"2013-05-31 00:00:00:000"
Anybody please help out.
1
vote
1answer
21 views
insert multiple rows in single SQL
I am trying to insert multiple rows with SQL statement.
For that i refered this question.
According to top scored answer in this qestion, i made following query:
INSERT INTO login
...
-2
votes
0answers
20 views
Function Failed to Load images and throws SqlException
I had a list of quotations and answers both contains images; this function works properly but recently it started throwing an exception :
A network-related or instance-specific error occurred ...
0
votes
1answer
15 views
Error php odbc conect to store procedure in sqlserver 2005
I tried 5 days ago about php odbc connection to store procedure in sqlsrever2005, but it not successful. i had problem in odbc_exec point.
I dont know why ?
My coding as the following:
$connection= ...
