Am I with a doubt... as I should define the clause where and from of my select so that her (the query) is it more optimized?! In the from I am accustomed to place the first larger tables (from top to bottom) and in the where I always place the most restrictive termses in the end. Of the left f...more >>

I create an "application user account" for my application to connects to a database. Security settings are controlled by right settings of this application user account. No other user (except my application) will use this account. I don't see any need to create an application role. Can anybody t...more >>

A question about performance... I am on a project where our DA would like to create views for the tables in one DB and have them reside in another. The views are just of the "select *" nature. The reason for this is so that we would only need to access one database. I am interested in th...more >>

I was wondering how to use a Table Name in a variable ? I would like to do something such as - SELECT xxx,yyyy FROM (Tablename Variable ) WHERE (conditions) I have tried to set the table name as @TableName and do the above as - SELECT xxx,yyyy FROM (@Tablename ) WHERE (conditions) an...more >>

Hi, I'm quite confused on how to deal with this. For instance, I have this two tables namely: IdMaster & IdCategory. Each record in IdMaster has a corresponding IdCategory but the problem is, there's a possibility that the a record in IdMaster has multiple categories. Supposing I have this da...more >>

I would like to create a view of a table which is of different database resides in different server. This can be done through link server. How do I create the index for the View ...more >>

Hi, I have created a store procedure ( my second ever) which returns values when I know the Outbase ID, however I want it to return "all records" but when I pass % it fails on data type. Is there a way of doing this? thankss Jonathan CREATE PROCEDURE USP_Get_Order_For_PreviewOB @Delive...more >>

Is it possible to use LIKE with a CASE statement? What's the syntax? Thanks! ...more >>

I am running SQL Server 7.0 and have a database table with a field named "ReportTime". After a year's worth of data has been imported into the table, management wants to change this field name to something more appropriate like "TransactionTime". Can I edit the table and change the field name wi...more >>

Hello all, i need help desperately. I am a beginner at sql server but we just upsized the access database to sql and i am trying to convert a nvarchar column that has dates data (ex: 1/1/2003) and i need to convert it into a datetime column. I tried to update another field that has datetime d...more >>

Hi, How to format a currency field like this : 16000.00 -> $ 16,000. Thanks. ...more >>

Hi When I try to run following update I am getting following error in error log file and it's creating dump also. We are using sql 2000 + sp3a +818 hotfix. Any idea. SQL Server Assertion: File: <recbase.cpp>, line=1374 Failed Assertion = 'm_nVars > 0'. Update xContact Set InquiryY...more >>

My application provides a dialog box for users to enter login names and passwords and use the information to connect to the SQL server in code. If a user enters a wrong password, a dialog box of SQL server will come up for re-entering the info. I want to display my own form for the user to re-ent...more >>

I have a simple table with two columns (user,date). The user column may have multiple entries for the same user. How can I return a distinct list of users with the most recent date? Thanks for any help you can give me. If replying, please remove NOSPAM111. from email address. Example: ...more >>

I have a question about a schema design that I am working on and am looking for some advice from the 'pros'. http://www.shastacoe.org/schema.gif I have a table tblTransport which represents a physical network transport for an application I am writing. My goal is to maintain the physical ...more >>

I need some advice... We drop ship for our dealers. We have a website where they can manually data entry their orders - no problem. Some of the larger dealers prefer to not re-enter data. It's manual labor and understandable. My only solution at the moment is giving each dealer their own table...more >>

Is there a system table (or view, etc.) that I can query in my trigger to detect if the trigger on behalf of a transaction? Please let me know - thanks! ...more >>

Does anyone know of an easy way of an SQL script either being passed a variable or for it to ask for input from the user. For example I have a delete query that deletes on a particular user which I want to be inputted by the user ? Any ideas how I can pass this in to the osql engine or that th...more >>

Hi, Is there a way to find field names in Database beginning with square bracket like [City Name]? Thanks a lot, Vad ...more >>

Haw ? Thanks Grega ...more >>

Hi, I have stored procedure (MS SQL Server 2000) which operates on around 600 000 rows (SELECT, UPDATE, INSERT) and executes in 5 minutes, when I put it in SQL transaction it slows down to more than 5 hours (!!) I have to admit that it is not problem with data locks (beside that procedur...more >>

Hi, I've run into a curious problem with MS SQL Server 8.0. Using sp_help and SQL Query Analyzer's object browser to view the columns returned by a view, I find that sp_help is reporting stale information. In a recent schema change, for example, someone lengthened a varchar column from 15 t...more >>

Hi all, I'm kind of new to Unicode and internationalization in general and I have, what I hope is, a fairly easy question. Scenario: I have an ASP app running on IIS 4/NT Server 4 (sp6) that communicates with a SQL Server 2000 database running on the same server. On one of the web pages th...more >>

Hi, Is there a way(command or procedure) to take a backup of a table into excel or text file from the stored procedure(which usually runs nightly and also executed manually). The excel file name should be dynamically generated (like Nov_4_2003_8PM or any format as long as it is diffe...more >>

Hi, Is there a way of resetting all identity columns for all user tables in a database? Any help would be much appreciated. Mat. ...more >>

Hello, Someone can give tips for working in MS SQL Server 7 with tables aprox 12 Millions of records ??? I am losing performance when apply SELECT... I have indexes over several columns, but it seem dont have effect in my huge table. I am using records by year for each table. Usin...more >>

I am doing an insert from another table and am inserting a date which shows as 103003(varchar) How do I turn it into a date field and show it in the new table as 10/30/03? I know the time will show up as 00:00:00...and that's fine. Thanks!!...more >>

I have a money column in one of my tables and I want to store there different values of different currencies. First, is it possible to keep track of the currency? Second, if yes, how can i get the currency symbol? Thirds, if not, what is the best solution in this case? Thanx, Albert ...more >>

Hi, There is a table consist of 3 integer columns, I want to add a Check Constraint to them all. Which one is better? ex) create table x ( col1 int, col2 int, col3 int) 1) Alter table x With Check Add Constraint CH_x_cols Check ( col1 >= 0 and col2 >= 0 and col3 and >=0) 2) Alt...more >>

Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to he...more >>

Hi, all: I'm a newbie trying to understand the concept of referential integrity and dealing with Primary/Foreign keys. I'm sure mine is a simple problem... I've created 3 tables as follows: MemberTable ----- 1 Member ID (Primary key) 2 Member Name 3 etc... FoodsTable ...more >>

In query anlayzer, a blank record actually displays "NULL" and is exported as such. I would like to have it remain a blank field. Is there a way to get rid of the NULL? Thanks, *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded ...more >>

I am trying to figure out how to store a date only field in SQL. Everything I look up in the documentation says it can only store as "datetime" and if there is no time, a 00:00:00 is filled in. However, I want to drop the time off of the data I am importing and store only the date portion. I...more >>

Hi everyone, we've been having some serious problems with seemingly random timeouts occurring in our web-based VB 6 application. We've been dealing with this problem for a year now and are stumped. This is a medium-volume financial trading application which can have anywhere from 5-200 concurrent...more >>

Hello I want my program to connect to a SQL server as fast as possible. The architecture I am considering using is as follows: 1. Client program written in C++ using ATL/WTL class libraries. ATL has a atldbcli.h file which I include for OLE DB support. I have previously used this agains...more >>

Hi All, I need to know how I could check the real existence of a programmatically formed filename from where I´m supposed to load data as described in the example below: declare @filename varchar(30) ,@exec_sql varchar(500) SET @exec_sql = 'BULK INSERT pubs.dbo.publishers2 FROM '+ @file...more >>

I am wondering why VS.Net wont allow me to debug a SP when I have a TEXT Datatype as an OUTPUT parameter. The procedure executes fine in QA but the output isnt displayed. Am I not doing something correct ? -- Posted via http://dbforums.com...more >>

Does anyone have an example of looping in DTS? What I am trying to do is have a sql command fire every 10 seconds or so, but 1 minute is the lowest value I can get with DTS Schedule ... so I thought I could drop a loop in as the last step to start over ... but no good. ...more >>

I have a couple tables that utilize concatenated primary keys. When I create a Foreign Key Constraint on a child table that references one of the columns in the concatenated PK I get an error. It tells me that the referencing column doesn't match any of the columns being referenced in th...more >>

Hi can u please give syntax to put default constraint with value 0 on one of the existing table .. Regards Ajay ...more >>

Hi, I need to restrict a colum to have unique values - easy I can add a unique key. But... The colum also needs to one or many rows to have a 0 in the colum too - e.g for products we don't have the information for and here is where a unique constrains would fall down. How can I ensure...more >>

Can I implement array binding with SQL2K ? ...more >>

I'm trying to alter a table and am getting an error on line 1. I don't get it because I am creating this by right clicking on the table in QA and creating the script with one slight modification towards the end of the script. help? -------------- Server: Msg 170, Level 15, State 1, Line...more >>

create table test ( id int, name varchar(5) ) insert into test values (1, 'a') insert into test values (2, 'b') insert into test values (5, 'c') insert into test values (7, 'x') insert into test values (9, 't') insert into test values (4, 'c') insert into test values (12, 'x') insert...more >>

I need to identify a row in a table with a multi-field primary key using a single identifier. Thanks ...more >>

I know we can see the text of system procs e.g. sp_helptext sp_helptext does anybody know how to lookin the test of a system function. e.g. sp_helptext stats_date Thanks. ...more >>

Hi Guys, Can some one give me an Idea or T-SQL script that determine the date of 1st sunday of April and last sunday of October. Basically I need to find the dates of daylight savings dates in any year. Thanks in advance Ravi...more >>

Being the SQL Server newbie, I accidentally encrypted my views. I read I can use a stored procedure with Alter View to unencrypt them, but how? Can anyone help? lq...more >>

All, I receive the following error when I run the following query: UPDATE dbo.tblSaleCards SET ReferringPhoneBankID = 'Not Entered' WHERE ReferringPhoneBankID IS NULL Server: Msg 511, Level 16, State 1, Line 1 Cannot create a row of size 8070 which is greater than the allowable maxim...more >>

Hi all, I want to migrate data from old tables to new tables (the new table has additional Columns). This is what I am thinking... --Export Old Data to CSV --Read the CSV into new temp tables. --Apply logic and insert data accordingly with new Rules (wrap that into procedures) Problems: --H...more >>

I am new to SQL and wants to write a select query. Table : ID Name Language --------------------- 1 Mike English 2 Tom German 3 Tom English 4 Mike Spanish How to get the persons who speak English AND German. result : TOM If someone can help that will be...more >>

Hello, I am working on a stored procedure containing a case statement, and am having trouble using a less than or equal to operator within the case statement. Below is an excerpt from the sproc: @txtNextStep as varchar(4) AND daysToView Like Case When @txtNextSt...more >>

I have a query like: select * from view where colomn like 'something' The view is actually a fair complicated join of multiple tables. In 7, it will pass the search argument into the view first and join, and only takes 3 seonds. In 2000, it will create a view joined with all data, then ...more >>

Please see my query below SELECT order_detail_org.order_prep_logon, master_receiving.order_num, master_receiving.order_line_num, SUM (master_receiving.item_recieved) AS item_recieved, master_receiving.update_by, master_receiving.Received_on, order_detail_org.o...more >>

Whilst building a calender for a business application I have found what appears to be a bug with the DATEPART function. Here is my implementation: select DATEPART(ww,'31/12/2012') The result is 54 NOT 1 as expected. Does anyone have any related experience or if there is a workround fo...more >>

Hello, Someone knows whats the way to know how many process are runnning right now in my MS SQL Server 7, getting all detail??? Any help is greatly appreciated. ...more >>

The ceiling function in SQL differs from the ceiling function in MS Excel. I want a SQL UDF function that works like the Excel's ceiling function. Any ideas? Thanks in advance ...more >>

Is there any way I can get Mon - Fri days into one week with col heading of 10/27 - 10/31 11/03 - 11/07, I don't want to hard code anything. select dt,role as type from t1_vw where dt between '10/27/2003' and '11/07/2003' I want date in horizonal by full week output looks like this...more >>

I tried to change the column default value from 1 to 0. Here is the syntax: alter table table1 drop column active alter table table1 add active nvarchar(1) default 0 with values update table1 set active = 1 However I got the following error message. Server: Msg 5074, Level 16, State 1, L...more >>

hello i have a doubt the storage of clustered indexes according to what i have understood in case of a heap when we have a non-clustered index, the leaf nodes have the row id in which the particular row is available in case of a heap when we have a clustered index in which the leaf node...more >>

Hi, I am about to undertake some datawarehouisng work for our company. I have got some stuff off the web on what datawarehousing is. It is mainly theoretical stuff. I have worked with SQL Server 2000 for a few years now but have never done any datawarehousing. Does anyone know a de...more >>

hi, I am trying to save the SQL Query Analyzer results to a .rpt file. and i open it in a XL sheet. every thing is ok, but when the numbers like ex: ClientNo 0069007 after saving it to rpt file and if i open in XL sheet , the the two zeroes of the ClientNo are being supressed. i.e. ...more >>