[microsoft:sql-server] Forum Topics

I`m recently got my last year project in a company, it’s a consultant company. I’m not sure how I’m going to start with the project…So I need help from you guys… I`ll start with the companies requirement: 1. He has a team of 7 people how will enter the names …

Hi guys, I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to solve the many-to-many relationship between some tables but now i am having trouble using them. I have …

eloo... i got the code to get data from sql to excell...but only the data that are displayed in textbox created early..i want to know how to grab all data and stored in excell...i created a table in sql nme tbl_rop and the attributes are Name_User, Date_of_birth, Hobbies, Phone_Number... this …

I'm new to JSP and trying to do a parameterized query. I've been able to do single stream queries to existing tables without any problem. I'm trying to build a search mechanism to do selective reporting. I've tried many hours to get the combination of different items to get by …

i have a Project and in it i have Application Form u must fill it in the internet . it have many fields to put data in , and i want to take these data to my DataBase but in many tables . am going the Application Form with ASP.NET …

Hi all, I hope someone can assist me with this. I have two databases and i need to replicate (on a regular basis) a couple of tables in one into the other. Any suggestions of the best method of doing this? with thanks Scott

hi friends, can posible to connect ms-access or sql database with c++ ? if posible tell the tips to do it......

Hi all experts, Currently i have a problem coding in sql query and hope someone expert can answer me. I have a table with the following values (simplified) Name in_date out_date able 12/03/2008 14/03/2008 bravo 10/02/2008 17/03/2008 able 18/03/2008 null Ok so my result if i want to obtain results …

i've create a program that contain a 4 textbox and three action button. the textbox are used to fill user name, date of birth, hobbies and number. while the action button are submit upadte and clear...all of this are working perfectly..i also manage to store all the data entered by …

i've create a program that contain a 4 textbox and three action button. the textbox are used to fill user name, date of birth, hobbies and number. while the action button are submit upadte and clear...all of this are working perfectly..i also manage to store all the data entered by …

Hello all, I'm having some problems with joins in SQL. I hope someone here can help me out a little bit. I'm using MS SQL 2000 Server. I have the following tables & data: [CODE] [B]Table: tUsers[/B] id location contact_id ----------------------------------------- 1 1 2 2 2 4 3 1 5 …

hi all, I have two problems 1. When i am updating the value of table manually. i am facing the error : The data in the row1 was not commited. Error Source : .Net SQL Client Data Provider Error Message : Time Out Expired and Second one is also related …

Hi there! I've a problem...want to return the total number of rows affected by the statement "SELECT * FROM Producao WHERE ProdUserID=UtilizadorID" can anybody give a look to the code below? [CODE] Dim ProdUserID As String = "samurai" Dim ProducaoSource As New SqlDataSource() ProducaoSource.ConnectionString = ConfigurationManager.ConnectionStrings("seaempiresdbConnectionString1").ToString() ProducaoSource.SelectCommandType = SqlDataSourceCommandType.Text ProducaoSource.SelectCommand …

how to establish connection from vb6 to mssql 2000?

I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql …

Hello: I have a confidential SQL database that I am working on with a friend. Until we can I get it set up properly with access levels and user passwords, I would like to keep it on my home computer external USB drive. I am running Windows XP. What I'm …

I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating : [B]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)[/B] How can …

Hi all... great forum! I'm basically on a crash self-learning course in Coldfusion and database-driven sites, so I'm pretty sure I'm missing some basic concept that would make this an easy query. If anyone could point me in the right direction I'd really appreciate it. This is for a site …

Ok, I have a e-commerce store that uses stored procedures to sort products. I have figured out how to sort my name and price but am having trouble sorting by rating bc the rating table doesnt have all the productids (only ones that have a rating) and also the rating …

I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of …

I've built a small PC app that resides in the Task Bar Tray until one of our employees sends a signal to it with a handheld device. When the PC app is activated, we connect to the SQL Server to retrieve records using Integrated Security on the PC:[code=vb]Private m_conn As …

I have been asked as an IT Technician to assist one of the IT Teachers at a residential school I work at to help with an Intranet site (I have had some experience with basic HTML before so thats why I was asked). The school is a residential school for …

Just started SQL Class and I am struggling with an assignment. Would someone be kind to give me some help please? your task is to make a stored procedure that will only billcustomers making monthly payments higher than $500.A Customer can have multiple Plans (services for which they pay amonthly …

Hi All, I am new to .Net. can anyone please tell me how to create loginpage in detail with steps and code. Thanks, Swapna

Hello everybody in the problem solving world !!!!......... Well I have come across a unique problem and am not able to find any logic behind that. My vb.net application runs on a sql server 2000 and it is about making bills in a fast running gift counter with 5 to …

Sir, I'm having table in sal server 2000 named Table name:Products Fields:Product name,image and description. The thing is i want to display only first 100 characters of Description I hv given like this Select substring(Description,0,99) from Products den d error msg is does not contain a property with the name …

Hi All I have a table (contactDetails) in my database (Sql express) with username,password, email, contactNo, bySMS and byEmail columns. I have 2 radiobuttons in my application smsRB and EmailRB, when the user registers he must select either smsRb or EmailRB. if smsRB is selected, a "Y" is inserted under …

1) [B]INNER JOIN[/B]---I know 2)[B]OUTER JOIN[/B]--I know 3)[B]CROSS JOIN[/B]--I know 4)[B]THETA JOIN[/B]--???? 5)[B]SELF JOIN[/B]--?????? 6)[B]NATURAL INNER JOIN[/B]- It eliminates attributes that have the same name. Can u plz frd me the example of NATURAL INNER JOIN. cz its not working in SQL 2005. 7) [B]EQUI JOIN[/B]----?????? Your EArly Reply will …

Hi guys, I was wondering if someone could help me please. How do i query the database using ASP and Dreamweaver to return the field names of a table? Thanks! Any ideas greatly appreciated. GLT

I wish to transfer data from a potential customer table to a customer table in my database if and when they become a customer and not just an enquiring customer. I need to be able to do this simply but I have no idea how. I am using ASP and …

hi, I am having some troubles while trying to connect a database which uses mssql server. Every attempt results with the error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." [CODE][INDENT]OleDbConnection conn = new OleDbConnection();[/INDENT] conn.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=voters;Data Source=T_YALTHIS\\SQLEXPRESS;Workstation Id=T_YALTHIS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use …

Hey guys, I am trying to design a query that will return all the records based on a single date but because of the date/time data type in MS SQL 2005 it defaults to the date and the time 00:00:00 which will return no records for me. Is it possible …

Hi I have a database with a Contacts table, in this table I have 2 columns emailAdd and byEmail. I want to select emailAdd where byEmail = Y and add these selected items into a Listbox. Please help how do i do this this is what I tried but does …

kindly help me - How to C++ to SQL Database connection

Hope i am posting in the right place. Any pointer will be helpful. Am a learner so pls bare with me.. Thanks for that :) I was just wondering if i want to make a simple web apps (Say a user data will be saved to sql db) which of …

Hi I would like to know what does constitute a Sql Developer, I want to do the transicion from Data Analyst to Sql Developer; however the descriptions I see online dial with performance and tunning or DW housing. Can some one explain? I have 5 year on the field Sql …

-------------------------------------------------------------------------------- Hello I am Using Vb.Net 2005 And Sql2005 See This [CODE] Dim RsSave as new adodb.recordset RsSave.open "Select * From Table Where 1=2 ",Con,CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic con.Begintrans RsSave.AddNew RsSave.Fields(0).Value = textbox1.text RsSave.Fields(1).Value = textbox2.text RsSave.Fields(2).Value = textbox3.text RsSave.Update Con.Commitrans [/CODE] This Just eg for saving to databse using Adodb connection …

Hello All, I'm having a little problem in witting an SQL statement. I'm sure there is a simple solution for it but its just not clicking with me!. Anywayz, I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign …

Hello all. Now I working with Project that use VB6,SQL Server . now my RESTAURANT want to update software by use Pocket PC order Food from customer. Plz Help me I don know the way to upgrade my Projcet. I need some idea. Help me please.:idea:

Hi, im going back through some SQL questions for my exams next week and I cant find a soloution for this, anyone help out? Do a report using SQL that lists the names of categories from which items were bought. For each category the report should show the total value …

here are some changes i made to the code.. as always the problem still the same nothing happen... can you figured it out what seems to be the problem....i really appreciate the help Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click Dim varConnection As New SqlConnection …

Hello :) , How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the …

i manage to use the next and previous button in my program..the problem is it only show the last data on my my database that is when i click the next button..same as the previous button... i used the code that was given and fix all the mistake.... but it …

hello, i want to cycle through a db table infinite times, ie; if there exists no value(reached end of table) in the result set, i wanna point the cursor to the start again...and it goes on infinite times wat do i add and where package project; import java.io.*; import java.net.*; …

command.Parameters.Add("@BrandName", SqlDbType.VarChar); command.Parameters.Add("@BrandName", SqlDbType.VarChar,50); The above are two possible ways to add a parameter on SqlCommand, is there any benefit on specifying the value 50.

I'm just getting started with asp.net. Currently I'm using visual web developer express and sql server express. I've created a small project but find when I run it in debug mode it works great. When I try to access it from another browser window I can as long as I …

Can someone show me what to do to get a query to run with persisence? [code] private void searchJComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) { if (searchJComboBox1.getSelectedItem().equals("by Artist")) { String holdQuery = searchJComboBox1.getSelectedItem().toString(); setSearchInput(holdQuery); //searchJTextField1.setText(getSearchQuery()); } if (searchJComboBox1.getSelectedItem().equals("by Song")) { String holdQuery = searchJComboBox1.getSelectedItem().toString(); setSearchInput(holdQuery); //searchJTextField1.setText(getSearchQuery()); } } @Action public Task searchSplash() { if …

My application runs on a network of 15 to 16 clients on a SQL Server 2000. Some of the modules perform transaction, i.e. they run more than one sql. I have tied the different sql statemels under the following procedure: <code> con.Open() trans = con.BeginTransaction() Try ‘First Sql cmd = …

I use vb 6.0 , Sql server and Data report . When i am go to show the report there is a problem. The Code is following. Private Sub cmdShow_Click() On Error GoTo Errorhandler Dim cn As New ADODB.Connection ' Dim rs As New ADODB.Recordset ' Dim rs1 As New …

Hi, I succesfully installed Sql Server express 2005 in my lap top . I'm using Windows Vista Premium. However I was not able to do anything my permissions were messed up I tried to add me as a db creator, db admin but Sql wouldn't let it displayed an error …