Hello,
I am using MS SQL, I am trying to update blank data on one table with data from another table. There are multiple columns I wish to update which are for example: "fullname", "descrip...
[SQLSTATE 01000] (Message 3014) Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101) RESTORE DATABASE is terminating abnormally. [SQLSTATE 420...
I get "Cannot connect to WMI provider" error everytime I open SQL Server Configuration Manager.
Can someone please take a look
=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...
How to find Size of Each Table in Database?
Something like TAble1 = 345Kb
Table2 = 3MB
Something like that.
I have a sql 2000 database that has been made suspect by having the log file deleted then replaced with an older copy. This is what happened. The database went into readonly mode because the...
I cannot figure out how to do this. How can I create a connection to an ODBC data source (already set up as a System DSN in data sources) from Microsoft SQL Server Management Studio?
Hi,
I'm new to Transact-SQL so just wonder is it possible in MsSQL to execute a stored procedure inside another stored procedure and save the returned recordset into a temporary table.
How do you within a query using sql 2000 convert a number in seconds....into hours and minutes...
Thanks
Hi,
We have a text field called Product that comes as:
12 TheNameoftheproduct
I would like to use substring to split the value into
ProductNumber = 12
Product Name = theNameofthepro...
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...
Hi,
Please kindly assist how can we convert on runtime from EST to CST?
select convert(EST,CST,DTStart) from MyTable
Thanks.
I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server databa...
Curious how to accomplish/correct syntax for the following in T-SQL...
Database Name: TestDB
Existing table name: MyTable
Existing Column Names: ID, NameFirst, NameLast, MyDate
Want to...
Hi,
I know Oracle uses a MOD function like Basic's to determine the remainder after a division. So 20 MOD 9 = 2 (9 goes into 20 twice for a total of 18, 20 - 18 = 2). I need to deter...
We are developing an Intranet for our organization and are using SQL 7.0 as the database for it. We have a content table with a field to hold the text for the various html pages. Can somebod...
i need to truncate this log file, 8Gb
documentation says i have to back it up and select the truncate on checkpoint option.
only thing is, from the server manager, when i do the backup, the...
Hi,
I am using a SQL Server 2000 DB, interrogated by Enterprise manager.
I can SELECT as:
SELECT c_AnswerMutli.*
FROM c_Applicant
INNER JOIN c_AnswerMulti ON c_Applicant.id = c_An...
Hi,
Ive got a stored procedure that is called from my ASP page. One of the parameters that is passed in like so:
.Parameters.Append .CreateParameter("@strAction", adVarChar, adParamInput...
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
Hello,
Could someone tell me how what the syntax is to convert a Julian date to a regular date format in SQL? Thanks.
d-
Hi there
I have a problem on my SQL Server 2005 - I don't seem to be able to run table functions (scalar I can), i can create table functions but not run them:
set ANSI_NULLS ON
set QUO...
Hi there,
Is it possible to get the client process ID of an application that runs on SQL server?
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?
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...
