Dear All, I am performing a data import on the SQL server. Due to fact that I use the excel file as a source. Some of cells in excel are actually empty, they become NULL fields after importing into the SQL server. Actually I want these fields are empty string instead of NULL. Does SQL s...more >>

Dear all, I want to use C program to connect MS SQL server. I copied some sample file to install on my computer. When I run the program, an error occurred, which is about ntwdblib.dll not find in some paths. But when I check the paths again, they have ntwdblib.dll. When I run my C program in...more >>

Hi, is it possible to create an "INSERT INTO ..... "Select from stored procedure" Query? I want to create an temporary table. In this table I want to enter the data, which I can get from an stored procedure. But in the FROM-clause a stored procedure is not allowed? ...more >>

I have a table that has numerical ID. I want a query that will get the 20 highest IDs. So in other words the query would return the last 20 results entered. What would even be better is if they were distinct entries by another column, but it still returned 20 results. Can you specify in...more >>

On a production database, there is a 2GB database, when I run sp_spaceused it indicates a very high quanity of unused space. The database has been shrunk & free space sent to the OS. Why is this value so high, what can I do to reclaim the space? database_name database_size unallocat...more >>

select *From titles (18 row(s) affected) Totally 18 records are there in Titles table. When I query select title,title_id From titles where title like 'T%' and title_id like 'M%' It is returning 2 records. So,now if I introduce a not in 2 places also it should return 16 records...more >>

Hi all, I want to create a stored procedure which will extract the "GroupName" from the record returned by "sp_helpuser". In order to do this I need to execute "sp_helpuser" which returns the entire record. I want to just extract the "GroupName" from the record and return it to my application...more >>

I am trying to write updatable cursors in a stored procedure? Can I get any help to write updatable cursors? Any help would be appreciated very much. Thanks for your help in advance. Rajah V. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USEN...more >>

When I run the attached query, I get duplicates when there is one to many relationship between tableA and tableB. The query, tested schema and the result is attached. Sorry for the long post. Here is tested Schema and Data inserts. ---------------------- create table TestTblA (ShipDate datet...more >>

I have a column of digits I'd like to copy into another column in the same table. How would I do this? Thanks, Bill...more >>

I would like to know how to write a function that will go through data in a column and change it. For example, I have a column of ISBN's for books, and the ISBN's have a period in them randomly distributed. I'd like to pull the period out. Any help I can get will be appriciated. Thanks, ...more >>

Are there any limitations or gotchas to updating the same table which fired a trigger from within the trigger? Some example code below. Hmmm.... This example seems to be working fine so it must be something with my specific schema/code. We're working on running a SQL trace but if anybody ha...more >>

somebody helps ? 1.What kind of lockes are created on what resources when following querys executes ? select * from JOBQUEUE where ID='XXX' update JOBQUEUE set columnA='YYY' where ID='XXX' 2.Under what kind of situation, share lock on a row or on a page or on a table will convert to ex...more >>

I want to backup selected tables from a database and restore it . How can i do it -- Posted via http://dbforums.com...more >>

Hello , this is my first posting in this group. I am running SQL server 2000 on my windows 2000 server box. I use it for my Siebel database. When ever I launch Query Analyzer and chose SQL Server Authentication I get the error message below: [Microsoft][ODBC SQL Server driver][SQL Server] Lo...more >>

My Name is Nick Soutter, I am the owner of a small game company, Aepox Games (We're in the middle of a name change from "Lamar Games"), www.lamargames.net. Our first commercial game, Andromeda Online (www.andromedaonline.net) is going into beta soon. It runs on an evaluation edition of SQL...more >>

We have a SQL Server 7.0 database running with trunc. log on chkpt and select into/bulkcopy checked and need to develop a backup strategy. One of our DBAs insists that since the transaction log is being truncated, we can't do a hot backup (a FULL backup in multiuser mode) because if a transac...more >>

Hello, We have a query which returns ~2.8 million rows. This same query is used in a DTS package, which exports to a text file. The number of rows in this text file, however, is ~2.7 million rows (I'm rounding of course.) So a good chunk of data vanished in the export it appears. Using S...more >>

hi folks, i'm puzzled over this one, anyone with some solid db experience might be able to enlighten me here. i'm modelling a file system in a database as follows, and i can't figure out to cleanly implement an inheritance mechanism. i have a hierarchy of folders in an sql table. every fo...more >>

Would like to implement Blat on SQL Server 2000. I'm looking for example syntax for setting up BLAT with xp_cmdshell. TIA...more >>

Hi, We have a unique situation here that is puzzling me. I have a program that uploads data to our SQL Server. The program runs fine on WIndows 95. I have installed it on a Windows 2000 machine and it will connect to our data but will not upload. It processes the file but the data does no...more >>

Dear Friends, I don't know anybody has asked this question before or not.But I need a support urgently.How to take online backup in MS Sql server 2000. Thanks Arijit Chatterjee...more >>

Hallo everyone, is there someone who is partecipating to the Microsoft Yukon Beta test and who can send me some picture of the new GUI of Enterprise Manager and Query Analyser? Send it at my own e-mail l.braidi@delfi.it Thanks Lorenzo Braidi...more >>

Is there any reason why SQL Server (EM) would go through all the motions of a restore and not actually do anything at all? To get into this situation I backup from a client's server and download that backup to my server where I restore it, as I hate having to type in the physical path names ea...more >>

I've got a field [user.unitID] that can be a foreign key on the table [Base] *OR* the table [Command] depending on the value of [User.role] (see "Structure," below). Question 1: Is this poor DB design? Question2: If this is okay DB design (or, if I can't change this DB), how do I perform a jo...more >>

What is the documented and known behavior of inserting hex constants into a binary/varbinary column from a client to a server which have different code pages? Will any code page / character set conversion take place? eg: insert into t1 values ('AA') or insert into t1 values(x'AA') Thanks Aakash...more >>

Hi, i need to round: 3° decimal between 1 and 5 LOW 3° decimal between 6 and 9 UP Thanks...more >>

I have an ASP page that will take form info that a user has entered, then save it into SQL server, and retrive and display the info on another page. My problem is with long text data (10,000 bytes or more). It appears to save the long text data, as in it gives no errors... but it does not save...more >>

Hi, Can anyone advise me of a quick way to estimate the time taken by DTS to import a table (24 columns x 700,000 rows) from JD Edwards (running on AS400) into SQL Server (new table and no manipulation involved)? Many thanks, Steve ...more >>

I have a problem with executing following T-SQL select query. My select statement looks like this SELECT * FROM (@TableName_FirstPart + @TableName_secondPart) **@TableName_FirstPart & @TableName_SecondPart are Local variables** Im getting Incorrect syntax error for this statement. Fo...more >>

Hi All, I have a stored procedure. I need to create a scheduled job using that stored procedure. I went to Enterprise Manager -->Management--> Jobs-->New Job Properties In the step tab, I can select db and put the codes. Instead of writing the code there, I want to call the stored ...more >>

We are having some troubles with corrupt indexes on our SQL 2000 dbase. It is only affecting 2 tables out of about 150 we have. These 2 tables are heavily used. We have run dbcc repairs; dropped and recreated indexes but the problem persists Is it possible that this ongoing problem is ...more >>

SQL Server Enterprise Manager could not start the service 'MSDTC' on server 'NTAS21'. 1722 - (The RPC server is unavailable) I Setup A publication on a server called NTAS4D, then Pushed The Subscription to another server called NTAS21. If I configure so that the changes at the subscriber ar...more >>

Hello All, Is there a way to run sql select statements with column numbers in place of column names in SQLServer. Current SQL ==> select AddressId,Name,City from Address Is this possible ==> select 1,2,5 from Address Thanks in Advance, -Sandeep...more >>

Access 97 SR 2 Front End SQL Server 7.00.1063 Back End When I attempt to relink the tables in my Access app. I am suddenly getting this weird error message = "ODBC--Call Failed", followed by "[Microsoft][ODBC SQL Server Driver]Restricted Data Type Attribute Violation(#0)". This problem did n...more >>

Hi all, I'm looking for some ball park estimates on when SQL Server might start to break down, and can't find any reliable info. Any insight is appreciated. Basically, the situation is this: The database structure is very simple; just one table with about 15 columns and about 60-75 mil...more >>

Dear sir I have one SQL Server database. In this database more than 20 tables exists that their structures is same. I have two way for design this tables: 1.Create all tables separately(create more than 20 tables) 2.Create one table and separate each group by type(add column type to table ...more >>

I need to loop through a set of records to build a string. I can do this without using a cursor by inserting the records into a temporary table with an identity column. Count the number of records in the temporary table and loop though the table selecting the values and building the string whe...more >>

I am in need of some advice. I need to build a SQL machine that will be adequate for my company. Budget is a very big factor but I need the machine to be reliable and as redundant as possible. This box will be 'vanilla' since I will be building it myself. I looked at some larger companies webs...more >>

Hello there, Im trying to change the owership of the DTS package but am a little confused. sp_changeobjectowner changes the ownership of table, view, or stored procedure in the current database... How could i change the DTS package ownership? Thank you in advance. Leo *** Sen...more >>