[microsoft:sql-server] Forum Topics

hi, there, i need to know if the datagrid and dropdownlist will respond to the button click. At the same time, will this dropdownlist will get the data from database. Please help me. i need the solution in a day. [ICODE]<%@ Page Language="VB" MasterPageFile="~/Courier.master" Title="Untitled Page" %> <%@ Import Namespace="System.data.sqlclient" …

Hi there! I have the following SELECT Statment: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + ' ; ' AS "text()" FROM dbo.Autor A JOIN dbo.LivroAutor LA ON A.IDAutor = LA.IDAutor WHERE LA.IDLivro …

Hello friends, i am facing a bit of difficulty in designing a SQL query for calculating the total score of all the quizes taken by users in my quiz application to create a sort of leaderboard or ranking system. My table have following tables: UserQuizID (int) - PK QuizID (int) …

Hi guys i got a problem with this i can get data from the table by using sql :-Select * from staff_badgeTracking inner join staff_badgeTrackingNew On staff_badgeTracking.Badge_ID = staff_badgeTrackingNew.Badge_ID The point is if i wan to find a specific badge id like 1234 then it will get the data from …

Hi there! In my Library project i want to replace some text with images. I have this: [img]http://img33.imageshack.us/img33/8425/antesx.jpg[/img] Wich is generated by the following code: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + …

m developing a desktop apllication. in this application m capturing image from webcam directly and picture is also displaying .now the things is i want to insert the picture available in picturebox to database(sqlserver 2005)in binary type. can anyone pliz provide the code for this.

Hello I am a newbie with MS SQL and PHP. So if you could help it would be much appreciated. I connected remoteley to a Microsoft SQL server 2005 database with PHP. I have to call a procedure (A) wich calls another procedure B within it. How do I get …

hi all, kindly help me experts. i am in hurry to finish my report. i am using vb.net 2005 and sql server 2000 1. i have two tables which has no link 2. i try to show fields of both table in single report page 3. so i used two …

Hi guys, i have this point of sale application which i did using VB6 n SQL2000. my question is can i migrate my mdf n ldf files which was created in sql2000 to sql 2005 or 2008. i need advise. Thanks

Hi guys i'm writing a vb program which got using the sql statement i know the sql statement is using method insert but my one is much different. The code concept is like this If cmbActive= true then sql=insert into staff_badgeTrackingNew = txtEmpID, txtEmpName, TxtID Else sql= insert into staff …

Good Day all I have an SP that is defined like this [CODE]ALTER PROCEDURE [dbo].[sp_Constraints_Update] @xml ntext, @TTBLType varchar(5) AS set nocount on DECLARE @xmldoc int DECLARE @sql varchar(8000) -- In one long sql string do all of the following --Create an internal representation of the XML document. EXEC sp_xml_preparedocument …

Hi guys i dont know why i can get the datas from the sql 7.0 Can help me check this code>>> [CODE] If txtFBadgeID = "" Then Exit Sub Else sql = "select from staff_badgeTrackingNew INNER JOIN staff_badgeTracking" End If Exit Sub Set rsTrack = New ADODB.Recordset With rsTrack .ActiveConnection …

Hi Guys, I am doing a simple backup of sql server database through VB.NET form. It gets executed well but I want to display details of successful query execution in a label (i.e. time taken, database size etc.) The message which I want to display in label is like [B]"Processed …

Hi, I have a createuserwizard on my page which is driving me mad I am linked to sql server. What happens is that when i enter the username which i was trying previously it says choose another username but the thing is the username does not exist in the database …

help! i have a gridview with checkbox item template. On confirm button click, it will insert the selected rows into the database. But, when i close and run the application again, i want those rows which was previously inserted to the database to remain checked. Means that on page load, …

I use the following code to make a rule and use it for my PHONE column: [code]CREATE RULE phone_rule AS @phone LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'[/code] The problem is : When I run this code nothing add to my "Data Type" drop down box to set my PHONE column data type to …

hi all, i m working on a project(Inventry System) in which i have to update stock frequently. i have created a trigger in SQl for stock updation. if i insert for a particular product in stock table the previous quantity and the current inserted quantity must be added. Plus i …

do anyone knows how to connect to a MS SQL server(database in internet,i have ip,db username and db password).i used mssql_connect from my PHP ,but how to activate it in windows or Ubutu.i download all dll files needed but i cant connect..pls help me....

how can i connect SQL(local server) to VB6?? Please give me the STEP BY STEP PROCEDURE.. i dont really have idea on how to connect SQl to Vb6

Good Day all I have a Sp that is written like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Import_RegistrationsXM] @xml ntext AS set nocount on DECLARE @doc int EXEC sp_xml_preparedocument @doc OUTPUT, @xml TRUNCATE TABLE _RegistrationXM INSERT INTO _RegistrationXM SELECT * FROM OPENXML ( @doc , 'Import/Item' …

Hi people. I have a time and attendance module in VB6 which saves transactions (ADO) in MS-SQL if there is a LAN connection, and save it locally (MS Access) when offline. The trigger is when someone logged in. This is what I did: [Code] Set cn = New ADODB.Connection cn.Open …

Dear all, Sorry, if this Thread is wrong room :$ . I want to return a field value from a table, so I created a function like this : [CODE]CREATE FUNCTION dbo.CheckStatusTrx(@TransNo Varchar(20)) RETURNS varchar(20) AS BEGIN DECLARE @Flag Numeric(1) SELECT @Flag = Flag, CreatedBy, ApprovedBy FROM TrxTD WHERE TransNo …

ER Model: [url]http://img22.imageshack.us/img22/7292/modeloer.jpg[/url] I´ve got this: [IMG]http://img31.imageshack.us/img31/2384/antesj.jpg[/IMG] And want this: [IMG]http://img12.imageshack.us/img12/5241/depoispkd.jpg[/IMG] (Paint image.. lol) Anyone knows how to build a stored procedure who does that or a view? Thanks!

Hi, Im learning SQL and I've hit a bit of a wall early on.... I have these 2 statements [CODE]SELECT AcNum, FamName, GiveName, DeptNum, count(AcNum) FROM academic NATURAL JOIN interest GROUP BY AcNum HAVING count(AcNum) < 4[/CODE] [CODE]SELECT GiveName, FamName, DeptNum, AcNum FROM academic NATURAL JOIN department WHERE LOWER(state)= 'ny';[/CODE] …

Hi Guys, Kind of stuck on a query here. [CODE] select *--, c.last_name + ', ' + c.first_name as name from dbo.tblLevelOneApprover a inner join dbo.tblLevelTwoApproverToLevelOneApprover b on convert(int, b.level_two_emplid) != convert(int, @emplid) where convert(int, a.emplid) = convert(int, b.level_one_emplid) [/CODE] I'm trying to get all level one managers who are …

Ok i have this code to retreive data from a Table "Calendar" and the feild within the table are Id,Day ,Month and Year. When i press the button to run this code and i get the error message "The parameterized query '(@Day varchar(8000),@Month varchar(8000),@Year varchar(8000))Sel' expects the parameter '@Day', which …

I have created a search box which potentially works. But I wish to insert the results in to the text box rather than having them on the page. I've been working on this for literally 3 days but getting no where, please help. I have a text box and a …

Is there a setting to suppress warnings from dispalying when running a script via SQL Query Analyzer? I would like to have only errors print. Thanks!

can anyone tell me the differnence between sql 2000 and sql 2005 ....scarp me or send me the link or material ..it will be very useful and very urgent also

Hi, I wrote a query statement in SQL server to take paramaters, and generate then run a sql statement based on which criteria were provided. The tables got pretty massive so I need the query only filter when the value to filter on was provided. When I tried to bring …

I have created a database using MS SQL named "Company" and there is a table named "Employee". I need to print the records from the "Employee" table to a JTextArea keeping tabs for each columns in the JTextArea. How can i do it? Please help.

Hi to our community! Just want to get some idea regarding the connection setup of SQL Server 7.0, I've been doing an application written in VB6 and I used SQL Server 7.0 as a storage of my database. On my local pc I can successfully connected to SQL and manipulate …

hello evryone. please someone help me. I want to load the data frm sql server database at the button click...how to load the data using resultset rs.getString("column name") in the <option></option> tag using JSP codes??

hi, i'm using VS2008 and used the database wizard to make sure my database table and dataset datatable match. I used following code to transfer data from my windows form to my dataset then database. I keep getting an error saying "Invalid Object name 'Housing'" and I cant find the …

Hello, I have two tables aspnet_Membership and aspnet_Users. I want to remove all of the records from [B]both[/B] tables that are older than 30 days by using a single stored procedure. So far I have this: [ICODE] BEGIN BEGIN TRY BEGIN TRANSACTION DELETE FROM aspnet_Membership WHERE CreateDate < DATEADD(DAY, -30, …

I have a aspx page written in Vb and one of my button_click events has a function to connect to a sql database and retieve the data of a specific record by using the sql statement "SELECT * FROM Calendar WHERE Day="27" " The Name of my Table is Calendar. …

hi there. i write a project using VS 2008 and Sql 2005.now i want to deploy it and make its setup.what should i do for sql part?it's too big to install this mass(Sql) on user system.i heard i have to use sql engine? is this true? if yes,what's that? and …

Hello, I'm wondering if there is a way to retrieve the identity value from an identity column before saving a new register. When I run this query: "[CODE]SELECT IDENT_CURRENT ('alpa_Animais') AS AnimalID[/CODE]" directly using the SQL Server Management Studio I get this value. Does anyone know if there is a …

OK, so I'd like to play around a bit with learning how to initialize and use microsoft SQL server compact, but I have no idea where to look for the material. I did a quick search for database howtos, but I only found stuff with what seemed to be advanced …

Hi guys can you all help me with this. I need to sure will the this idea can be make in vb6. I have a update command button. When click then type the badge id , it will automatic get the data and show the employee name then the rest …

Hello Everyone, I'm quite new to Linq and have had some problems updating my dabase. I don't know if it is actually happening for be using a global data context or I'm missing something. I have my typed DataContex and one Static Public Var to initialize it located within the …

[code=c#] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace stp { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False"); SqlCommand …

i have a problem.. please help me..I have only one combo box and i want my combo box to have its value and i want to get it's value from my database??? how can i get that?? please help me to do this. thanks. here is my code please help …

I have one table in this format: [ICODE] Product Component --------------------------- A part1 A part2 B part1 B part4 A part3 C part5 D part1 [/ICODE] now I want to display product which components meet requested items, for example: I know component are "part1" and "part3", need to show product …

Hi guys i cant open the mdf on the ms sql express 2005 why this will happen it is another ways to open it.

hey guys, I've just got sql server installed in my system but i dont know how to start it. There are 3 options when i click on "Microsoft SQL Server 2005" in the programs namely: SQL Server Configuration Manager SQL Server Error and usage reporting SQL Server Surface Area Configuration …

How to retrieve data from database to frontend, each field in diff txtbox #1 1 Minute Ago | Add to Haimanti's Reputation | Flag Bad Post hi Hi i'm new to coding, with basis of theritical knowledge, i tried writing code for data insert n retrieval.. the code i posted …

Perhaps someone can help me here, I have a method that I am trying to accomplish two things 1. Retrieve a table from a stored procedure passing it one variable 2. Downloading that table in csv format I am not sure why this method is not working and I am …

Guys, I need Help in making PHP APACHE and MS SQL SERVER 2000 to run. I search a lot but still can not get the logic behind it. All that I understand is that I need to configure something in the PHP INI. Is it possible in XAMPP? or I …

hiii i am using the following functions in javascript to dynamically add and remove rows from a table... [code] function addRow() { //add a row to the rows collection and get a reference to the newly added row var newRow = document.all("applications").insertRow(); //add 3 cells (<td>) to the new row …