Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft SQL Server


SQL Query and Relational Database  

So my objective is to take a bunch of Select Statements of various lengths and complexities and provide the relational algebra "translation" of them. Extremely confusing for me, not much help from other sources I have looked at. Anyone... Continue Reading
Views : 47
Saturday 29th of December 2012

How to create simple graph using ajax with SQLite  

need hints.thanks. Continue Reading
Views : 35
Saturday 29th of December 2012

favorites table creation  

I am developing an application where the user will have the option of having favorites of service providers.. It is a child table with 2 columns, both of them will be foreign keys, the one column is a foreign key from the favorites... Continue Reading
Views : 51
Saturday 29th of December 2012

The remote procedure call failed.[0x800706be]  

hi....im getting this error "The remote procedure call failed.[0x800706be]".when i open sql server configuration manager.TCP\IP in enable.please help me..Thankq... Edited by naag, 17 December... Continue Reading
Views : 87
Saturday 29th of December 2012

What is an SRO   

Saw this question: Continue Reading
Views : 69
Saturday 29th of December 2012

Problem with LIKE  

That's the way I've usually done it when I have to find one identifier in a list like that in a single field. That's an argument for using a separate lookup table instead of a single field. You could also use a regular expression search but I'm not... Continue Reading
Views : 54
Saturday 29th of December 2012

SQL Query (NOT to take same value twice)  

Example i have data in database, i just want to display value from JOB (Not the same value twice) ID | JOB | NAME 1 | Engineer | OH LONG JOHNSON2 | Engineer | Peter3 | Cleaner | Katy So... Continue Reading
Views : 39
Saturday 29th of December 2012

Foreign Keys and Deletes  

I have not looked at SQL in awhile and now I'm confused on the topic of orphans. Let's say you have two tables: TABLE: STOCKPART_NUM DESC QTY_IN_STK TABLE: INVOICE_LINEINV_NUM PART_NUM QTY_SOLD You... Continue Reading
Views : 51
Saturday 29th of December 2012

embedded SQL in C  

I have this code that is supposed to change the telephone number of a particular tuple, but for some reason it seems like it selects the tuple with EID and then store the Telephone... Continue Reading
Views : 37
Saturday 29th of December 2012

How to create simple graph using ajax with SQLite  

need hints.thanks. Continue Reading
Views : 54
Friday 28th of December 2012

Most efficient way to login when multiple tables exist  

Hello everyone, sorry for the dull title. Couldn't think of anything better. So this is my problem.I was using a registration form for teachers and one for students. There are ten fields in each, first name, last name, username, password,... Continue Reading
Views : 42
Friday 28th of December 2012

Any free MySQL servers that support remote access  

I want to ask if there is any free MySQL server that supports remote access.People say FreeMySQL.net is one of the choices but I cannot connect to it through a PHP script on another web hosting server.Any idea? Continue Reading
Views : 52
Friday 28th of December 2012

mysql_error  

In reading the manual I saw that mysql_error was reset after every call to mysql.When I give the commandmysql_query($qry);if(mysql_error=='1062') // Looking for dupsecho ("dup found");After the first one is... Continue Reading
Views : 39
Friday 28th of December 2012

How to get data from multiple tables  

i want to fetch data from multiple tables. they all are similar that is they have same colum names (catalog_product_flat_1,catalog_product_flat_ 2,catalog_product_flat_ 3,catalog_product_flat_ 4.......), but they are not related.Is there any way to... Continue Reading
Views : 62
Friday 28th of December 2012

Is this SQL code good  

Hi, I'm hoping that someone with some SQL experience can let me know if this value set is good? I'm applying for a job that requires basic - intermediate SQL jobs and I just started teaching myself. Example: Continue Reading
Views : 41
Friday 28th of December 2012

How to add count() as column  

Hello. I have 3 tables: forum:ForumID|col1|col2|...|colN post:ForumID|col1|col2|...|colN topicForumID|col1|col2|...|colN Now I want to get table that would look like... Continue Reading
Views : 45
Friday 28th of December 2012

How to delete the data for the two or three tables at once  

helloI have a question , I thinking whether we can delete a data in one or three table at once time??How Query fo that ? Edited by fikiwan, 25 November 2012 - 11:01... Continue Reading
Views : 52
Friday 28th of December 2012

HTML5 SQL  

Has anyone here used this much? The example I have looks a bit odd. var sqlQuery = 'SELECT * FROM emptable';mydb.readTransaction( function(tx) {tx.executeSql( sqlQuery, [], successFunct, errorFunct);}); Continue Reading
Views : 53
Friday 28th of December 2012

Need help with case insensitive select  

Hello I am having problem with case insensitive select: I have tried.SELECT LOWER( Name )FROM `users`WHERE LOWER(`Name`) = LOWER('somename') and Continue Reading
Views : 63
Friday 28th of December 2012

Truncated Data  

Hi AllI have the following problem and was hoping some kind person out there could help!!!I am querying a database from with some asp code (see below) which runs a stored procedure which returns xml code. Using SQL Management Studio the xml returned is full length,... Continue Reading
Views : 155
Tuesday 27th of November 2012

Datetime parameterized call  

Sorry, in advance for bringing up this familiar old problem.I'm trying to get a date into SQL Server using parameterized call to a stored procedure.this line is being flagged up as causing an error. Continue Reading
Views : 183
Tuesday 27th of November 2012

Back up of a single table  

Hi guys,I want to know how to take a back up of a single table. I wanna take a back up from one server and implement the data of that table in another server.Thanks Continue Reading
Views : 152
Tuesday 27th of November 2012

How do I update the SQL Server 2008 to include the studio  

How do I update the SQL Server 2008 to include the studio?Here is what I currently have on my machine:I assume I am supposed to clidk on "SQL Server... Continue Reading
Views : 207
Tuesday 27th of November 2012

All emails received as junk or spam folder  

Hello,i developed a mass mailing tools, but all mails received in junk and spam folderi use an store procedure 'sp_send_dbmail' which is by default in sql server,when i send an testing mail using object explorer ->Database mail -> right click -> send testing... Continue Reading
Views : 182
Tuesday 27th of November 2012

Timeout error  

I have an excel program that runs every 10 minutes that gets data from files and inserts it in a table in the SQL server. Most of the time it runs ok. However when the network has heavy use, it generates a "Timeout" error. How do I prevent this? Continue Reading
Views : 171
Tuesday 27th of November 2012

SQL and Dates in DateTime format  

Having problems with a query, SQL Server, Classic ASP.In MS Access (ODBC connection to SQL Server), the following query returns 8 records Code: SELECT... Continue Reading
Views : 140
Tuesday 27th of November 2012

SELECT Query including JOIN & CASE Expression  

HiI am new to the forums so hopefully this is the best place to get help.I really appreciate anyone's help so I will try and structure this as clear as possible:Overview: An error is entered into the table, across two tables - tblErrors_ER and... Continue Reading
Views : 49
Tuesday 27th of November 2012

Another Question.  

I have a table that looks like this:Date Time A/B Row*1/1 8:00 A 11/1 ... Continue Reading
Views : 73
Tuesday 27th of November 2012

Hyperlinks on Intranet  

I have been successful with the creation of a database and a search results page. My need is for the following:From the records returned in the results page I need to open another page (popup) with more detailed information about the chosen record.Assistance is greatly... Continue Reading
Views : 122
Monday 26th of November 2012

database and asp  

Hi Guys, I've never done asp programmin in my entire life hehe but as part of a uni project I need to create a database for a real estate company. (never created a database before either!)I need to create something that will allow users to do a search via price and number of... Continue Reading
Views : 219
Monday 26th of November 2012