Been fighting with sql and continually get errors when running this statement.
UPDATE [FSSINC].[dbo].[Customer]
SET [CustomerName] = CustomerName
WHERE <,,> i add the criteria. What i...
In my SQL Server 2005 Tables, there are some date and time columns with the follwoing shape: 1217147736160
How can I change it to a meaningful date and time format such as 'DD/MM/YYYY'?
Please provide code for connecting a project developed in Visual Basic 6.0 with SQL Server 2008.
<cfset datepassed = #DATEFORMAT(now(), "dd/mm/yy")#>
SELECT CONVERT(VARCHAR(10), TIMEDATE , 120) as varDate
FROM orders
WHERE YEAR(TIMED...
Hi
I have MS SQL 2005 EXPRESS AND SSMS 2005 on my desktop.
I want to install MS SQL 2008 EXPRESS and SSMS 2008. Do I need to uninstall the 2005 version?
I am trying to install SQL 2008 Express CTP and am getting an error that I have to have .net framework 2.0 SP1 and to download from microsoft.com/net. I go there to download it and it is not ...
I have an SQL database where different users entered values nto a field using different case.
Is there a sql script to convert all characters in a specific field to upper case?
I would like to install SQL Server 2008, but I only need to use the (SQL Server Management Studio), but I cannot find an option that will allow me to only install this part of the application....
I would like to install MS-SQL Server 2008 on a box currently running MS SQL Server 2005 -- is there anything in 2008 that would prevent installation as a separate instance on a box running 20...
I am trying to install SCOM 2007 on a Server 2008 using SQl 2008, during the pre-check it says I need SQl 2005 SP1. Makes no sense to me, I ahve looked on the MS SQL 2008 support site and cann...
Hi,
I see that SQL Server 2008 can handle now storing images in it, the big question is,
1- Do you guys recommend storing images in the database or storing file path to it?
2- If we are ta...
Hi, I have a Vista machine running SQLExpress. I want my WinXP machine to connect to the SqlExpress DB but I keep getting a "Sql Server does not exist or access denied" error msg.
I've dou...
Get the count of no of days (sat and sun) between any given start date and end date
e.g Between Jul 15 2008 and Jul 25 2008
I am inserting about 10,000 rows spread across 20 tables in C# with SQL Server stored procedures. It works fine but I'd like it to be faster. Is there a way I can do this with some sort of B...
I have a custom assembly that I'm trying to use with my resport in Reporting Services in SQL Server 2008.
I keep consistently getting a "Request for the permission of type 'System.Data.SqlCl...
I have a Trigger that fires off during an insert or update in one table. I need to get the ID for that line and send it to a stored procedure and use that ID to do some more calculations. I'm ...
Using SQL Express 2005, I notice I need to decide between nvarchar and varchar when creating a text column. What's the difference?
Does this also apply to SQL 2000 and SQL 2008?
thanks,...
I have installed Server 2008 on a 64 bit system including SQL 2008 x64.
When the prerequisites are run it complains it is unable to find SQL Server 2005 SP1.
I have checked the firewall ...
I have the following SQL Stored Procedure:
USE [vavacsql_local]
GO
/****** Object: StoredProcedure [dbo].[stpro_Inquries_By_Publication] Script Date: 08/08/2008 14:06:53 ******/
SET AN...
I have the following data... Need a cross/tab pivot to sum up Reps Amount by Month AND THEN DESC
REP AMOUNT DESC DATE
A 2 SALES 1/...
Hi,
I doing a project in .net2005 and using sql. I am trying to connect to the database from the crystal report 10 version. i created an odbc..the odbc connection when tested it shows test...
I have an SP that looks similar to the following:
@JobNumber varchar(25) NULL
AS
SELECT P.StreetNumber, P.StreetName, dbo.GetJobNumber(PDI.ID) AS JobNumber
FROM tblProperties AS P
WHERE...
We are an ASP providing software for small to mid-size companies in a niche market. We currently have about 1600 customers but are growing and would like to upgrade and consolidate our hardwar...
I'm trying to get data from DB2 using Ole DB Source object in SSIS. This works fine if I take all data from the table. But I would like to take just a part of the data. In the help is says we ...
I have to create XML output for the table in SQL Server database. All columns should be childred of the element with the table name. One column should be an attribute of the element with the t...
