Hi,
Sorry if this is an obvious question, but how do i find the size of a MS SQL Database. I thought using properties would show me, but i'm not sure if it is correct.
I have backed up th...
I have a windows 2003 server cluster setup and installed SQL server 2005. In one node the sql 2005 works fine but when failing over to the second node all the drives fails over fine but sql i...
Hello
I have a table with the following structure
wrm_id int
wrm_createddate datetime
I require the following output:
Week Date(startingMonday) Numbers of work requests(wrm_id)
...
ALTER PROCEDURE GetTimeTable
(@UserName NVARCHAR(50), @WeekNo INT, @Year INT)
AS
IF @WeekNo IS NULL BEGIN
SET @WeekNo = DATENAME(week, GETDATE())
END
IF @Year IS NULL BEGIN
...
If a query in a batch fails, shouldn't the whole batch fails? Here is my scenario I've got hundred of stored procedures running in a batch so
Begin
Execute stored procedure
Execute stored...
Hi,
I am working with Sql Server 2005 and trying to filter my query results with the following:
1) Contain only alphas. Therefore A-Z and a-z (including spanish character if possible e.g. ...
I have two tables, one is a list of categories, the other a list of items listed in the categories. The category table is self-referencing through a ParentID column. Top-level categories have ...
Hello all,
following scenario:
I have one SQL Server 2005 Standard and probably either one SQL Server 2000 or another SQL Server 2005 instance running.
On both server instances will b...
I'm wondering if there's a way in SQL to transform the data that is transferred to a new table based on what data is found in a field of the source table. In other words in the example below...
Hello experts!
I am considering to migrate one of our mission crtitical databases running SQL 2000 to SQL 2005 ,as i was attending the launch of SQL 2008 in Dubai ,i had the thought of migrat...
I need to order my sql query by the number fo times @KEYWORDS is found in the search and then I need to order it by Navigation.name. Do I need to use a CASE statement? I have never used one be...
Hello again Ladies and Gents,
Like most of you Access x-perts, I have a great table driven method of adding new tables and fields to my access database. I don't think I've actually opened or ...
I usually use Access to work with the data in my SQL Server 2000. Recently I used Enterprise Manager to add a field to a table, then populated the field with data by creating a SQL query in En...
I have a table that I want to insert a new record, with some hard values, but use an existing value for one of the fields if it exists.
INSERT INTO adm_testing
(EmailID, StartDate, Progra...
I have a database with about 150 tables. Historically I have maintained referential integrity through triggers but this is getting a bit difficult to control now as, for example, I have one t...
Hi.On my box i have MS 2000 and MS 2005 installed. There is default instance for MS 2000 which longer i not need. Is removing the default instance of MS 2000 will affect the working of exisitn...
I would like to create a query that looks through a table, and for each unique key in one field, find the newest corresponding date located in another field.
If I have a table such as:
t...
I have 2 tables
Table 1 = Field1, Field2, Field3, Field4
Table 2 = Field1, Field2, Field3, Field5
What I want to do is to update Table 1 with the values in fields 2 and 3 of Table 2 whe...
i have a join of a "customers" table to three related tables: "sales","Parts","service"
the problem is wanting to remove duplicates based on the maximum date value found in any of the three t...
I have these triggers, that are done on many tables. Could these cause an infinite loop the way I have coded them? I want the latest update to be set to the getdate() on insert and on update. ...
Hi all
In Access, I can get a two-digit month number (01, 02, ..., 12) using Format(date,"mm")
What is the T-SQL equivalent? For some reason it's not coming to mind.
TIA
Jim
Hi All
I'm converting some Access VBA to T-SQL where I take a Currency value, remove the decimal, and feed it as a char(14) with leading zeros.
Access: Format(Round(1234567.89*100),"00...
Hi,
I have a db with 800 tables, 350 tables got a field called "DeleteFlag".
How to update all tables where the field "DeleteFlag" exists and update it with the value "1"
Thanks,
HP
I created this script to output the results from a stored procedure to a text file. The file is not being created.
I need to keep an easily accessible record of user id's and time whenever someone accesses a particular SQL Server 2005 table. I have used triggers to accomplish this in the past, to record ...
