[microsoft:sql-server] Forum Topics

i have these 2 sql for creating 2 tables in my database, what i have to write to show that is one to many relationsip? [one supplier to many order status] CREATE TABLE Suppliers( SupplierID nVarChar(10) NOT NULL CONSTRAINT Suppliers_PK PRIMARY KEY, CompanyName nvarchar(40) NOT NULL, Description nvarchar(100) NULL, SortOrder …

Hello friends, i'm creating a website using JSP with MS SQL. I want to use md5 to encrypt user's password. 1. Is it safe? 2. how to use it i.e. can you guide me what code should be written in "New user's sign up" page and "Login page"? Please Help. …

i wrote an asp script and when i made the guest book ( when i used the addSQL ) this error returned [CODE]Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /science/add.sign.asp, line 15[/CODE] This is the add.sign.asp [CODE] <!--#include file="connection.asp" --> <% addedin=now() name=request.form("name") email=request.form("email") ranking=request.form("ranking") notes=request.form("notes") …

[B]Hello Friends, On my web form there is one DropDown List Box which contains different Items.. and one TextBox, user will Enter Quantity in textBox.... Now problem is that I want to Add Item and Qty in DataGrid on the Same Page when I click on ADD Button......... Later on …

I'm trying to insert data into three tables in a relational database. Right now it will only insert to the first table and then it errors out. If you have some genius to share, don't hold back. Thanks. [code] Imports System Imports System.Configuration Imports System.Data.SqlClient Imports System.Web.UI.WebControls Partial Public Class …

Hi there! I've developed a program in C# that calls a stored procedure in SQL server. Is it possible for a stored procedure to pass back a result set with multiple rows? If so how do I access these values in my application. Many Thanks!

I have Used following code to Insert Values in the table: <%@ Import Namespace ="System.Data" %> <%@ Import Namespace ="System.Data.SqlClient" %> <script runat ="server" > Sub Create(ByVal obj As Object, ByVal e As EventArgs) Dim ConnString As String Dim SQLstr As String ConnString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ERL.mdf;Integrated Security=True;Connect …

First hello to every one in this forum. Well I am using MS Access 2003 for building a database. [B]I am usign 3 tables.[/B] [LIST=1] [*]Students [*]Books [*]Request [/LIST] Both student and books table has one to many relation with request table. I am using MS Access Forum for all …

Hello all, this tools is used to load CSV files to SQL server table. all the tools that i found on the internet are not free, i have developed this tool so it can help you. regards download link here: [url]http://www12.sendthisfile.com/d.jsp?t=J8hEGXcRYqej3qrjku3N63Eh[/url]

[B]Hello Friends, On my web form there is one DropDown List Box which contains different Items.. and one TextBox, user will Enter Quantity in textBox....Now problem is that I want to Add Item and Qty in DataGrid on the Same Page when I click on ADD Button......... Later on Data …

Hi friends, I'm creating a website for my college project. on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database. I don't know how to do it. Can you please help me? I'm …

we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005. But we have some permission issues for …

I'm stuck here. Please Help me! I've created a feedback form which takes name, Email Id & Comments from users. On submit button, i want to save the entered details along with the current date to the UserDetails table, so that, when admin logs in and wants to see the …

Hi, Please help! We have data that was input into SQL Server using activedit. This data has all kinds of inline styles, and it looks horrible. Is there a way to parse the data and get rid of all inline styles? Thank you for any help you can provide.

I have a drop down that will be auto populated when the user selects a previous drop down. The one in question is referencing a particular piece of equipment attached to the company that was selected. The database is set up with a manufacturer table, equipment table, and customer equipment …

Need some help with a nested loop. This one (my example code below) prints out a correct 3 column HTML table with the recordset with proper opening and closing HTML tags AS LONG as the GRUOP BY clause is set by the topcategory Db table. I think I may need …

Hello, I have a vb.net application that runs on a server. There are five client PC's that are connected to the server and all the data is saved on the server from my vb.net application. To add a record, two sql runs under Commit transaction. One runs an insert statement …

I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use dbms_lob.writeappend, I am getting the following error..Command text was not set for …

Hi i am passing three parameters to my stored procedure. now in stored procedure i want to execute the query on the basis of given condition. suppose i m passing para1, para2 and para3. now i want update table1 if(para1='' or para1= null) then 'update table1 set para2='''+@para2+''' and para3='''+@para3+'''' …

want to know the coding of h ow to define connection of SQL database wid deplhi so that i can insert data in database

Hi all. just wondered if there was a quick and easy way (or good tutoriaL) to validate user input (on a login control) against a SQL database where the users username and password credentials are stored. Any suggestions will be greatly appreciated! Thanks for your time.

My name is Richard Walker from Australia and my username for this forum is richie513. I am a self taught web engineer and married with three beautiful children and a loving wife. I was born and raised in the harsh outback of Australia, and now reside on the beautiful sunny …

Hey folks, I have this problem, lets take this text from from 24ways.org just for example-> [QUOTE]Elbow room Paying attention to your typography is important, but it’s not just about making it look nice. Careful use of the line-height property can make your text more readable, which helps everyone, but …

Leading agency institutional trading firm, based in Northern NJ, for derivatives seeks a full time developer to help build FIX capabilities. Candidates will be joining a team to define and implement FIX services for use in increasing the firm's electronic trading capabilities and to be used as market standards for …

what is the required t-sql for getting all the child categories in a parent category? my table is like this : id | name | parentid

Good afternoon all, I'm pretty new to VB.Net. Trying to get my head round using stored procedures to manipulate data in a database at the moment. I have managed to use a stored procedure (via my windows form) to insert data into a database but I am struggling to retreive …

I have 2 forms; one called frmLogin and another called user_info. On frmLogin I have a text box called USERNAME and a command button. When you click the command button the following code is run: [COLOR="Red"]This Code Works (Or atleast It should)[/COLOR] [ICODE]Private Sub Command29_Click() Dim strUSERNAME As String Dim …

Hi, When i change my function, change the return itens (when it returns a table), i lose grants that i had on it... Exemple: [code]alter function dbo.up_xxx (@cod_instc int) returns @teste table (cod_instc_usr int, COD_INSTC_prod int) AS BEGIN return END[/code] Is there a way not to lose it? Thanks

Here is what I am trying to achieve: I have an access database with a table [GroupTable] with 3 fields [RecNo, Group, SubGroup] (Group & SubGroup use integers) I want, under program control, to populate a table adapter with a subset of all records eg I want to be able …

Hi, im Uliseshz. I'm interested in learn more about Vb.net y SQLServer, and i hope you guys could help me in that... Well, see you around. Uliseshz

i have this code to check and make sure that I wont be inserting duplicate records into my table. i take whatever is in the dr variable and if it is 0 then I go ahead, if not I don't do anything with the variables, I am using Excel, and …

I have question about TRIGGERS. I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_TABLE and TRUCK_TABLE also. I need TRIGGER for INSERT/UPDATE/DELETE who well read value of VEHICLE_TYPE column in VEHICLE_TABLE and if value of VEHICLE_TYPE is CAR he will execute INSERT/UPDATE/DELETE on CAR_TABLE and if value of VEHICLE_TYPE …

sorry if this a very newbie question but what wrong with my code : [CODE=MSSQL]select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier where TBIn.SupCode=Supplier.SupCode and TBIn.IdBrg=Barang.IdBrg and TBIn.IdBrg = B002[/CODE] Please Help, Best regards...

Hi All, I m working on a vb.net application. Having a form with treeview & propertygrid control. My requirement is that I'll populate the treeview control from a SQL server table. I made this one. The next task is to populate the propertygrid from another sql server table by selecting …

Sir/Madam My website has three pages. The first page is a Login Page in which all the validation takes place and if the user is a valid one it directs it to the second page. In the second page i have given a link to the third page where onload …

Dear Frnds , I wanna match two files containg data One Containg (like 1000 pdf's) and another containg 1050(pdf's) 1.They should match similar pdf's and write remaing or extra pdf's in another folder. 1.data is with .mdb Format. anyone who can help will be appriciated. with high regards in advance …

I have developed an access database for my company and want this to be available to multiple users remotely from different offices. I have been told that i need to migrate to MS SQL Server. Is this the case?? If so how do i do it? If not what do …

I am currently using the visual studio 2005 express edition. I would like to upgrade to the 2008 express. So I would be using Visual Web dev 2008+Visual Basic 2008. These run on .net 3.5, at the moment there isn't an sql server 2008, would I be ok still using …

Hi friends, I have a list view which contains an id and a name.... upon selecting one row i should be able to view the details of that particular row.. i.e name, age, salary etc...Im using Visual studio .net 2003 and sql server 2005..

Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr fax_nr ---------------------------------------------------------------- 1 5 info@test.com 2 …

well im login in sql server through window authentication then wat code i should write in C# to write my connection string urgenttttttttttt

Hai, i am tried to use the SQL Server with Java and Tomcat 5.0 Application Server. I am using the JDBC Driver for Java connecting with SQL Server. I m using SQL Server 2005. But the JDBC Connection doesn't create. I have used the following code for java database connectivity …

I have created an application which populates a .csv file on the data-grid.When the user clicks a button a dialog box opens and the user selects a .csv file and opens it. The connection string that I've used is; "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"+filename+"'ExtendedProperties=text;HDR=Yes;FMT=Delimited"; When I run the program the error that I …

Hi, this is my first post. I have a website [URL=http://www.psychopanic.com]www.psychopanic.com[/URL] and theres an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL. …

Hello, I am writing a program that connects to a webservers db. I have a testing db on my local machine and i add a new dataset to this local db. I have tried to go into the app.config and change the connectionstring to a global variable i created useing …

i have a dataset [code] Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection) Dim ds As New DataSet query1.Fill(ds)[/code] how can i refer to specific column for example if i want to search for column QuestionNum=1 in table AnswerList …

Hi folks This will be my first ask for help here;) I'm working on a database at the moment and have exhausted my resources on this one. I have a report with an underlying muti-table query. The report uses an input box to set the date criteria rather than Parameter …

Hi pple I need help... How to retrieve data from a table in sql server 2005? I used databound for my dropdownlist in my web form. I hope my explanation is clear. Please help...advance thanks.. nandhini

Goodday all, Just tried to install MSDE, no sooner then i click the intall icon, i get this message "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." Now i took a …

I am using SQLEXPRESS 2005 and I want to call my function() from my Class.vb file into the stored procedure. Like I made this public function amount(Unit as double, Price as double) dim GetValue as double GetValue=Unit * Price return GetValue end function