Hi, your prompt help in this will be greatly appreciated I have an sql table below with some sample dat Table-FunctionalConten TrustCode OFA FC 5A1 20000 2 RR8 18598 1 RBA 36578 7 5HA ...more >>

How do I lock a particular record that one user has opened for editing? If I use the pessimistic type, can other users view the record (but not edit it) and return a message telling that another person is editing the record, or does this type lock the record such that it is unavailable until t...more >>

Hi, Being new to SQL, I need some help with the following situation. I have a linktable that contains a column called TaskID and one called RequestID. I would like to check on each insertion that there is not already a taskID added for the particular RequestID. I.e. it should not be possib...more >>

I have column A , B in a table. Data in both columns could be repeat individually. However, when the combination of A and B should be unique. I tried to make them as a primary key but no success. Any idea could make it happen I am using SQL 2000 standard. Thank you....more >>

Greetings, I'm having a bit of trouble with getting a query to run. I worked up this first one, which is VERY similiar to what I'm trying to do with the second one(the one that doesn't work). The following query works fine, and generates the results that I'm looking for - I only show it to illus...more >>

We have been doing some performance testing of bulk inserts (100+ records) using ADO.NET and SQL Server 2000 (default setting) on Win2K3 server. We have found the following: 1) Parameterized queries show no improvement over literal queries 2) Inserts performed in a transaction show a 3x improv...more >>

Hi, I have a question about the performance of inserting binary data. I am using SQL 2000, with SP 3A. We do a lot of binary data insert (about 300 files of the size 1M Byte everyday). I discovered that most of the inserts are done smoothly, and quick (no longer than 1 second). But, once ...more >>

I'd like to display messages from within stored procedures. are there ways to display message boxe or in a status bar? thanks in advance....more >>

As Title. Thanks in advance. David ...more >>

hi NG! dows anybody knowas a tool or an application which is able to synchronize automatically 2 MS-SQL databases in defined timeslots? i would like to have identical data on both databases. thx lot monika ...more >>

Hello All, I need help in writing a script to update all the elements on a varchar column that start with a number according to the following example: Original Value Modified value '12abc' 'XX0012abc' '1' 'XX0001' '1234' 'XX1234' 'a...more >>

I need to update a colum by multiplying two colums together but how can I make it look through all the rows of my table? With this I can update the particular row: UPDATE VENDORORDERITEMS SET EXTENPRICE = (SELECT SUM(UnitCost * Quantity) FROM VENDORORDERITEMS WHERE VENDORORDERitem...more >>

How to find out trigger status, i.e. enabled/disabled. TIA ...more >>

I'm having trouble with the below listed UserDefinedFunction. When I run this, it seems like the WHILE loop is not working, the function just returns the value that's in the first field of the delimited string: CREATE FUNCTION udf102_ParseField( @argMsg varchar(4000), @argDelimit...more >>

Hi All, Is there any sql function or a system SP that I can use to get the creation date of a physical file. Thanks, Tom...more >>

Hi, Is it possible for a trigger to access the login information for the operating system of the client computer? thanks, Ellie ...more >>

I want stored procedure A to call stored procedure B, which returns a set of records from a table. Then, I want stored procedure A to perform work on these records. How do I call stored procedure B from within stored procedure A? ...more >>

this sounds really silly but is bothering me to death I have a block of code that I run statement by statement (in query analyser) and it runs under 10 minutes flat (even when there are multiple users running their heavy duty queries). I wrap the same code in a procedure and run it (when I am th...more >>

I have studied this problem and am unable to come up with a set based solution. In light of the frequent remarks in this forum that seem to indicate that a cursor is never needed ~ever~, I'm seeking help in finding a solution that so far has been elusive. The first update statement in the _Up...more >>

Can someone point me in the right direction? I am trying to turn-off (hide) specific objects on a form based on the current user's permissions (access). I was trying to use the Permissions() function but I can't seem to figure it out. When I use the following in the Query used...more >>

I want to list records that starts with Ordernr in a textfield called Varetekst My code is SELECT Varetekst FROM TABLENAME WHERE Varetekst LIKE 'Ordrenr.*' An example of the field Varetekst is Ordrenr. 012344, Ordrenr. 23112 regards reidarT ...more >>

I couldn't restore a SQL database on my local development PC and so executed SP_WHO2 based on some tips found online. Not sure, however, how to interpret the results: there seem to be four processes "using" the database, consuming 0 CPU, associated with .Net SqlClient Data Provider, with 01/01 ...more >>

The update statement doesn't update all the rows matching in the join condition: BEGIN TRANSACTION update GEN SET app_date = tlh_1_745 from datatrac.dbo.gen G INNER join tborrower.dbo.bors B on G.loan_num = B.tlh_1_364 where rtrim(loan_num) <> '' COMMIT TRANSACTION select G.loan_nu...more >>

I have a stored procedure which I would like to pass a parameter to filter the final result set. Similar to this. I get an error telling me to pass in the parameter. If I pass in a single name, it works but I'm unable to pass in multiple names. Any advice as to what I'm doing wrong? declare @f...more >>

Two scenarios: 1. I have to pass files (image or text) from a .NET (C#) app to a SQL2K server. Sql in turn stores some meta information in a table and writes the actual file to disk. 2. I have to retrieve those files from the file system through SQL Requirement is that due to firewall restric...more >>

Below is a stored procedure that contains dbo.Views.O_Closest_to_Now. The View works just fine. However, when I run the stored procedure it is unable to locate the view. What am I doing wrong? CREATE PROCEDURE dbo.O_Fake_Plot AS SELECT ...more >>

SS 2000; see the code below I'm trying to restore to a point in time. I get the message shown below the code. I don't want to load more data, or for the database to be in load state. How do I accomplish that? thanks ============================== RESTORE DATABASE xxxxx FROM disk = 'x:...more >>

How do I remove backslashes from the date in a text field 10/5/1932 1/10/1949 4/19/1984 10/12/1977 10/28/1964 I need them to look like 105193 110194 419198 1012197 1028196 Then, I need to export it to a fixed delimited text file as a 10 character field ...more >>

Hello I have a problem with a stored procedure that accepts three parameters. These parameters are used to query the table. Client can choose to use all three, just two, or one. Getting error on one line in stored procedure (marked with "----"). Errors say either "invalid column name" or "must ...more >>

Hi all, How can I send an email in different language other than English using SQL Server? Thank You Raju ...more >>

Hello, I am trying to write a VB.NET application to do this: 1. Count the number of Read/Write accesses to a DB on the server and, 2. Get the last access time of the DB since its creation. Tried looking it over at MSDN...tried googling....but have failed. Any inputs would be more than valuabl...more >>

SQL 2K We have a data-warehouse server which loads data from different databases which resides in a different server, perform business logic and load into a FACT table. I created 4 SQL jobs which does the above same thing from different databases and writing to same table. This job is schedu...more >>

SS 2000 Is there a way to search a column, using a regular expression in T-SQL? Thanks...more >>

Hi I have table A with formulaid and formula for a caluculation (eg. Amount * Rate). Amount and rate are from table b. Table b has formula Id. In selects I can do Select a.Formula, b.Amount, b.Rate From a, b Where a.formulaId = b.formulaId. Is there a way to update let's say b.Calculate...more >>

I was so proud of myself a few moments ago. I had finally learned how to email a qeury to my sql server and have it email the results back to me. I did this using various extended sprocs like xp_readmail, etc.... I say "was" proud because I have now discovered that ANYONE can send the s...more >>

I have a query giving me a message I can't seem to figure out... "Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '='. Here's the query: SELECT t1.clnMinedAreaGUID, Max(IIf(v1.nomen = 'Unknown other UXO', 1, 0)) AS UXO, Max(IIf(v1.DeviceType = 'Anti-Personne...more >>

It seems that the 'next_run_date' stored in the msdb..sysjobschedules doesn't always (or hardly ever) match the next run time for a job that is displayed in Enterprise Manager. Can someone explain how/when this field gets updated (or better yet, the purpose of this field if it really isn't the n...more >>

Hi all ! Is there a way to know, when an insert,update,delete trigger fire, what am I doing ? I mean : am I inserting ? Or am I updating ? Or, maybe, am I deleting ? Thanx in advance Fabio G ...more >>

MSSQL2K... I am trying to use T-SQL to return a column default value (see example 1), or default function (see example 2). Examples: 1. Simple default constraint - assume an INT column 'Col1' on table 'MyTbl' with a default of 0. I'd like to return 0 given the table and column names. 2. M...more >>

Is there a way to run a stored procedure from the Enterprise Manager? I'm trying to find a way to quickly test the sp's that I create. Thanks, Gordon...more >>

I'm trying to take a set of records which all have a field called PreviousId as well as ParentId. PreviousId is the previous id of the row before the current row. ParentId is the master id for the row. Basically, I want to select all rows given a ParentId and return them in order so the row...more >>

Until now I have always used varchar however I have been examining some MS example db applications and have noticed they use nvarchar for things like customer name etc What is the difference and is nvarchar better than varchar for columns like customer name etc ? Thanks Murphy ...more >>

Hi *.* I've a table used for a 6 levels accounting system contains a Date Col, Some other Cols about the account and 2 fields : Debit and Credit which used to save the price. I want to get sum of these two fields this way: User inputs a Date Range and I want to return flow of the account...more >>

Hello. I have a small problem. I have a query that working fine in the query analyzer but if the query is in a stored procedure I get error when I call the procedure. The procedure gets 2 parameters. The working query is: select top 10 ProcessName, id, startdate from ProcessData wh...more >>

We are seeing deadlock message in the event viewer when running a transaction in sql server 7.0 database. Following is the message: "The description for Event ID ( 4 ) in Source ( TEST) cannot be found. The local computer may not have the necessary registry information or message DLL files...more >>

This is probably a stupid question loads of people of asked before but... How can I easily compare the time parts of two datetime fields. E.g. If I had a table that had a timestamp field in it and I wanted to see all the records added or amended after 7pm (with the table having approximately one mo...more >>

My code in question is to do with upgrading to later versions of the database. Often I want to insert a new column, and in development I have chosen to actually insert these columns between others, i.e. not just appended at the end. I know that ALTER TABLE ADD <column> is simple but will only appe...more >>

Hi, when i try to start SQL Server Service I Have a Error. I Must Reinstall SQL Server 7 or i can repair without reinstall?? I have this Error: 2004-04-13 15:50:52.26 kernel Microsoft SQL Server 7.00 - 7.00.699 (Intel X86) May 21 1999 14:08:18 Copyright (c) 1988-1998 Microsoft ...more >>

When creating a Foreign Key constraint, does the server automagically create an index, as it does with a Primary Key constraint?...more >>

Is there a TSQL statement I can execute to determine if the SQL Server Agent is running? Thanks, Amos ...more >>

I have three tables: stats, profile, tea In table "stats", I have statid, profileid, teamid, oppid, stats1, stat2 In table "profile", I have profileid, name In table "team", I have teamid, teamname I need to select individual stats records that can call stats. profile.nam teamname(teamid ...more >>

Hallo All, I believe this must be pretty simple that the online-database has no similar record. To me, it is a mystery and I need your help. I have a table that I want the IDcolumn to have at least 4 digit num as ID without using trigger, for instance “00001...00000n” auto increase. The...more >>

Hi, How can I use T-SQL to list the tables, column names, column data type, column length of a database. Thanks....more >>

Hi I want to match to colums from diff tables up on mfrpart and serialno both have matching 6 digit figures although mfrpartno has 10 in some instances but I only need to match the first 6 digits and disregard the remaining 4 digits on mfrpart does anyone know how to do this for a query ...more >>

Hi I am trying to use an ADO _ConnectionPtr to execute a (TSQL) bulk insert (in a multithreaded application). Sometimes this works and sometimes it yields the error : -2147467259 (with the same statement and the same database) When I execute the statement through the query analyzer it allways work...more >>