what does the following T-SQL means :
DECLARE @CLAIMERTABLE TABLE (ProdId varchar(100), Disclaimer text)
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 ...
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...
How can i get the "RowId" of a table in Sql Server?
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...
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
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 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...
I found this script to check if a column exist in a table and to create the col if not exisiting:
IF NOT EXISTS (SELECT TABLE_NAME,COLUMN_NAME
FROM master.dbo.INFO...
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...
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...
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...
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....
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...
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.
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...
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...
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 ...
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...
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...
I have a user that gets this error when opening an application:
"Unhandled exception has occurred in your application. If you click conttinue, the application will ignore this error and att...
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...
i have an important database that was hosted from a server in a datacenter, we were having problems with the machine so sql on it was backup up and it was reformatted. When we got it back onli...
Is it possible to downgrade a SQL 2008 database so that is can be restored in 2005?
