I have a field in table Appointment called Memo (type text)
I would like a sql script which will remove all carriage returns in the text of the memo field and replace with a space or colon or...
I'm looking for dates in an SQL table, but the results are incorrect.
The datetime column looks this way by opening and viewing the table in SQL Enterprise:
8/10/2005 9:44:41 PM.
My q...
I have created a database which shows the administrator as the dbo owner. I have created a user which I want to be the dbo owner. How can I delete the default dbo owner and create my own
Hello experts,
I am having the above problem, i don't have nay idea how to fix it. The errors are on the following line;-
45, 52, 76, 83, 90
Please see below for code;-
CREATE PROCED...
Hi there.
I am coming across a particularly frustrating little error...I've scoured the internet and have yet to find an answer which works for me.
I have installed SQL Server 2000 Rep...
Is it possible to have a join in a delete query. Lets say i have a select statement that looks like this, is it possible to delete from the tblTemp table using a similar join, at the moment i...
Just examining my event logs, I am getting these errors from SQL. I've done some research but haven't gotten the error stopped.
Windows Event Viewer:
Failure Audit, MSSQLSERVER, Category ...
OK, we copied a working ASP.Net 2.0 App from a machine running IIS 5.1 under WinXP to a machine running IIS 7 under Win7. We Get: Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at line...
I have a field that I would like to only display the date as mm/dd/yyyy. Current field shows mm/dd/yyyy hh:mm:ss AM.
I would most likely create a view that will create a field that will di...
Hi,
I have a situation where I'm transferring data between two MS SQL 2005 servers and one of the tasks is to retrieve data from one SQL server [S1] (it is also a Linked Server) and export it...
I have a Windows 2003 Serever Standard Edition (SP2). I have some scripts that I use to backup a SharePoint Database SQL Server 2005. The below script ran successfully on c: drive. I needed to...
I have a table in MS SQL 2005
It looks similar to:
PrimaryId
Name
GroupId
Where PrimaryId is the primary key for the table.
I want to enforce that within a group, names are uniqu...
T-SQL, SQL 2005, VS 2005, ASP.NET, C#, Windows XP Pro
How can I trim outside spaces and blank lines from a TEXT field? I have a function that parses out each line of a TEXT Field into separa...
we just virtualized our sql server development box and installed SQL Server 2005 standard edition. Previously we were running sql server 2000. We moved over all the databases and I setup the...
Hi
Does anyone know whether this is possible.
I want to insert 2 values into a table, only if 1 of the values match the value in a table column
i.e
@Number VarChar(100),
@Code VarCha...
How can i get the "RowId" of a table in Sql Server?
I want to convert some ntext fields in a table to varchar, keeping the same column name and data. Is there a way to do this in sql?
Thanks, Tom.
How to do this:
select * from consent_properties where
(select streetaddress,count(con_consentid) as consents
from CONSENTS con, adults adl, CONSENT_PROPERTIES conprop, property_ids pids...
Suppose I have a table like this
id(int) logged(datetime) keyPressed(char)
1 05/17/05 11:00:00 PM H
2 05/17/05 11:01:00 PM ...
Hi again,
I need to create a function that returns a boolean value, to be used in a CASE expression.
I have tried with 'RETURNS BIT' but it is not considered as boolean an SQL fails in the c...
Hi Experts
I have a SP that creates a varchar(200) string that creates from a table entry such as (A+(0.75*B)) a string such as (0.093000000000+(0.75*0.004087939911))
I now need to evalu...
I get the following error:
Msg 1087, Level 15, State 2, Line 16
Must declare the table variable "@table_name".
In the following code:
=============================================
DECLA...
Why won´t this work?
"Microsoft OLE DB Provider for SQL Server (0x80040E57)
String or binary data would be truncated."
To me it appears that it wont convert the Date to VarChar Datatype....
I want to create a stored procedure in SQL server 2000 with a parameter that will default to today's date minue 30 days. I would also like to ability to over ride the default value in the stor...
After SP 4 installation on MS SQL 7.0 I found problems with clients (ODBC) connectivity. Connection using Name Pipes works fine, but TCP/IP connection fails. The error message on clients is SQ...
