In MS SQL Server, I have the following tables with some data in it. create table table1 ( column1 varchar(32), column2 int not null, column10 varchar(255), ..... primary key (column1, column2), ); create table table2 ( column1 varchar(32), column2 int not null, column...more >>

Hi, How to find the list of SQL math functions in SQL Server 2005? Thanks Kai ...more >>

Below is the contents of a SPROC I have. I want to return the error info in the catch block for it so I call RaiseError. But the ERROR_STATE() always comes up as 0 which is ilegal since it must be between 1-127 I guess. So I wrote a stupid if block to set it to 1 to stop that error. But I'd r...more >>

Hello, perhaps you guys have heard this before in the past, but here is what I'm looking for. I have a SQL 2000 table with Social security numbers. We need to create a Member ID using the Member's real SSN but since we are not allowed to use the exact SSN, we need to add 1 to each number in t...more >>

Hello, I have the following query in Access 2000 that I need to convert to SQL 2000: UPDATE tblShoes, tblBoxes SET tblShoes.Laces1 = Null WHERE (((tblShoes.ShoesID)=Int([tblBoxes].[ShoesID])) AND ((tblBoxes.Code8)="A" Or (tblBoxes.Code8)="B")) WITH OWNERACCESS OPTION; The ShoesID in the...more >>

Hi, I'm connecting to a SQL server (7.0) from Excel and VBA. I've checked the VBA and don't think I've got this wrong but I keep getting a Timeout Expired error message. Is there a setting in SQL that I am not aware of that I need to set? Could it be the connection string I use? The...more >>

SQL Server 2000 SP4 with AWE hotfix. Windows 2003 SP1. I have a stored procedure which is not working the way I think it should be. I have a CURSOR which has a variable in the WHERE clause: DECLARE get_tabs CURSOR local fast_forward FOR SELECT distinct tablename, id, shcontig1dt, sh...more >>

Hi. I have automatic statistic update turned on for all my databases. Is this an overhead I can do without? Could I update them overnight when the database is hardly in use? Thanks -- Chris Weston ...more >>

Hi all, I am quite experimented with SQL Server, but not that much with full text indexing. After some successful attempts with english fields, I've decided to try it with Japanese characters. I don't know why, but it seems to have a strange behaviour. As in this screenshot (http://img65.i...more >>

Hello, I have the following code to iterate through each view in a SQL Server and call the "sp_refreshview" command against it. It works great until it finds a view that is damaged, or otherwise cannot be refreshed. Then the whole routine stops working. Can someone please help me re-write t...more >>

What is the diffrence between Sql Server Login and Sql server Database User? I want to put a funtionality in my application from where administartor make Application User. these application user will be made also in sqlserver.. Now I am confuse here In sqlserver Login and User Well I will make...more >>

Hi, I'm running the following SQL to get values for 4 fields. It is unacceptably slow. I have no control over the structure of the database, field names, indexes etc. - what I'm given as far as DB design is all I'm going to get. If anyone could make any suggestions I'd really appreciate it! ...more >>

I have records ID Sku Name Date 2 41 Blair 01/04/03 3 45 John 03/04/03 that should look like... ID 2 3 Sku 41 45 Name Blair John ..... and so on. Number of source rows will be fixed (12) so no of target columns will be...more >>

I'm trying to work out a database design to make it quicker for my client program to read and display updates to the data set. Currently it reads in the entire data set again after each change, which was acceptable when the data set was small but now it's large enough to start causing noticable ...more >>

In SQL 2000 Query Analyzer, you can set up the text output pane to leave null values blank. That could give you this (assuming it's set to comma-delimited) -- CREATE TABLE #Test (A int, B int) INSERT #Test SELECT 1,2 INSERT #Test SELECT NULL,4 INSERT #Test SELECT 5,NULL INSERT #Test SELEC...more >>

Hello all, I have a table with thousands of rows and is in this format: id col1 col2 col3 col4 --- ------ ----- ------ ------ 1 nm 78 xyz pir 2 bn 45 abc dir I now want to get the data from this table in this format: fiel...more >>

according to the mysql manual, multiple inserts can be sped up by locking the table before doing them and unlocking the table afterwards. is the same true of multiple inserts in mysql? if so, how would the table be locked? any insights would be appreciated - thanks! ...more >>

Does any have a link, or know of an MS book(s) that details the underlying database structure, tables, processes? Something that explains in detail how/why this stuff is configured and works, like DDL, TDS, varchar, int, index, tables, normalization, DML, Primary Key/Foreign key. ...more >>

Did this as a exercise and am fed up with my fruitless searching. Went and create an CLR assembly and all with min hassel. Now that I have that dll out there, I am tring to find some system table or some display in management studio that shows me where the file is located on the hard drive an...more >>

I have one table with categories tblCategories cat_id | cat_name ----------------- 1 | cat 1 2 | cat 2 3 | cat 3 4 | cat 4 5 | cat 5 6 | cat 6 and one table with projects which relates to tblCategories tblProjects proj_id | pr...more >>

I want to join 2 tables by a unique ID field, but the ID field also has multiple NULLS which I do not want to ignore and I fear they will cause duplication. Using TableA and TableB below i will demonstrate the problem. TableA TableA.ID Field1 Field2 1 Paul 1 Null John 1 ...more >>