Questions tagged [SQL] (4020)


The keys in crosstabs M-to-M?

I must say that different solutions I can understand and justify, but I want to hear the opinions of others. Common situation: there are three tables for two entities and cross-table that implements a many-to-many relationship between these two entities. Example: the professional (Expert) and technology (Technology) that th...
rosemarie.Balistre asked October 10th 19 at 11:30

A "standard" batch separator for MySQL and PostgreSQL?

Added ECM7.Migrator treatment grouping request packets ("GO" for MSSQL and Oracle). What separators to set for MySQL and PostgreSQL?
Aiyana.Howe asked October 10th 19 at 11:30

Cant with and SqlDependecy

Sql Server 2005 and ASP.NET 3.5 The problem is known and is associated with a rapid filling ErrorLog sequel message type The query notification dialog on conversation handle '{F3EB22A6-CDB6-DF11-9BF1-003048CEA3F1}.' closed due to the following error: '-8490Cannot find the remote service 'SqlQueryNotificationService-558d19...
rogelio.Kertzma asked October 10th 19 at 11:27

Russian dictionary

Need a small Russian dictionary dictionary. It would be great once in SQL. But CSV or txt also approx.
Hertha asked October 10th 19 at 11:19

Which edition of mssql server to choose?

Not asked questions of licensing of software (all OS pre-installed was). Now we need to put the mssql server. The conditions are: 40-50 concurrent connections, volume of database, frequent queries. I think between MSSQL 2005 standard and Workgroup. What to choose, how much and where can you buy?
douglas.Williamson97 asked October 10th 19 at 10:44

Full SQL dump IBM DB2?

The work had to deal with the work of ibm, namely db2 9.7... Question: how to make a full dump of the database in db2, including structure, data, procedures and other logic? like to dump it all to a file, similar in structure to dump the MySQL? db2look only saves the structure, as I understand it. And maybe someone has had ...
joshua_Hills asked October 10th 19 at 10:38

On how to write application for Accounting?

There is a task to write application for registration in remote stores, so that the customer could at home(in the resort, in trip) view statements. (how many sold per day, that is, to see hammered by the sellers information.) Unfortunately I have experience in these tasks, a complete zero. From dostopnih technology know Qt...
Akeem_Spencer asked October 10th 19 at 09:46

Sorting in LINQ to SQL

There is a task to display a... well, for example products in the Internet section of the store. Using LINQ to SQL. Write code similar to this: List lstGoods = DataContext.Sections.Where(x=> = iMySectionId).First().Goods.Take(iPageSize).ToList(); The problem is that the goods should be ordered. Code is converted t...
Vince_Donnelly asked October 10th 19 at 09:39

To test the form — if changes

There is a large form of type text.field|text.field|checkbox|checkbox ... Well, in General, edit a pile of records from the database. How to do a background check — were any changes made in this string in any of the fields? And then each time to update all of the records as it is irrational. How would it matter to mark? JS ...
Kristy45 asked October 10th 19 at 08:40

Where to find a tutorial on SQL?

Advise, please, a tutorial (preferably not the Talmud) at the SQL in the Russian language. Dialect can mysql.
Lane.Gutmann21 asked October 10th 19 at 08:18