| androidbruce | seattlegaucho, yes | 00:39 |
|---|---|---|
| androidbruce | seattlegaucho, i just took a job that uses MS SQL daily | 00:40 |
| androidbruce | so i was curious if you could shed some light | 00:40 |
| seattlegaucho | not really ... we have a SQL server here ... but we stay away from it like the plague | 00:42 |
| androidbruce | seattlegaucho, are queries similar? | 01:17 |
| seattlegaucho | SQL is mostly standard, so unless you get into stored procedures and stuff they should be similr | 01:17 |
| androidbruce | seattlegaucho, ok so anywhere you can point me to learn queries? | 01:21 |
| androidbruce | how to "grep" a database | 01:21 |
| seattlegaucho | that's a toughie | 01:21 |
| seattlegaucho | any introductory SQL book should work ... however ... | 01:21 |
| seattlegaucho | you need to learn how to check the 'database' and 'table' definitions, which is specific to SQL server | 01:22 |
| seattlegaucho | in MySQL it would be "SHOW DATABASES", "SHOW TABLES" and "SHOW CREATE TABLES" ... or there is another one: DESCRIBE ... | 01:23 |
| seattlegaucho | look for the equivalents on SQL Server | 01:23 |
| seattlegaucho | that will give you a basic understanding of the structure and from then on you can use SELECT to start making sense of the data | 01:24 |
| androidbruce | seattlegaucho, i see ok | 01:24 |
| androidbruce | with SQL Server, i can see everything graphically | 01:24 |
| androidbruce | so i've been failing, but using select * ........."User".......... etc etc | 01:25 |
| seattlegaucho | GUI is OK ... although it helps to understand what's going on underneath | 01:53 |
| seattlegaucho | ... need to go home ... I'll catch up w/ you tomorrow | 01:53 |
| * seattlegaucho waves to the crowds | 17:04 | |
| * seattlegaucho had to crack open the only sql server screen active at his company | 21:53 | |
| * seattlegaucho blames androidbruce for invoking the demons | 21:53 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!