[microsoft:sql-server] Forum Topics

I am currently using the ODBC class for c++ to connect and query a SQL database. I am calling a stored procedure within the database like so: [code=cplusplus] try{ myCon->Open(); OdbcCommand^ myCmd = gcnew OdbcCommand(MySP,myCon); //MySp is my store procedure and myCon is the SQL server connection string myCmd->Parameters->Add("xml",OdbcType::Char,200); myCmd->Parameters->default[0]->Direction=ParameterDirection::ReturnValue; …

My database knowledge is pretty limited but im hoping this will work...... The idea is to have a database for customers who have their grass cut fortnightly. The database will be mail merged to form bills every month or so... So far I've constructed a database with the following tables: …

Hi, I want to put a function (Button maybe) that will enable the site Admin to backup the website database, I have 2 SQLEXPRESS databases, the Default ASPNETDB.mdf and my own WebDB.mdf . I have no idea how to proceed.

Hey guys I am creating a till system (EPOS system) in vb.net I have a textbox and a datagrid and I am using SQL Server 2005 as a DBMS. I have already managed to retrieve data into the datagrid by typing in an item number into the textbox, hitting a …

Hi All, I am developing a report generation web page in which i have a text box in which a user would enter a value and i have to extract similar data from my MS Access database. I have tried using wild card % but it is giving an error. …

I am really at my wits end now....i am unable to find ne proper code for autonumber generation...if i do find its not working. plz i want it ..i am using sql server 2000 and vb.net 2005. just tell me can we make use of max function ? ie. first …

Can ne one of u plz tell me how to search a particular record in the database ? my prob is that when i enter say an ID / Name it should search into database for the same and accordingly if the record is found my cmdbutton will be enabled …

I'm writing a program determine employee's working hours in a day by entry and exit clock in classes. In sql, I have a table, there are 4 field like : classID, cardID, date and clock. Teacher come to class and every teacher have an unique card. Card reader read this …

Hi, I want to create a DataBase Diagram using MS SQL Server Management Studio 2005. But on context menu of DataBase Diagrams Folder, I am not able to see New Database Diagram menu item for any of the Database. I am getting only two menu item "Working with Sql server …

Hi here it is babukumar Today morning i Found this Community and i had joined im working in vb 6.0 and sqlserver areas

I m using LAN Connection,My system used as remot , When i going to run , my system become HANG!!! i m doing VB.Net Programs , using sql2000 backend What shoud i do ??? Can u help me......??????????

Hi, I want to join a table with itself to get all possible combinations of the variable Name in two columns. My first attempt was this: [CODE] SELECT P1.Name, P2.Name FROM Pairs AS P1 INNER JOIN Pairs AS P2 ON P1.Group = P2.Group WHERE P1.Name <> P2.Name [/CODE] The thing …

I have a datalist control that is displaying like 10 records using a Sqldatasource field 1, field 2 and field 3 and databinded from sqldatasource and field 4 is a textbox (not binded, the user will enter an info here).the value from field2 and the value i have enter in …

how do i select data from a table by sorting the first word from a column? for example: "user1 hello" "user2 one two three" "user3 where are you" "user1 im fine" how can i select all the data starting with "user1"?

I m useing this below Cods, But its not working ..... Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim con As System.Data.SqlClient.SqlConnection Dim cmd As New System.Data.SqlClient.SqlCommand Dim cmdd As New System.Data.SqlClient.SqlCommand Dim da As New System.Data.SqlClient.SqlDataAdapter Dim ds As New DataSet Dim dt As …

So, I've been poking around in MS SQL for a while and it kinda looks like Access a little, but it seems harder to enter data, change data, etc. Not very user friendly to a person used to Access. I've been using Enterprise Manager and Query Analizer, but it takes …

I did find a thread that kinda answered this, but it was from last year, so I thought I'd start a new thread about this: In Access the data type is memo, what is the 'memo' data type in MS SQL? I might possibly need to have space for 15,000 …

I've developed a software using VB6 and MSSQL 7.0. Now I need to create a backup-restore program on behalf of my software. For this I need to fetch down all the table names located inside the database used in the software. My database name is -->BILLING_SYSTEM and I've also created …

Hi I have just been informed by a few work collegues that the database system that I have created should now be set to use Server Username and Password. Is it a big deal to change this without disrupting the current relationship of the database stored procedures and application code? …

Hi Everyone, i've got a problem after opening CSV file to the client Side. my application import data from the Client Side to the server, while it running i keep record of errors in DataTable Object and at the end of the process i export this DataTable into a CSV …

We are using 4 systems ..... system1 is only having SQL Server , in my system i m having setup for SQl , How can i register my system?????? i did the following things... Start >>> Programs >>> Microsoft Sql Server >>> Enterprise Maneger Then Sql Enterprise Maneger Page opened …

Hello, i am a novice programer in vb.net. currently am developing an application in vb.net 2005 n sql server 2000 ..the project name is Information Management System....d application/project looks common as it includes all admn, enquiry , fees, faculty etc...screen n accordingly their databases..... however , i want to try …

Hi I m new to Vb.net. i need to Know anout the ConnectionString Details,. For eg. First Name Last Name PH Number Use this 3 datas to save Sql. plz give me the Coding for this ...

hello to all, Im trying to load xml file to sql server but I dont have enough knowledge how to create schema xml, as of now im using vbscript program to upload my xml, here is my vbscript codings, Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "provider=SQLOLEDB.1;data source=codevelopment;database=Johnny;uid=restorer;pwd=" objBL.ErrorLogFile = "c:\error.log" …

I use the TableAdapter Configuration Wizard under VS2008 and use SQL Server Express. This is my database diagram: [URL="http://farm4.static.flickr.com/3076/2803435396_c35b6dc2a7.jpg?v 0"]Database structure[/URL] And this is my SELECT statement: [CODE]SELECT Parties.PartieID, Parties.RondeID, Parties.JoueurNoirID, Parties.JoueurBlancID, Parties.ScoreNoir, Parties.ScoreBlanc, Parties.VainqueurID, Parties.DetailVictoire, Rondes.Numero, Tournois.Nom, [B](SELECT Pseudonyme FROM Joueurs WHERE JoueurID = Parties.JoueurNoirID) AS JoueurNoir, (SELECT Pseudonyme …

There is a big problem for me as I have to handle a project made by an other person and I m not aware of this code.I have two tables in SQL Server 2005 named AudioFileDetails having fields---- FileId int 4, FileName varchar 1000, Subject varchar 500, DistrictId smallint 2 …

I have a query which gives results like ACTIVITY MONTH1 MONTH2 MONTH3 MONTH4 MONTH5 MONTH6 ... PLAN 1.5 2.1 3.1 1.0 1.2 4.6 ACTUAL 1.2 2.O 2.9 0.7 1.0 2.7 I WANT TO CHANGE THE ORIENTATION OF THE TABLE IN THE FOR AS GIVEN BELOW, MONTH PLAN ACTUAL MONTH1 1.5 …

I've been trying to run an SQL script using an Excel macro. There are hundreds of records (one coumn - Item numbers) returned, and I would love to have the results start at C3 in the Excel worksheet and propagate down until all of the records have been added to …

how can i display the last insert id into a textbox on my web form? here is the code i have so far... [COLOR=#0000ff]Protected[/COLOR] [COLOR=#0000ff]Sub[/COLOR] Button1_Click([COLOR=#0000ff]ByVal[/COLOR] sender [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]Object[/COLOR], [COLOR=#0000ff]ByVal[/COLOR] e [COLOR=#0000ff]As[/COLOR] System.EventArgs) [COLOR=#0000ff]Handles[/COLOR] Button1.Click [COLOR=#0000ff]Dim[/COLOR] MyConnection [COLOR=#0000ff]As[/COLOR] SqlConnection MyConnection = [COLOR=#0000ff]New[/COLOR] SqlConnection() [COLOR=#008000]'declare new connection object [/COLOR]MyConnection.ConnectionString = [COLOR=#800000]"Data …

Hi, I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still listing all in a table. Can anyone help pls. …

Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c …

i am using ozeki sms server to send/receive SMS. currently, when i receive SMSes, they will be inserted into this messagein table (microsoft sql server) altogether. however, i wish to implement it this way: user A sends message to #1: hello [TO REPLY: user A <SPACE> <MESSAGE>] #1 replies user …

I am working with a database table that has a list projects. Some of these projects have sub-projects. There is a column with weekending dates with corespond to manhours associated with that week. Here is an example. JobNum SubJobNum WeekEndingDate Manhours -------------------------------------------------------------------------- 1 001 8-17-08 200 1 001 8-24-08 300 …

Hi, I would like to know if it is possible to use SQL Server reporting services in vb.net 2005 as my application is not web-based so I cannot use ASP.net. I have searched the internet for tutorials but I can't find anything that describes how to use vb.net instead of …

Hi, I hope someone can help me. I urgently need to find out why my problem is occurring. I am trying to install SQL Server 2005 with the additional features from the microsoft website but it keeps telling me it cannot find IIS (which I need in order to install …

I'm trying to find information on how to import selected data from one SQL database to another using C# (or any language for that matter) or the cmd line. aka: I dont want to use the wizard. I could export to a CSV file, then import... but that seems needslessly …

Hi all, Does anyone have any experience with a PHP Web-based form builder/administrator that's designed to use MS SQL? I know there's a lot of PHP/MySQL-based products out there, but I have to use MS SQL. I need to be able to create Web forms relatively easily with a Web-based …

when typed in vs2005 command prompt aspnet_regsql.exe it gives error:application failed to initialize properly;

hi all,can anybody point out wats wrong in my database design, guide me right database ,i ve 4 tables i type all its attributes its for hospital database patient table pid, pfname, plname, pcontactno, page, pplace ,pdocname, pprob ,ptype(this is for out patient,inpatient), pbill. doctor table docid ,docname, docplace ,doccontactno …

Hi I have a stored procedure that returns the unique ID for a particular Name/string passed in. On my windows form I have a ListBox control filled with a list of names (returned from another stored procedure) I want to be able to let the user click the list box …

Hi all, I m making a project on airlines reservation in C#. I have some problem. The problem is when i accept the values from the user like Origin City,Destination City,Date of travel and class of travel. After filling this information user clicks on the Available Flight button. When clicking …

hi friends.. i'm studying mca(5th sem).. this sem we've a middleware project which connects 3 different databases.. yet now i used only one database.. so i dont know how to give datbase link.. i've googled.. but none has explain that clearly(not upto my satisfaction)!! can anyone give an idea how …

Hi I want to write a query In my table data like this sapno plant amt status a SG20 7 1 b HK10 24 4 a HK10 60 4 b SG50 20 12 a HK10 7 4 c HK10 7 4 if more than one sapno is same value then …

Hi, I am trying to use IRowsetFastLoad to insert multiple columns to a permanent SQL Server table.. The problem is, that the InsertRow returns an E_FAIL, which is a provider specific error. I am staging the column Data as follows into the memory buffer: (with Appropriate offsets for the bindings …

Can MS SQL can convert accented characters to non-accented characters? Ex. Ã -> A Thanks

Hello everybody,, I'm developing a web application using ASP.NET and i'm new in databse (basic knowledge:) ) ,,and i have to create a table that stores any changes made in the database tables includes (insert,update and delete) ,,i googled about how to do it and i found many articles about …

Hey guys I have installed SQL Server 2005 Developers edtion and I have noticed that I dont have SQL Management Studio feature available. I am currently in the process of reinstalling just incase I missed out an option during installation. What concerns me is: Is Management Studio available on SQL …

Dear Friends I have a Query. I have a Stored Procedure Which takes an Input parameter . I want to fill Dataset with table based on the same input parameter.I have already used it with data reader . But with Data Adaptor and Data Set its not properly working .The …

I have 2 tables, a table with header records and a table with detail records. If I run the following, I am shown that I have 96 duplicate rows. select item_id,count(*) from in_qty_price_bracket_hdr where item_id is not null group by item_id having count(*) > 1 The item_id field is not …

I am newbie and trying to make a data display application in VB6 with 3 forms - Form1 is background Flash animation & graphics (Interface) - Form2 is for data-1 display - Form3 is for data-2 display Form2 & Form3 will display as slides on Form1 Data is in text …