My English is pool. I want to learn ACCESS step by step. I found that ACCESS has 4 samples,but I can¡¯t find the Chinese lesson for the 4 samples. Who can help me? Thank you! ...more >>

In sql 2005 if I have a query along the lines of: select * from myTable for xml auto, elements xsinil, root('myRoot') I will get back one row, one column, filled with a nice xml string. The problem I'm having is figuring out how to access that data, such that I can put it into a local va...more >>

Is there any way by which deadlocks can be detacted and then appropriate action can be taken (in vb.net code or sql) to avoid it. instead of throwing error we can revoke the sp call.. thanks ...more >>

I have need to produce a report (excel sheet actually) from SQL that would run each Tuesday and each Friday of every week. What needs to be on the Tuesday report is everything that came in from the Friday midnight time, until the Monday midnight time. The friday report(sheet) would have ev...more >>

I need to block some rows from being updated using mssql 2000. this is because some users are changing data after the product has been factured. The VB program does not let any body to change the data but some advanced users have done it directly to the database. If some one can help me I w...more >>

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine to get a fresh machine. The hardware is Pentium 4, 3 ghz with 512 mb RAM. There are no other heavy applications running on the machine. I check sqlservr.exe's memory usage in Task manager. It is ca 20 mb, every...more >>

Hello there I have some store procedure that return query as result. Is there a way to store the result in table? ...more >>

Hello, I was wondering how I can do this the best way. Source table: CREATE TABLE [dbo].[MaterialInventory] ( [MaterialInventoryID] [int] IDENTITY (1, 1) NOT NULL , [Serial] [nvarchar] (15) , [BuyPrice] [float] NULL , [BuyValue] [float] NULL , [BuyDate] [datetime] NULL , [DateOu...more >>

Hi, Is it possible to use inserted or deleted tables in a dynamic query in a trigger? Thanks. ...more >>

In my table i need to use Full Text Search on text column here is my table ================================== CREATE TABLE [AH_SubMaster] ( [Master_ID] [int] NOT NULL , [Fakra_No] [smallint] NOT NULL , [Fakra_Text] [text] COLLATE Arabic_BIN NOT NULL , [Index_ID] [int] NULL , [UserID] [i...more >>

I know there's a way to query the schema, but don't recall exactly. Does anyone know how to query the database to determine the field type, length, precision, scale, etc? ...more >>

If a business scenario related to data gathering for statistical analysis merits large complex triggers. Thes triggers pre-populate tables with data based on gathered business rules and make use of nested stored procedures and cursors. What is then good practice? Are cursors to be kept small ...more >>

I am trying to Ad-hoc query from a user input(internal app), where the user enters in a name just as "Al's Game Crazy". Each time I do this, the Apostrophe gets in the way. I have tried using the "char(39)" setup for with the like statement. But I keep getting and error. Error returned:...more >>

Hi Everyone, I have several tables in a current DB app I'm working on that contain over 120 fields. I'm looking for suggestions to cut down the number of fields that I need. I know that most fields will not be affected by my redesign, but I currently have several fields that could have mulitp...more >>

Hi, i have 2 tables: table 1 - called Feed. contains the following fields: productName PartNumber ManufacturerName PartNumberManufacturerName (this field concatenates the part number field and the manufacturer name field). Table 2 - called Products. contains the following fields: produ...more >>

Hi, I got most of this code from somewhere else on the net to compare two tables ...iam just trying to customize it to my requirement. Here I want to compare table1(new),table2(old) to find out whats the new values added or deleted in "name" column of Table1 when compared to table2. -- ...more >>

I need a grouping and I'm not quite sure how to group it...an example of my current query and the returned data is below. After that is more detail about how I need to group it. Thank you! SELECT ct1.Description AS Exemption, ISNULL( ej.TotalPeople,0) AS NumPeople, ct1.Code AS Code, Web =...more >>

I have can query a comma delimited file in query analyzer easily. Content of mytest1.csv file on txtsrv21 linked server is as follows /* c1,c2,c3 11,12,13 22,33,44 55,66,77 88,33,12 */ When I run the following select: SELECT c1,c2,c3 FROM txtsrv21...[mytest1#csv] I get the following res...more >>

This is only the second stored procedure that I've written, and I'm having some issues with a conditional statement that I can't figure out. The statement has a conditional If statement with two Else If's that checks for a passed parameter's value (an integer I pass when executing the SP via AS...more >>

Is there a way to remove the database name and ".dbo" from the object name in the execution plan? I almost never do a cross database join, and all tables are owned by dbo. Since there is limited room, I'd much rather see the full table name and index being used. Also, does anyone know why the ...more >>

Hello. I have some SQL statements that are working but I think there has to be a more efficient way to accomplish what I'm trying to do. I have two different columns in a table (SuperMatch) that need to find a corresponding value from another table (ProviderSpecialty), using the values f...more >>

I know sp_databases can list all the databases, but how can i only list non-system databases? I just want to get a list of user databases ...more >>

Hello, I'm trying to do something like this: CREATE PROCEDURE my_proc( @id uniqueidentifier, @string varchar(100)) AS EXEC('SELECT something FROM somewhere WHERE table.id =' +@id) I need to have it in a string because I'm using variables for "something" and "somewhere". It doesn't se...more >>

after my table has been created and populated with data? I have an identity column (named 'CID') on my customers table. This value is often used in my queries and I'd like to take advantage of a clustered index (since none currently exist on the table). Will making this column a primar...more >>

Hi, I got a stored procedure which interacts with the pubs database. The following is the code for the stored procedure: CREATE PROCEDURE usp_UpdatedPrices_para @Type char(12)= '%', @Percent Money AS UPDATE titles SET Price = Price * (1 + @percent/100) WHERE Type = @Type Now, if I execu...more >>

Hi SQL 2K ..NET1.1 I use an oledb command.ExecuteNonQuery() to run the following sql statement: "ALTER TABLE Test ALTER COLUMN col2 varchar(20) NOT NULL" BOL states that ExecuteNonQuery will return the number of rows affected when issuing an UPDATE, INSERT, and DELETE statements. IT wi...more >>

Hello, We are facing the following problem: We have installed SQL 6.5 server Enterprise edition on Windows 2000 Advanced server. On this system, in the regional settings, the Locale is Japanese and in Office 2003 Language settings also, we have added Japanese. We have another system with...more >>

Hi, I have 3 tables as follows (simplified for posting here): Table1 ---------------------------- CREATE TABLE [dbo].[Customer] ( [CustomerID] [int] IDENTITY (1, 1) NOT NULL , [CustomerName] [varchar] (50) NOT NULL ) ON [PRIMARY] Table2 ---------------------------- ...more >>

Hello, is it possible to deploy CLR-code developed with a 32 bit VS.NET on a 32 bit machine to a 64 bit SQLServer? Thanks Tobias ...more >>