I want to use some stroed procedures I've created in multiple databases, within the same SQL server instance. Is there anyway I can reference the one copy of the stored procedures, rather than copying them to each database?...more >>

Is there a way to set up a stored procedure to read from an ODBC access database directly into a new table in Sql Server 2000? Something like: **************************************** Select field1, field2 into new_table from old_table where something **************************************...more >>

Hey Do extended properties make accessing objects slower or anything Like, when a table with 30 columns has 10 ext. properties and each column in that table has it's own 5 ext. properties, will accessing the same table without any ext. properties be any faster? Thanks Martin ...more >>

Hi, I am concatinating several string together to create one string (string1 + string2 +string 3....) The problem is that if one of the stringX values is a null, then the entire string returns as a null. Is there a way around this Thanks ...more >>

Hi there, My database was installted and set up to a default collation of Hebrew (1255). Which sql_latin is the default collation (there are several), and how can I make existing databases to use this new collation? Thank you kindly, G. ...more >>

Joe, I've seen you mention this standard on many occasions and would like to = read up on the topic. However, I checked the ISO.org website, and found = the 7 publications they had cost US$450. I didn't find any primers on = the standard at Amazon either. Is there a concise summary of what'...more >>

Hi, Easy I am sure but I am learning.. I have a basic store proc that I want to append an and clause to based on a value. My code is currently something like this select field1, field2 from table where status=1 and validacc =1 if a<b begin and largeaccount=1 end This...more >>

Hi there, 1) Is there an option on mssql2k to make SET NOTCOUNT default to ON? on every call and every connection to that database? 2) Will a @@ROWCOUNT after UPDATE show rows affected when NOCOUNT is set to ON ? Thanks! ...more >>

Hi We are moving our database from a SQL 2K installation on W2K to a SQL 2K on Windows 2003 machine. We have a problem with some of the queries where the collation is not matched. We are using rebuildm.exe to try and change the collation but cannot seem to find an available collation that ...more >>

Hi, I'm having some trouble using cursors with dynamic SQL. It seems like if I try to fetch results from c_notInCart, nothing is there. Can anyone tell me what I might have missed? Is the cursor being declared within the scope of the EXEC statement so the results are not available? If so, how ...more >>

I have posted a number of posts, got replies, have gone through some other posts too and I still can't solve the problem.... Thanks to all who have replied to my posts and at the same time my apologies if they feel that their effort was not worth it. The problem is with my thick skull and an...more >>

Hi all, I tried to incorporate following trigger on one table on my database (I use EM) CREATE TRIGGER t_journal ON [dbo].[T011] FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON IF EXISTS (SELECT item_pk FROM inserted) INSERT INTO T032 (item_pk, nQty) SELECT item_pk, nQty FROM inser...more >>

I am very new to C++ programming and don't know why this does not work. It compiles but when it's run, I get an error.... CPINFOEX * cpinfoex; GetCPInfoEx(CP_ACP,0,cpinfoex); MessageBox(cpinfoex->CodePageName); Here is the error I got. ----------- --------------------------- ...more >>

I am trying to truncate Table B to Table A. One of the fields of Table B is numeric and this needs to transfer to a field in Table A that is a VARCHAR. How do I do the example below. Table B field Numeric say "9" to Table A VARCHAR required "009" Table B Field -> Table A Field 9 ...more >>

hi all can any one help me how to represent tree strcuture in relational database in form of table(s) advanced thank with regards...more >>