What is the equivelant to Autonumber coming from an Access World to SQL? TIA Michael...more >>

Can someone tell me the Transact-SQl equivalent of any of these: IF INSERTING .... IF DELETING .... IF UPDATING .... TIA Allan M. Hart ...more >>

Hi, Does BCP Select work in MS SQL Server 7.0, because when I run this command : bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c -SWIN2K -Usa I always get this error : output ...more >>

Hi, I need little help with Ms SQL Server 2000. I would like to know how to create sequence or something like that. I want to have an automatic counter for each row in one entity, so then I can do something like this: INSERT INTO table VALUES (use sequence(something), value, value, .... ) ...more >>

I am connecting through EM to another SQL server for my web site, is there a way to limit it so that I only see my database and not all the 100's of others that are listed. Also, sorry if this sounds dumb but I applied the sp3 sevice pack and I dont know how to verify this, normallly ...more >>

Hi All! We are doing new development for SQL Server 2000 and also moving from SQL 7.0 to SQL Server 2000. What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? Please, share your experience in using IDENTITY as PK . Does SCOPE_IDENTITY makes life easier in SQL 2...more >>

Hi, just a quick question regarding performance and speed. Q. Run a complicated query three times or create a TEMPORARY table and access it as needed? I have a page where it will be accessed 10,000+ a day. In that page I have an SQL query where it involves 3 different tables (...more >>

Hi All! General statement: FK should not be nullabe to avoid orphans in DB. Real life: Business rule says that not every record will have a parent. It is implemented as a child record has FK that is null. It works, and it is simpler. The design that satisfy business rule and FK not n...more >>

Hi, I have a requirement to update a table in SQL Server through a stored procedure, the stored procedure should run periodically, say once in a month, and update the table.I should not use any external programs to call the stored procedure, is there any other way to do it without using an ext...more >>

I have a user assigned multiple roles and a role can be inherited from multiple parents (see below). How do I answer such questions as "How many roles does the user belongs to?" I answered the above questions by using .NET but I think it can be more efficient by using just SQL. I would appre...more >>

Hi All I was wondering if there was a way inside a sql stored procedure to step through the rows of a table using a loop so i can take a value from each row one by one until i reach the end of the table ? I am used to doing this in vb by referencing the row numbers one by one in a loop but am ...more >>

Hi.. I'd very much appreciate it if someone would tell me how to translate a statement level trigger written in Oracle to its equivalent (if there is one) in MS SQL Server. Ditto for a row level trigger. If this is an old topic, I apologize. I'm very much a newbie to SQL Server. Regard...more >>

I have read that there is a free version of Ms-Sql Server for educational purposes. Is it true? thank you. ...more >>

When I perform a query on a linked Oracle server in the Query analyser I have no prboblem' to perform this query. However, when I create this query in a stored procedure I get a compilation error when saving this procedure. (Not when compiling; it has no errors) Server: Msg 7405, Level 16, S...more >>

I dont want to see these at all and cannot find where to specify a view or modification of a view. can someone throw me a bone here and tell me where to make the adjustments if I can make them at all Michael...more >>

What is the best way to import or transfer a Access database to sql2000, I tried that wizard and for the life of me I cannot get it to work correctly. TIA Michael Please answer in the newsgroups so that others may see thie information also. ...more >>

Hi, For working with linked servers , Mr. Hills had replied like , one can not see the login rights etc if the particular user is not in the admin role in the Enter prise manager. Since the E.Manager is a open book so that any one can access any database , Do you explain me When the s...more >>

Is there a way to create a trigger directly on an inline or multi-line table value function? I am trying to create a quick-and-dirty application using an Access Data Project front-end with SQL 2000 SP3 EE. Thanks. ...more >>

I put a clustered index on a table with 2 columns -nationalityid int autoincrement PK -nationality varchar(50) the clustered index is on nationality however; when i do a select i still get a record set back ordered by the nationality id...what am I doing wrong? -Jim...more >>

Hi all, I need to change a varchar from 35 to 50. In the SQL Server books on line it says that SQL Server actually creates a new table when you change the length. I ran a test in a test database and it appears the only thing that changes is the length. All the data remains in tact. The table...more >>

Greetings, Under which Registry key can I find SQL Server Name? MTIA, Grawsha...more >>

Hello there, This is somewhat of a newbie SQL question. What are the minimun databases SQL needs to operate correctly. I have inherited a SQL db and am not a DBA. The db's that exist are: Master, Model, MSDB, TempDB, Pubs, Northwind along with the databases I've created. It seems to m...more >>

Hi, I have a Excel sheet that have a column with mixed data: column can contain data like "892-234-32A" or like "892298343233432" I need to get all data column such as "text" to avoid numeric field show as exponential number. I'm trying with: SELECT CAST (CODICE as bigint(25)) FROM OPENRO...more >>

I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms and query to convert too. Can someday provide me with at least one tool name ? Thanks, Guy...more >>

I need to update a table by copying a column from another table (having the same structure, but on another database), from the record having the same primary key. 1 - What is the correct query? 2 - I tried copying them record by record, but the datatype is ntext, (it displays <long te...more >>

Hi, I have write a stored procedure which makes update in a numeric (int) field. Depending on data in other table, in some case the result of query get a Null value instead a zero value... How can I tell to Update query to NOT update field if the value is Null ? I hope my word clear... ...more >>

Hi ng, I need some input/suggestions for a very small layout. The situation: Some groupings of thumbnails. For every picture (thumbnail) there is a "big" picture. Thats it basically :) On the front the scenario is this: A user clicks "Autumn". The user is presented with the "Autumn" thum...more >>

Hey I need to store something a little different in a DB and I was hoping one of you guys might be able to help me. Basically it represents a 'world'. I have an initial state and then I get info like this... 27/11/03 17:21 Mary is born 27/11/03 17:21 Dave is born 27/11/03 17:22 Sean is ...more >>

I was wondering if anyone could suggest a web-based help desk system that uses MS SQL server that also has a knowledge base and also allows support employees to log how much time they have spent on each particular ticket. I'm after an 'affordable' system that would be used by about 35 people. ...more >>

Hi All! I like employee and department scenario from DBDesgin Q. It looks more intuitive than my previous sample. *********************************************************************** Business rule: Each employee works only in one department. Department is managed by only one of emplo...more >>

we have ODBC drivers to connect to SQL Server from a unix box. I looked at cspan.org for Perl DBD/DBI with sql server and I don't see one. Is there a place from where I can download perl DBD/DBI for SQLServer. Thanks. ...more >>

I have an application written in VB.NET that connects directly to a SQL Server 2000 database over the internet. It works fine on the development machine (XP Pro), as well as two outside machines running XP Pro. It does NOT work on two other outside machines, both running Win2000. All 4 outsid...more >>

Hi I am looking to implement an audit/history table/tables but am looking at doing this without the use of triggers. The reason for doing this is that the application is highly transactional and speed in critical areas is important. I am worried that triggers would slow things down. I am...more >>

I have a basic question regarding rights. What level of rights do I have to have to grant another user update rights? I don't want to give everyone owner rights. Can a person with update rights grant another person update rights? Thanks....more >>

What is the result of adding an or into a left outer join? For example: Select l.list_id, l.request_id From List l left outer join Request r on l.request_id = r.request_id or l.list_id = r.list_id Thanks :)...more >>

Suppose the following tables: parent ------ parentid address phone . . <many fields> . . child ----- childid parentid name I want to select every column from the parent table and the count of the child rows grouping...more >>

Hi everyone, I'm a bit new til ms sql server and hope that anyone here can answer a question I have. I'm running a ms sql server 7.0. The server is accessed by a application written in Access (help..) and sometimes I experience that the server performance is slowing down. When I do a sp_who I...more >>

Hi, I've written a M.plan in my client place which is scheduled to occur weekly once.But 4 days gone from the last backup taken , there is a problem in the server which does not start loading windows .The only way is entering via SAFE-MODE.In the safe mode the E.Manage does not connected(is...more >>

I am trying to understand how the data in sql server is stored and also regarding fill factor and page splitting. 1) My first question what is the difference between Index pages and Data pages. and how are they different for clustered and non clustered indexes and heap tables. 2) What is t...more >>

Here's a weird one. I'm running SQL Server 7 and when I run a backup something weird happens. When I perform the backup via Enterprise Manager by right clicking on the database I want to backup, I click on OK but no progress blocks show up in the window showing you the status of the backup. ...more >>

Hello, I am interested in dynamically creating temp tables using a variable in MS SQL Server 2000. For example: DECLARE @l_personsUID int select @l_personsUID = 9842 create table ##Test1table /*then the @l_personsUID */ ( resultset1 int ) The key to the problem is that ...more >>

I am writing a download process in which i have a condition where i need to join four tables. Each table have lot of data say around 300000 recs. my question is when i am doing the joins on the columns is there any specific order i need to follow. for example My original query l...more >>

Hello! We have a set of individual .SQL scripts which we would like to execute against a MS SQL Server 2000. Is there any way to have ISQL utility (or any other means) to execute all of them without having to establish a separate database connection for each script: isql -Ux -Py -Ss -i scri...more >>

Hi, I am still not very proficient in SQLServer. So apology if the question sounds basic. We have a script to clean old unwanted data. It basically deletes all rows which are more than 2 weeks old. It deletes data from 33 tables and the number of rows in each table runs into few millions. ...more >>

How can I get the date of the first day of the month of 3 months ago in one statement ? (And with no time in it ??) Arno de Jong, The Netherlands. ...more >>

Whats the format to send to a datetime field to distinguish it as B.C. vs A.D. -Jim...more >>

Hi, Received the following error during index creation of the tables. The data & log files are set to 'unrestricted growth' and enough space available on the disk. Any reasons? ___________ Microsoft OLE DB Provider for SQL Server (80040e14): Could not allocate new page for database 'Ultima...more >>

I have a table, TEST_TABLE, with 6 columns (COL1, COL2, COL3, COL4, COL5, COL6).... I need to be able to select all columns/rows where COL3, COL4, and COL5 are unique.... I have tried using DISTINCT and GROUP BY, but both will only allow me to access columns COL3, COL4, and COL5..... i need ac...more >>

Hi! I need to write a script that will remove any constraints and triggers from any table in a specified database. My problem is that i don't know where are stored in the system tables the constraints and relations... I've been told that once this would be found, i would just have to use cur...more >>

Hello - I have three feeds from sources around the world, each coming in at a separate time. These feeds move into a large table (3GB) that is queried by managers. The feeds are loaded sequentially, and then the previous day's feed rows are deleted from the table (this is done so that the us...more >>