Erik.Lennart.Jonsson's articles:

Items(4) /1

Indexed views availible in all versions of mssql 2012? 2 67 (6/18/2012 8:45:28 AM) comp.databases.ms-sqlserver I'm trying to determine in what versions of mssql-2012 indexed views are available, but so far I have not seen it mentioned anywhere. Oracle supports materialised views and and DB2 supports materialised que... Lennart

mysql conferences? 0 42 (12/1/2011 5:05:16 PM) comp.databases.mysql If you where to visit one mysql conference, which would it be? I've looked at: http://www.percona.com/live/mysql-conference-2012/ which looks good, any other suggestions? Why would you prefer one over the o... Lennart

question on clustered indexes in sql-server 8 20 (11/29/2011 3:39:57 PM) comp.databases.ms-sqlserver What is the purpose of a clustered index in sql-server (as you probably have guessed I have zero to none experience with sql-server)? The reason I ask is because I look at a databas where more or less all tab... Lennart

update trigger bug? 3 30 (10/22/2009 7:04:36 AM) comp.databases.mysql Since there are no check constraints I'm trying to enforce a number of rules via triggers. A simplified example: create table apa ( x int not null, y int not null, constraint pk_apa primary ke... Lennart

Erik.Lennart.Jonsson's replies:

Items(103) /11 Next >> Last >|

sql #2 41 80 (9/4/2012 8:39:33 PM) comp.databases.mysql i have created a table with the name of "customer loan" using wamp server.. but i couldn't access it using sql console ..what is the problem in it..plz someone help with me with it ... latha45 (9)

difference between two select statements. 17 44 (8/27/2012 5:18:46 PM) comp.databases.mysql I perform two selects on a database and get a difference of 1 record. SELECT COUNT(DISTINCT UID) from MyTable WHERE (c1 LIKE 'a%' or c1 LIKE 'b%') and c2='c'; SELECT COUNT(DISTINCT UID) FROM MyTable; T... bjobrien62 (510)

SQL Constraints Types 3 64 (6/18/2012 11:24:16 AM) comp.databases.mysql To restrict the violation of reregulation of data and to maintain data integrity on tables constraints are used. Constraints are a set of rules that are used for optimization purpose. When we create a new t... Alan_Smith.5ecrel (1)

Indexed views availible in all versions of mssql 2012? 2 67 (6/18/2012 8:45:28 AM) comp.databases.ms-sqlserver I'm trying to determine in what versions of mssql-2012 indexed views are available, but so far I have not seen it mentioned anywhere. Oracle supports materialised views and and DB2 supports materialised que... Erik.Lennart.Jonsson (181)

why is the result right aligned..... 10 65 (4/22/2012 7:26:46 AM) comp.databases.mysql I am creating a script (bash) on linux, and the result does not need to have column-names.. Why is the text column right aligned, if i do this: ~> mysql test -Ne "select * from test1 limit 2" +---+---+-------... luuk (814)

How to split X records from a single record (with date range) 6 48 (2/25/2012 12:34:07 AM) comp.databases.mysql Hi! I've an Activities table with these columns Description Date (from date) Date_End (to date) example: activity_1 02/05/2012 02/08/2012 I need a query that reading each record of table create X rows for ea... dandi.box (37)

before update Trigger 1 36 (12/31/2011 9:49:14 AM) comp.databases.mysql Hallo, have following problem: I have to send an updated Row to a history table. CREATE DEFINER=`root`@`xxxxxxx` TRIGGER `pp`.`buTrigger_Adresse` BEFORE UPDATE ON `pp`.`t_adresse` FOR EACH ROW BEGIN SET @i... manfred9141 (4)

table_rows of a table 2 52 (12/29/2011 2:29:03 AM) comp.databases.mysql hi, all: Most of time, if you want to get the records of a table, 'select count(*) from [table_name]' is okay. While, I find use " select TABLE_NAME, PARTITION_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH f... jiaxiaolei19871112

A feature table? 6 35 (12/10/2011 4:09:37 AM) comp.databases.mysql I want to make a feature table but not quite sure how to design my table. As a hypothetical example imaging a group of cars. Audi BMC Chevrolet Datsun Envoy Ford GM .. .. .. VW And imagine a list of colors ... bjobrien62 (510)

mysql query problem... 12 37 (12/9/2011 5:44:36 PM) comp.databases.mysql i have a table transactions. which have 2 fields id and loyalty_id. here the Id is primary key. my table like this. ID loyalty_id 1 1 2 1 3 1 4 2 5 2 6 3 7 3 8 4 9 4 10 ... vgrkrishnan (10)