Search Results

Search found 27337 results on 1094 pages for 't sql'.

Page 417/1094 | < Previous Page | 413 414 415 416 417 418 419 420 421 422 423 424  | Next Page >

• How to access GMAIL for storage in custom CRM SQL Server DB?

  - by Optimal Solutions

  I have a client who wants his custom-written CRM to be able to access his sales people's emails so that, effectively, a history of email conversations between customer and salesperson is stored inside the CRM's database. The CRM is written in VB 2008 and the database is SQL Server 2008. The only email these people use, in the shop and on the…

  Read the article

• Is there a web site where I can paste a SQL Insert statement and have it break it out by column?

  - by Scott Whitlock

  I've been working on an application that has no discernable data access layer, so all the SQL statements are just built up as strings and executed. I'm constantly confronted by very long INSERT statements where I'm trying to figure out what value in the VALUES list matches up with what column in the column name list. I was about to create a…

  Read the article

• What is the simplest, but solid, interface from WinForms to a SQL Server database?

  - by Greg

  Hi, If I wanted to have my data in SQL Server, but wanted to use a thick client WinForms application for users, what would be the best practice way to have calls occurring from WinForms to database? And how simple is this? I guess I'm trying to gauge to what extent there are issues with this approach and one needs to go for some (a) middle…

  Read the article

• How to make VB to execute my SQL SP with parameters?

  - by fema

  Hi, I have a database in MS SQL Server 2008, I have Stored Procedures. One of them does an INSERT with parameters. It works in Server Management Studio. Now I'd like to make a button in Visual Basic 2008 that executes this SP. I have made a DataSet, it contains my 3 SP's, I can easily use 2 of them, because they return data, but the one I'm…

  Read the article

• Possible to use Tables of same type in Linq to SQL?

  - by Schneider

  Lets say I've got an object model, where I have many collections of the same type. For example something like class StockMarketData { List<SummaryData> WeeklySummary; List<SummaryData> MonthlySummary; } class SummaryData { DateTime DateTime {get; set;} double Value {get; set;} } Those lists will map onto database…

  Read the article

• In SQL Server merge replication, how does reinitializing work?

  - by Craig Shearer

  I have set up a pull subscription to a merge publication in SQL Server. I use parameterized row filters on some tables. This works fine with the initial synchronization - just the rows using the filter arrive in the replicated (client) database. However, at some later point I'd like to be able to synchronize the replicated database…

  Read the article

• How would I order a table by the number of matching params in the where clause of an sql statement?

  - by Eitan

  I'm writing sql to search a database by a number of parameters. How would I go about ordering the result set by the items that match the most parameters in the where clause. For example: SELECT * FROM users WHERE username = 'eitan' OR email = 'eitan@eitan.com' OR company = 'eitan' Username | email | company 1) eitan …

  Read the article

• How to call sql procedure from an html button?

  - by anand

  Hey guys, my doubt is pretty simple to understand. I have a sql procedure that generates a util file as its output depending on the input parameters that are passed to it. I have to pass these parameters from an html page from 3 text boxes.There will also be a button ,on clicking which, the procedure will be called and the util…

  Read the article

• How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?

  - by Bryan

  I have 3 Tables: NotHeard,analyzed,analyzed2. In each of these tables I have two columns named UnitID and Address. What I'm trying to do right now is to select all of the records for the columns UnitID and Address from NotHeard that don't appear in either analyzed or analyzed2. The SQL statement I created was as follows: SELECT…

  Read the article

• I am designing a bus timetable using SQL. Each bus route has multiple stops, do I need a different t

  - by Henry

  I am trying to come up with the most efficient database as possible. My bus routes all have about 10 stops. The bus starts at number one until it reaches the 10th stop, then it comes back again. This cycle happens 3 times a day. I am really stuck as to how I can efficiently generate the times for the buses and where I should…

  Read the article

• Is it OK to allow users to query an OLTP SQL Server database with excel?

  - by user169867

  I have a SQL Server 2005 database used by several applications. Some users wish to query the database directly from excel. I can understand this, because it is a useful tool for adhoc queries and then getting the data in a format that's easily transmitted and manipulated by other users. My question is: Does Excel (say…

  Read the article

• How to send reminder notifications to subscribers for renewal from SQL Server 2005?

  - by codemonkie

  I have a table in SQL DB, namely dbo.subscribers, it contains following columns: -SubscriberID -JoinDateTime The business logic says a subscription last for 2 weeks and a reminder should be sent after 7 days from the JoinDateTime. The way that the system was designed to send reminders are via a URL call, e.g.…

  Read the article

• SQL to display an event on start date, end date and any days in between.

  - by Tim

  Hello, This should be fairly simple, but I can't get my head around it. I have an event in my database with a startDate and an endDate. I need to display this event (based on the current date) on every day the event occurs. So if the event starts on the 3rd of May and finishes on the 7th of May, the SQL…

  Read the article

• Rails/SQl query help: Find all by created_at in past 7 days per each day?

  - by Senthil

  I'm unable to get SQL and Rails to play properly when trying to find Categories that are created each day, the past 7 days. So basically I want to find each Category sorted by the day they were created for the past 7 days. I found this on stackoverflow, but it isn't finding a Category that I just created:…

  Read the article

• Int PK inner join Vs Guid PK inner Join on SQL Server. Execution plan.

  - by bigb

  I just did some testing for Int PK join Vs Guid PK. Tables structure and number of records looking like that: Performance of CRUD operations using EF4 are pretty similar in both cases. As we know Int PK has better performance rather than strings. So SQL server execution plan with INNER JOINS are pretty…

  Read the article

• How can I pull data from a SQL Database that spans an academic year?

  - by Eric Reynolds

  Basically, I want to pull data from August to May for a given set of dates. Using the between operator works as long as I do not cross the year marker (i.e. BETWEEN 8 AND 12 works -- BETWEEN 8 AND 5 does not). Is there any way to pull this data? Here is the SQL Query I wrote: SELECT count(*),…

  Read the article

• How to run an SQL stored procedure through C# at a specific time?

  - by yishai neeman

  I am building a website now for a library and i need to check every day at the same time if there are people who need to return their books in the next five days and to send them a reminder via email. My question is what will be the correct way to do that? What i need to accomplish is when…

  Read the article

• How do you boost term relevance in Sql Server Full Text Search like you can in Lucene?

  - by Snives

  I'm doing a typical full text search using containstable using 'ISABOUT(term1,term2,term3)' and although it supports term weighting that's not what I need. I need the ability to boost the relevancy of terms contained in certain portions of text. For example, it is customary for metatags or…

  Read the article

• In SQL, what does Group By mean without Count(*), or Sum(), Max(), avg(), ..., and what are some use

  - by Jian Lin

  In SQL, if we use Group By without Count(*) or Sum(), etc, then the result is as follows: mysql> select * from sentGifts; +--------+------------+--------+------+---------------------+--------+ | sentID | whenSent | fromID | toID | trytryWhen | giftID |…

  Read the article

• Need to speed up the results of this SQL statement. Any advice?

  - by jeffself

  I've got the following SQL Statement that needs some major speed up. The problem is I need to search on two fields, where each of them is calling several sub-selects. Is there a way to join the two fields together so I call the sub-selects only once? SELECT billyr,…

  Read the article

• How to study for MCTS 70-433 exam (SQL Server 2008 Database Development) and is it worth it?

  - by Mugen

  Hi, I'm working as a QA (Software Tester with 3 years of experience) and was thinking of getting some certifications for my career. I already have the ISTQB certification and was thinking of doing SCJP along with MCTS 70-433 certification (SQL Server 2008 Database…

  Read the article

• How to use SQL - INSERT...ON DUPLICATE KEY UPDATE?

  - by Probocop

  Hi, I have a script which captures tweets and puts them into a database. I will be running the script on a cronjob and then displaying the tweets on my site from the database to prevent hitting the limit on the twitter API. So I don't want to have duplicate tweets…

  Read the article

• A 4-byte Unsigned Int for Sql Server 2008?

  - by Jeff Meatball Yang

  I understand there are multiple questions about this on SO, but I have yet to find a definitive answer of "yes, here's how..." So here it is again: What are the possible ways to store an unsigned integer value (32-bit value or 32-bit bitmap) into a 4-byte field in…

  Read the article

• What is a good practice for handling SQL connections within a WCF call?

  - by Rising Star

  Suppose I want to create a (stateless) WCF service with three methods exposed on an endpoint: performSqlOperationA(), performSqlOperationB(), and performSqlOperationC(). Each method inserts data into a SQL database. The way I've seen things done at my office,…

  Read the article

• Can I use a stream to INSERT or UPDATE a row in SQL Server (C#)?

  - by Cheeso

  Suppose I have a VarBinary[MAX] column, can I insert or update into that column using a type derived from System.IO.Stream? How? I think that I can obtain a read-only stream from such a column using a SqlDataReader, calling GetSqlBytes() on the reader,…

  Read the article

< Previous Page | 413 414 415 416 417 418 419 420 421 422 423 424  | Next Page >