/srv/irclogs.ubuntu.com/2011/09/01/#ubuntu-us-wa.txt

androidbruceseattlegaucho, yes 00:39
androidbruceseattlegaucho, i just took a job that uses MS SQL daily 00:40
androidbruceso i was curious if you could shed some light00:40
seattlegauchonot really ... we have a SQL server here ... but we stay away from it like the plague00:42
androidbruceseattlegaucho, are queries similar?01:17
seattlegauchoSQL is mostly standard, so unless you get into stored procedures and stuff they should be similr01:17
androidbruceseattlegaucho, ok so anywhere you can point me to learn queries?01:21
androidbrucehow to "grep" a database01:21
seattlegauchothat's a toughie01:21
seattlegauchoany introductory SQL book should work ... however ...01:21
seattlegauchoyou need to learn how to check the 'database' and 'table' definitions, which is specific to SQL server01:22
seattlegauchoin MySQL it would be "SHOW DATABASES", "SHOW TABLES" and "SHOW CREATE TABLES" ... or there is another one: DESCRIBE ...01:23
seattlegaucholook for the equivalents on SQL Server01:23
seattlegauchothat will give you a basic understanding of the structure and from then on you can use SELECT to start making sense of the data01:24
androidbruceseattlegaucho, i see ok 01:24
androidbrucewith SQL Server, i can see everything graphically 01:24
androidbruceso i've been failing, but using select * ........."User".......... etc etc 01:25
seattlegauchoGUI is OK ... although it helps to understand what's going on underneath01:53
seattlegaucho... need to go home ... I'll catch up w/ you tomorrow01:53
* seattlegaucho waves to the crowds17:04
* seattlegaucho had to crack open the only sql server screen active at his company 21:53
* seattlegaucho blames androidbruce for invoking the demons21:53

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!