Tagged Questions
0
votes
2answers
37 views
How to fetch the next records from a table in sql database one after other
I am developing an application where I need to send the Emails to all the users in the table. Since the number of users is in millions, so to select all the users at once won’t do any good. Is there ...
-3
votes
1answer
39 views
sql server trigger to increment a column when another column decrements
I have a movies table with columns id, title, inventory and I added a column rental_count. I've found solutions online to increment rental_count after the row is updated but would it be possible to ...
1
vote
2answers
43 views
Convert MySQL query to Microsoft SQL Server
I need to convert this MySQL query to a SQL Server query where the syntax 'LIMIT ?, ?' is my main main problem because isn't compatible with SQL Server.
At the same time I don't know the meaning of ...
1
vote
1answer
27 views
Android database synch
I implemented an android app, in which, in order to maintain synched my local database and a remote database (SQL Server), I use a service that, with a predefined frequence, call some web service that ...
android
-1
votes
0answers
36 views
Convert mysql to mssql query problems [duplicate]
Please help...
I'm having problems with sql query. I need convert query from mysql to mssql.
This is java function where is used mysql query.
Can someone translate this query, but java function must ...
0
votes
2answers
36 views
Best way to store large number of datarow for querying
Whats the best way to store a large number (several millions) of records used to create reports on? The nature of the application demands that each record that matches a search is sent to the ...
0
votes
2answers
36 views
List of triggers for each table?
How can I get a list of triggers associated with each table?
I’m trying to get something like this:
Table 1 – Trigger for Table 1 – Trigger for Table 1 – Trigger for Table 1
Table 2 – Trigger for ...
0
votes
3answers
30 views
batch commit rows to database in c# using a counter
I am developing a file parser in C# such that I have a file with many many rows. I want to write that to database.
I have created a loop in which I read the file and issue an insert.
However, what ...
0
votes
2answers
25 views
A gap between id which are autoincremented in db
I have a table in my db whose id is int auto increment. When I create a ndew entry everything goes well, the id is incremented by 1.
But today I saw a big hole. One of the records has id=56 and the ...
1
vote
2answers
33 views
Database tables relationship in SQL Server
I have a jobs(job) table and a tool table in my database. Tool table is divided in two parts first is category(tool_category) and other is tool data(common_tools).
Now what I want to ask is, I have a ...
1
vote
3answers
50 views
TSQL Translate ChangeData Field in CRM 2011
I have a delimited string which acts as a key for a target delimited string. I need to know where 2 values are in the key sequence, and then pull only those positions from my target string.
Example 1
...
0
votes
2answers
92 views
Organising Dbs and tables in SSMS
This is a repost of a question I asked 4 or 5 days ago, with zero response. Hoping for more luck this time...
(Using SQL Server 2008)
Hi
Within the next few weeks I plan to introduce SQL server to ...
5
votes
1answer
93 views
Best way to enforce table participation
I am not sure what will be the best way to enforce participation in the following database design (can be for SQL server, Oracle, mySQL etc.). I have two tables: Factory and Worker. I have created two ...
1
vote
0answers
29 views
Multiple SQL Server data files on same SAN disk [migrated]
I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
0
votes
0answers
48 views
How to create a network with all the track points
I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database.
Now I have a table which holds all the track points of these ...
