I want to return the first 100 results of a query that would otherwise return tens of thousands of results. To do this, I use SELECT TOP 100 ... I'd really like to be able to show the user how many results would have been returned had I not limited the query to 100 results. Is there a way t...more >>

Hi , I need to call Function in Select Qry and some of the field of that Qry is Input to Function like select Col1,col2, (select dbo.fn(Col1))Col3 from X Any help Please ? Kris...more >>

This may sound like an odd question, but when does GETDATE() assume its value, in particular during a long insert or update query? Assume I have a very large table and I want to update a DateTime column with a query such as: UPDATE TableName SET DateTimeColumnName = GETDATE() WHERE TypeI...more >>

Hi, I have 2 databases, DB1 & DB2. DB1 keeps all new changes for Store Process and Index on tables. Now I wanted to Drop Store Process/Index in DB2 from DB1 and create it into DB2 using SP in DB1. I can not find any way. Is there any way to do this in SQL? In sort I want to Drop existin...more >>

Hello, Can anyone explain me what is happening here ? we are getting frequent deadlocks when 15 Users simultanenously hitting application for 15 mins. any help is highligh appreciated 2006-02-04 14:34:07.67 spid4 ResType:LockOwner Stype:'OR' Mode: Range-Insert-Null SPID:86 ECID:0 Ec:(0x5...more >>

Is there any kind of automatic record counter in MS SQL 2005 that can be used to reference a record one is updating? Many thanks ...more >>

Hi all, I would be really grateful for your assistance with this. I need to set the default value od a date field to a specific date - in this instance the date would be 01/06/2006. Is there any code that will do this? Thanks in advance Gareth...more >>

Using the following syntax: Select fname, lastn From list Where fname like 'jones' I need the syntax that the user can enter a name to perform a query (the user will enter a name on a pop-up menu before the query is performed)....more >>

The folling query works but is it the most efficient way to write it from a performance aspect? The parameter can be set with the values (0,1 and %) these can be changed if needed for the final query version. The Detail.Automated database field is a datatype of bit Should I be writing this ...more >>

I am trying to get a resutlt for executing a statement in SQL Query Analyzer. How do I suppress '(1 row(s) affecte)' message from the result I get when executing a select statement. When I want to execute the following statement: select 'SET param ?param_LDIFRELA', count (*) from dif_XVR...more >>

Hello all. I have a question about Ranking Functions in SQL 2005, namely the ROW_NUMBER() function commenly used in CTEs. According to a Microsoft white paper I read, the ROW_NUMBER() function runs through the table and "Stores" the matching rows along with a position number. Can a...more >>

We get a daily file from a vendor that may or may not contain changes in one or many columns. Is there some kind of easy way to check for a difference between their feed and what we have on the table? Note, there is no "last update date" or GUID or timestamp value from their flat file. It's...more >>

I see different examples of query statements some with the table names preceeded by dbo.tablename and others with only the table name. Does the dbo do anything at all, especially if the user that request the query to execute is not the dbo simply a user with read only permissions? ...more >>

Hi, As a relative newbie to SQL Server/ASP.NET I'm hoping someone here can help with my problem. I'm developing a timesheet application in ASP.NET C# using Visual Studio 2003 with a database built in MSDE. One of my forms needs to return a simple list of resources from my database. I have fol...more >>

I'm doing some queries on a SQL Server 2000 database. (MFC C++ dialog-based application). I start up a transaction with: m_Session.StartTransaction(ISOLATIONLEVEL_SERIALIZABLE) I then do a query that determines whether or not a particular item is in a particular table. If it's already t...more >>

Does anyone know what happened to these people. Against my better judgement I bought a version of SQLDevpro in spite of it having the kind of copy protection that makes you go cap in hand to the developer for a new key everytime you sneeze. I hate this kind of protection. Now they have disapp...more >>

Hi, A while ago, I found an article on the web which demonstrated the ability to create stored procedures with nullable parameters and the COALESCE function. E.g. CREATE PROC TestSelect @CustomerID int = NULL AS SELECT * FROM Customers WHERE CustomerID = COALESCE(@CustomerID, Custo...more >>

In my tables there are fields for Make, Model, Type, Cc, Carburant, Etc... But for a unknown reason, maybe laziness, my users fill in all data in Model. How can i Group on the text before the first space i like to Group. Examples: Mondeo Gls Galaxy 2.0 C220 2.0 D C220 2.5 tdi Scenic ...more >>

Hello im trying to connect to a remote server over an internet vpn connection i asked admin of the remote location to open port 1433 in his firewall, he did and im able to register the server successfully by IP address on enterprise manager i can also make a connection with query analyzer w...more >>