SQL Server installed for testing on WinXP Home SP2 and IE7.
Workstation running WinXP Pro SP2 with IE7 and Office 2003 SP2 produced this error when trying to run the Upsizing Utility in Acc...
=IIf(Fields!New_Old_CC.Value = 1, SUM(Fields!PDC.Value),0)
How can I check to make sure New_Old_CC is not null or maybe better yet IsNumber or both before evaluating if it is 1 or 0? I kno...
If I have a date in a sql table 1900-01-01 00:00:00.000 how do I display it as 1/1/1900?
The below statement returns: 01/01/1900.
select convert(varchar, getdate(),101)
Sql 2000
I am trying to create a SQL Server database. In one database I have a table named "book" with columns ISBN, Title, Author, Condition and Book_ID. Book ID should basically be a composite of ISB...
hi i get this error when trying to load SQL Server Management Studio Express. i used CTP version previously. i uninstalled the CTP before installing the new one.
both also gave me this erro...
Current::
SELECT DISTINCT product_type, COUNT(*) AS Count, severity_code
FROM dbo.probsummarym1
WHERE (dept = 'it- operations') AND (product_type= 'other / to be determined')
G...
We are trying to add SA (default SQL account) to the new SQL database.We are getting error 15405:cannot use the reserved user or role name 'SA'.Microsoft SQL-DMO (ODBC-SQL State:42000)
Wher...
What's wrong with following sql
Declare @Decimals Integer
Declare @Digits Decimal
DECLARE @myval varchar(9)
Set @Decimals = 3
Set @Digits = (9 - @Decimals)
SET @myval = 193.57
s...
If I run this query on my database:
DELETE from products
WHERE id='30'
I get this error:
Delete statement conflicted with COLUMN REFERENCE constraint 'FK_product_g_prudu_OF582957'. The ...
I'm just curious if someone can give me some info about sp_execute and what it's used for.
I have a user who for some reason had her login disappear from the server. Not sure why, but the issue i'm having is trying to add her back. Her login doesn't exist in the security list nor ...
Hi Experts,
I have the following table:
rowID country destination bkgDateStart bkgDateEnd pickUpStart pickUpEnd carCode band supplier
1 ESP IBZ 01/12/2004 31/12/2005 01/01/2005 04/...
I have an existing stored procedure that returns a set with a single field in it.
My question is, in T-SQL what is the syntax for getting the value of this field in to a variable?
DECLAR...
Hi,
Sorry, I'm a DB newbie and this probably has a simple answer, but given that it's the week after Christmas there's no one anywhere to be found around here and the MSSQL docs aren't muc...
Good Day
Experts:
I am getting this error "SQL Server blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures". Using a db that I created here, I have no pr...
OK,
DECLARE @ident int
DECLARE @docpart varchar(60)
set @ident = @@Identity
set @docpart = @Ident+'_'+@DocName
print @docpart
I'm trying to create a string, set to docpart for u...
I want to add Joomla to my server. We are on SBS so it has our SQL server and webserver and everything. I wanted to know if I had to use mysql or if I could just use MSSQL. I can't find a d...
All,
I am trying to access an MSQL server through Enterprise Manager. I am trying to update a stored procedure. When I try and save the storeds procedure I get the error "Error 7416: Access...
Hi
I wouldn't think this is difficult todo but I haven't found solution. Its to pick a column from table from a set period. I get error in title from stored procedure "Conversion failed when ...
Hi,
My web form contains a textbox where users need to input date (dd/mm/yy), I am using a parameterized stored procedure to update my SQL DB table, but I am facing a problem with the date...
Trying to use LIKE in the CASE statement but not working for some reason (won't execute). Any tricks to using LIKE within a CASE expression?
How do I find and install sqlcmd.exe? I was upgrading Neat Receipts and it came back with an error of can't locate sqlcmd.exe. I went into the tool\binn and for whatever reason it's gone. I...
I have a table with about 2500 records on it. I need to delete a single column of information from the table. How can delete the value in this single column for each record without deleting th...
This question has been asked in a couple of different ways, but I think I'll need to ask in my own way.
I'm trying to connect to a SQL server and can't figure out why I'm having problems. ...
I have a SQLServer, which was a installed on a stand-alone machine, running fine. I attached it to a domain and I am trying to install Microsoft CRM 3.0 on a seperate server, using my newly at...
