Could someone have a look at my below delete statements and inform me how I could modify them (so that they work :)) to include the inner join and where not exists. At the moment I get the err...
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...
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...
Hi,
I'd like to to increase the size of the 2 columns EQ_ID and EQ_STD on my DB SQL Server 2005.
EQ_ID char(50)
EQ_STD char (50)
How can I create a script to change the size of this column...
I would like to update a column in a table with a string. Later on I would like to add to that string.
I tried the following query,
"update TABLE1 set COLUMN1 = COLUMN1 + 'TEST STRING' ...
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...
I have been working on a local copy of a db (localDB) and have made a lot of changes to some tables and added some as well. The live db (liveDB) is on a shared host and is still active. So the...
I know this is a newbie question, but can anyone tell me how to reset the auto increment field of my table to 1 or it's original value.
I've been using these tables for testing and the auto...
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 ...
I'm just curious if someone can give me some info about sp_execute and what it's used for.
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 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...
Why doesn' t the following work in the scalar valued function? I keep getting an error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '10/16/' to ...
How do you reset the IDENTITY seed on a column in a table using a T-SQL statement?
My situation is that I've written a stored procedure to copy data from from one table (AccountOld) to anot...
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 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...
We have a MySQL v5 database that sits behind a website on a web server.
A PHP script is used to take records and insert them into an SQL Server 2000 database that resides on another server....
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...
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 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...
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...
how to use SELECT CASE in sql query?please give an example
also how to use IIF in sql query?please give an example
I'm attempting to write a function that will provide me with next day of a given date. For instance, if the date I have is April 8 2004 (thursday) and I need the first monday following that d...
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/...
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...
