kgariando

	Re: mysql tables lock problem while reading 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn hello i have seen that tables are locked in mysql while reading the same table..so should i continue using mysql in my website... Databases mysql 0 14 279
	Re: Compare Records based from the next Record 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and … Databases compare mssql query sqlce vb.net 0 12 315
	Re: help linking 2 different SQl databases 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn i am trying to figure out the syntax to do a SQL inner join from 2 different databases... The sameple code looks like this: select * from database1.dbo.table1 t1 join database2.dbo.table2 t2 on t1.field1 = t2.field2 but I dont know how to refernce the " database1.dbo" and "database2.dbo" parts.. can … Databases mssql 0 6 229
	Re: SQL Server Setup Command Line Problem 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I need to setup SQL Server Express using the command line and also make the installation unattended I tried many command lines however each one of them did not work here is the last one: Setup.exe /ADDCURRENTUSERASSQLADMIN="True" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVIC" /AGTSVCSTARTUPTYPE="Disabled" /ASBACKUPDIR="Backup" /ASCOLLATION="Latin1_General_CI_AS" /ASCONFIGDIR="Config" /ASDATADIR="Data" /ASLOGDIR="Log" /ASPROVIDERMSOLAP="1" /ASSVCSTARTUPTYPE="Automatic" /ASTEMPDIR="Temp" /BROWSERSVCSTARTUPTYPE="Disabled" … Databases mssql 0 1 307
	Re: Join multiple pivot tables 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time … Databases join mssql pivot query sql sql-server 0 1 3K
	Re: how to convert pivot data into unpivot data 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 … Databases mssql procedure store 0 3 305
	Re: moving recorc from one table to another 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I Need To Move a Record from one Table in a Database To another Table I am using ado in vb 6.0 plz help me! Software Development visual-basic-6 0 4 121
	Re: SQL Table Name Requirement 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hello, I wonder what is mysql table name requirements? I have tried creating mysql table with these names: group_mgt --> squprime.group_mgt table does not exist file_uploads_log --> squprime.file_uploads_log table does not exist In order to make the table creation works I have turn group_mgt to group AND turn file_uploads_log to … Databases mysql 0 5 294
	Re: Database Service Start and Stop. 9 Years Ago 9 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the … Databases mysql start stop 0 2 206