Hi, Our software uses 6 databases, each having 2 tables. We have a ReplicationService, which makes full/incremental backups on a regular time interval. Below is the sequence of commands which are being executed during full backup (sequence is executed for each database): USE <db> DBCC SH...more >>

Hi All, If we change the System settings to Swedish(Finland), the decimal space is a Comma "," instead of a Dot "." Now the problem is SQL Server does not recognize this and gives error. We can not do collation setting for numeric fields also. Any help on the same will be highly appreciated...more >>

I need to do a Find and replace exercise throughout a database... all Supplier numbers are changing. It is easy enough to do the replace... it's the finding that is somewhat difficult... they did not always call the column 'Supplier'... they also embedded the Supplier code in some notation col...more >>

Hi, I'm just getting started with MS SQL Server 2000, and I'm looking for a good book. Can anyone recommend a comprehensive and comprehensible reference? (Something with lots of pictures mebbe - heh.) Thanks, <I'm Not Norm>...more >>

Got a question. I have a situation where I have column defined as Integer. This column is being used as an ID for something and will always be unique. Let's suppose I have ten columns where the ID is numbered, starting from 1 and going from 10. The first row for will always start at 1. Suppo...more >>

I've never used this before so I'm not exactly sure if it will do what I need. Basically, I'm creating a DTS package that will run every 5-10 mins which needs to send emails to a number of people. Our table structures are like this: CREATE TABLE [dbo].[Email_List] ( [EmailListID] [int] ...more >>

Sorry about that last post, I have a SP that some what works, the following is my problem. I have three conditions, I would like to have it quit if one condition is true and pull from the other two no matter what the dates are, or if the first condition is not true and the second conditio...more >>

How can I convert the below to add one column that reflects the highest price in the recordset? Something like MAX(Prices.Retail) AS MaxPrice SELECT Stock.*, Prices.* FROM Stock INNER JOIN Prices ON Stock.Item = Prices.Item This doesn't work... SELECT Stock.*, Prices.*, MAX(Prices.Retail...more >>

Does bulk insert always insert records in the same sequence. Thanks!!! ...more >>

i would like the engine to combine multiple int's in a bitwise fashion. Something like: SELECT SID, Type, OR(Flags) FROM ACEs WHERE SID = 34 GROUP BY SID, Type would be ideal. Any other decent way? ...more >>

Hi all, There are appx. 40 user-defined data types whose definition has to be modified from varchar to nvarchar in a database in which there are a few hundred tables dependent on each of the user-defined data types. It therefore looks like I'd have to first get a list of the tables that are de...more >>

hi Can we write our own user defined Aggregate function in sql server 2000 eg median thanks ...more >>

Greetings, I am converting Ms-Access to SQL server but i have problems with the formula, in Access 1/1000000 = .000001 but in SQL server the result = 0, what was the problem? Regards, Arman ...more >>

I need to log all changes in all tables and in all fields. This includes inserts, deletes, and updates. Using SQL Profiler doesn't really do what I need because each time the server is rebooted somebody needs to get Profiler running again. Also, Profiler seems to stomp on previous log files or...more >>

Sorry, I have very little experience with SQL and store procedure. My store procedure is adding a new record, and I want the generated key to be returned. How do I do this? CREATE PROCEDURE [SP_ADD_CALL] @CallDate VARCHAR(10), @CallDay VARCHAR(15), @CallTime VARCHAR(8), @CallingN...more >>

Hi, I did get my answers but I guess I should rephrase my question. I have to check for a query without actually running it. The mechanism should check for valid syntax as well as database objects (field names, table name etc). The query could have lots of join conditions in it, so I dont want...more >>

Hello Why I can use DATEFORMAT in a function but I can use it on a Procedure? How can I use DATEFORMAT in a function? Andrew ...more >>

Hi, I have a requirement that I need to come up with a SQL code but I have no clue where to start. the requirement is "If the system crashes before all the information during a transaction fails, none of those changes will be saved to the database." Please help? ...more >>

Hi, I have SQL Server 2000 Developers Edition installed and have to change it to Enterprise edition. Can I install the Enterprise edition just over the Developers, or does this need an un-install first? Thanks. ...more >>

Hi, Given some T-SQL query, can we check whether it is syntactically correct at runtime? Is there some inbuilt mechanism that SQL server provides? TIA, Nitin ...more >>

When a Update occurs, I wish to compare the current date to the date field (in that update) and if that saved date exceeds 24 hours, update a flag.... Can a trigger do this? thanks Ralph Krausse ...more >>

Hi, I found some VB code to insert and update images in SQL Server. If say, I have some images in a folder, is there a way to actually insert either the image or a pointer to the image in a table through Enterprise Manager or SQL Query Analyzer? Any help is greatly appreciated! Thanks, Jane...more >>

Hi all, how to catch messages printed by PRINT statement from T-SQL command executed by Ado Command in Windows envronment. TIA, Marek Powichrowski ...more >>

I have a SP that create a temp table (Table A), of indexs to another table (Table B) of records that I need to delete in (Table B). The temp table ends of having 250,000 records. I tried to create a cursor, enum the table and the delete the records but I believe it is timing out. I was told to lo...more >>

I have a program that enters a string into a SQL database. The problem I have is if a user enters a " ' " I get a syntax error. How do I get around this? Do I just have to search for the parentheses and remove it before I do my insert? -- Steve Evans Email Services SDSU Foundation ...more >>

Hi, Is any way to use GETDATE() in a function? I can use it in store procedures, but I get the error 443: Invalid use of 'getdate' within a function. Andrew. ...more >>

I am getting this error message with my SP ___________________________________________________________________________ [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentatio...more >>

Hi, I am assuming that I have a "crashed" table on my database. I can get into other tables on the database but when I try to query a particular table I hang until timed out. ANY way to attempt any sort of analysis of "why" this is happening? And, any recovery besides complete DB recovery...more >>

Hi guy! As we know there is no ID field in sysfiles table. So when you run following statement you'll get the error message: select [id] from [sysfiles] Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'id'. But when you use the same query in where clause on a table whe...more >>

Run this query on the pubs database: select au_fname from employee It will fail quite correctly. Now run this: select * from authors where au_fname in (select au_fname from employee) It retreives ALL the data from the database, despite the 'in' query being invalid. Anyone else fo...more >>

Hello, please use the database at http://www.bhplace.com/database.zip for this question... it contains the data and stored procedures for this test... In query analyzer when I run this stored procedure like this on the database: exec BENESP_AddContractCountNewMonth '1 jan 2004',574 I e...more >>

Hi Everyone, I am writing a procedure that needs to query a single column from a table and store the column's value in a variable. The only catch is, the name of the column I'm querying is variable. Is this possible to do? A theoretical concept would be: -------------------------------- ...more >>

Hi everyone! I'm porting an old Access app to SQL Server and I have come across an awful problem... In access this app creates a query at runtime wrapping an already complicated query with a "SELECT * FROM (query here....) WHERE ...", so that to be able to build a custom where string at run...more >>

Hello, I'd like to repost this on the front page since my question from last week is now many pages back... (I hope this does not break etiquette too seriously) Here is the issue: A select inside a trigger will not work on the table because of a lock condition. The trigger and select are using ...more >>

Hello all, I'm having a problem with a query I'm working on. I have two tables as shown below (only the relevant fields are displayed): ---------------------------------------------------------- tbl_Stats_Calls ------------------------- callDate - smalldatetime userID - bigint in_...more >>

Hi. I have a table on my SQL Server Database that I want to be able to update daily, considering a new account can be added any day. We have a dbf file on the network drive, which is where i want the data to come from. How can i go about creating an import wizard that only inserts those re...more >>

Hello, We currently have our web site hosted and are also using a shared SQL Server for the site. When programming the site, I routinely use Enterprise Manager to design tables, look at raw data, write or diagnose Stored Procedures, etc..etc...All of this works fine. However, becaus...more >>

Hi all. Sorry for cross-posting but I'd really like to get an answer on my question. I was reading Sql Server help and found this: SQL Server 2000 has an efficient algorithm to find any existing execution plans for any given SQL statement. In most systems, the minimal resources used by th...more >>

I'm trying to update several views and stored procs using a .NET app. The script it generates is valid and runs correctly through Query Analyzer, but when its executed through ADO.net, which implies a being/end transaction, it gets an error. 'ALTER VIEW' must be the first statement in a quer...more >>

Is there a limit to the number of characters that can be included in a query statement for a view? If so, is there a way to increase the number of characters? I am working on view and all of the sudden it wouldn't let me type in any more characters. Thanks for the help. Derek Ruesch...more >>

Hello, Is there a way to display the execution time taken of a sql file through a batch file? Thanks in advance. Sheetal. ...more >>

I want to execute a dynamically built SQL statement of this form, using sp_executesql : .. .. ( @cnt int OUTPUT ) SET NOCOUNT ON DECLARE @SQL nvarchar(100) SELECT @cnt=COUNT(*) FROM tblX ....... 1. Can I do this? If I can't do (1) then what if I did this: SELECT COUNT(*) AS xxx FROM...more >>

Hi evryone I have the folowing problem I have two columns id (varchar 20) and parent(varchar 20) in table adreses Table has 20000 rows and some values in parent column are * I want those rows to change to x So this query works fine: select parent from adreses where parent='*' but the...more >>

I have some contact id's in one table, but only one row per Custid. However I need to insert this data 4 times into another table. i.e CustId Desc 1 31 1 32 1 33 1 34 5 31 5 32 5 ...more >>

Hello All, When I execute a sql file from the command line using the isql utility, it gives me an error( expected one ) in a log file stating the name of the stored procedure but its truncated ( not expected!). However, when I execute the same file in Query Analyzer, it displays the full name of ...more >>

Hello All, When I try to execute a sql file on command line using isql utility, it gives me an error (an expected one) giving the name of the stored procedure, but it's truncated(not expected!) in the log file. However, when i execute the same file in Query analyzer, the whole name is displayed. ...more >>

Hi Gurus ! Hope you can help me out ... Just a simple illustration using the examples below. I need the variable @CountRec to be returned when I execute it. When I run it, it says @CountRec not declared. It seems like dynamic SQL cannot get the data returned in this manner. --- Code -- ...more >>

I got one mdb file with some data. I want to export these data into Oracle 9i database. So I tried to export the data to oracle through the System DSN from that MS Access mdb file, but I don’t know where it exported in the Oracle database. Means the mdb file have one table called History, But...more >>

1. I have two Date in my oracle table; I want to take different between the both in years… Now I am using (Months_Between(Date1, Date2) /12) . If there any alter native, Plz let me know. 2. I want the equitant keyword of Sql server “TOP”? Ex. Select TOP 1 Id, Name from tablename M...more >>

It seems decimals are about twice as slow to compute with as floats. So use 1E0, 2E0, etc, where it makes sense to rather than 1.0, 2.0, etc. I found that this: SELECT AVG(c1.d * 1e * c2.d) FROM calendar c1, calendar c2 Took less than half the time that this took: SELECT AVG(c1.d * 1....more >>