[microsoft:sql-server] Forum Topics

Hi , I am newbie in C#. I created a database by right clicking on the project in solution explorer and by selecting add new item then selecting database. Database name is SAMP and it has a table called Account. can somebody tell me how to connect to this database …

Dear Friends, I have an excel VBA project which needs to be implemented into VB -6 with backend SQL server. The CITI & Chase bank statement can be downloaded in excel format and the macro file could capture the required data from respective bank statements. I am not sure how …

Hello, I have question about backup and restore procedure for MS SQL 2000. If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. …

I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date …

On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box Please help me in setting focus to that particulat text box. [code]Private Sub Form_Error(DataErr As Integer, Response …

Hello, I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I …

hi guys, i'm trying to connect java application to SQL server 2005 developer edition, i used the following code which comes with the microsoft jdbc-odbc driver 1.2, after that i modify the class path to load sqljdbc_auth.dll file. import java.sql.*; import com.microsoft.sqlserver.jdbc.*; public class connectDS { public static void main(String[] …

Dear Sir/ Madam I would like you to help me as below: I want to create a project for manage student information and i have one table store student information in the table have student ID, Student Name, Address, Photo.... and i want to insert student information with photo and …

Help I want to learn how to connect SQL to my java program? is there any free online tutorial? help my please..

I have problem while loading crystal report in c#.net window application.Each time when report is to be generate it asks for login information to connect to MS Sql server,which i have assigned during adding cyrstal report in my program.Please help me in this matter .its urgent too.

hello all i am facing a problem when i try to add new records in to data base. first of all my tech details are given below Front end - vb 6 Back end - Microsoft SQL Server 2000 i am connecting to sql through ADODB connection ( through code …

Hi guys. Jerry Davis here. I am a married father of two baby boys, and I have some major motivation to become a master SQL guru. Wife stays home and takes care of our kids, so my income is it. I have a decent technology back ground, but have been …

The following query: [code]CREATE PROCEDURE GetDistance AS SELECT a.ZIPCODE, a.CITY, a.STATE, ROUND( (ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) ) ) * 3963,1 ) AS distance FROM Zipcodes a, Zipcodes c WHERE ( ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) …

Hi Everyone, I am new to ASP.NET, i am currently doing a project. I'd like to create a log in page using code. please assist. Some one give me a code sample of a log in page. Including connections to MSSQL database. I am totally lost. A step by step …

hai friends, this is kranti, i am getting one error while i am using the sqldatasource control and dataview control it gives error on the browser like this " invalid object name "emp": please tell me the how to use the sqldatasource . ASAP please....

Hi all, I am using asp and vb and back end is SQL . I am getting syntax error in update command. Error is Incorrect Syntax near keyword "desc". Can anyone debug this. R can you tell me an alternative way to update record in database. I have to check …

good morning, i was recently joimed as DBA. so i want to know regarding dba. can u help me

I am an amateur when it comes to Advanced SQL but here is the situation. I have a Test Table with data such as below: Name(char) Qty(number) Date (char) Location (char) Test1 1 11/14/08 10000 20050 Test1 1 11/14/08 10000 20100 Test1 1 11/14/08 10000 20000 Test1 1 11/15/08 10000 …

What is the best way to go about making a program that will have to save information like a database, but I don't want it to have to use a outside database, I would like the information to be embedded in the program possible. Or are there any other ideas? …

Hi, Im using ASP.NET and SQL Server. While inserting the data at run time. the same data , what ever is already in database is being stored again. Say for example, i have empname and empno, "Mala" and 123 already stored in database, if i give new data "Bala" and …

Hi all, I have a server in our network contains the database of the project (SQL Server 2005). Suddenly a developer computer couldnot connect to the database which in that server. and now another computer did the same. The strange is the designer computer which still connecting to the server. …

Okay heres the dilemna.... I have a Dataset("LineItems") that Stores information about so many records. To source to this DataSet("LineItems") is not its intended ouput. Meaning I pull this info in from one database and output to another. My problem is i have no idea on how to write an …

i need help about COMMAND and PARAMETERS Object in ADODB in Visual Basic 6.0>>>> i have some code that uses command and parameters object. ADODB connection is connected to a access.mdb file. all parameters are constructed in a stored procedure in sas.mdb before. I've declared more than one parameters in …

I use the tipical conn in ado to connect on sql. MY prob is to find fast a string in a field (have 165.876) record. With this condition: Is the string is found in field then call sub1 else call sub2 end if

Hello Group! Its been about 5 years since i have messed with SQL. I'm creating a database for a simple .xls that will be searchable. Here is a exmple row of data: Make:ACURA Model:INTEGRA Year:1990 Engine: L4 Edition: GS Trans Cooler: x=true Oil Cooler: Horse Power:0-400 Comments: Part Number:9E-HE790-01 Tube …

Hello, I have an application that uses BLOB for files in MSSQL 2000 database. I do a full backup once a week and transactional backup everyday. Does transaction backup includes BLOB? If I restore transaction backup is it going to restore BLOB as part of the table. Thanks, DC9

Hi there, I'm wondering whether one of you could clarify how to define the maxlength in bits when inserting a parameter in a stored procedure f.ex. What I might do is something like this: [Microsoft.SqlServer.Server.SqlProcedure] public static void CreateUser([B]SqlChars pInitials [/B]... ) { SqlCommand mSqlCommand = new SqlCommand("", new SqlConnection("context …

Hi guys.. Please guide me for the database connectivity with sql server express edition 2005 for any website.

Hi Friends [COLOR="Red"]Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.[/COLOR] I am getting the error while Select the Data... How to clear this type of errors.... Any one Help Me

Hi Fellows, Well. let me start by higlighting the problem i face.I have two columns namely PID which is the primary key and also a auto number.The second is Serial No. which is also a auto number. The problem i face is that when i submit my form spcifying a …

hi I am new in SQL Scritpting and my question might sound stupid, but please help me out to understand. Can one explain the difference between the two and similarity? The need and and use of the two? As for Temporary table does one create them or it comes with …

Hi Guys, I have some confusing part in the sql command the question is i have 2 different query : a)[code=sql] Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID[/code] b) [code=sql]Select Sum(Amount) as Total FROM TABLE3 [/code] the result if a) query is 100 …

can you help me assign sql query to gridview..i am trying like this but it doesnt work. [CODE] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim con As New SqlConnection("Data Source=SPERANZA\SQLEXPRESS;initial catalog=master;integrated security=true") Dim cmd As New SqlCommand Dim dr As SqlDataReader cmd.Connection = con con.Open() cmd.CommandText …

getting value of return value of stored procedure to code behined,with MicroSoft Patterns and Practices. Hi all, I am using Microsoft Patterns and Practices to make a database connection to my application. I am able to get the value of the OUT parameter of the stored procedure to code behind. …

Hello Friends, I'm facing a problem now that is i have some THAI language data in SQL Server 2000. The problem i don't know how to retrieve this data to variable and i don't noe the variable should be what data type? such as string or others? Have any one …

Hi, i have been wasting to much time i don't have trying to figure this thing out and hope somebody can help. I am making a project for school in VB.NET. I have SQL SERVER 2005 installed on my machine. I can access the database just fine thru Visual Studio …

I have questionnaire that has two radio buttons(one is "Register" and the another one is "Drop") in it and all answers are saved in an SQL database. For Example ,when the user checked "Register" and then by clicking "Sumbit Page" the values stored in the sql database.When the user returns …

I fetch the data datafrom database in to a datatable and bind it to a datagridview.Now I want to edit the data shown in the datagridviewand also want to add new rows in dgv.The editing part is going ok but I m not able to add new rows in dgv.Also …

I am trying to work on this work in the VB.NET book in this chapter called " Accessing Database Files." the instructions call for a DataGridView control on the form and to click the smart tab arrow. When selecting add project data source from the drop down, it activates the …

i am working on webappliactions.our next project is windows appliactions...they wont give any training and all..i just want to know the difference between webapplications and windows appliactions? what are method will be change compare with webapplications? 2. same as difference between asp.net2.0 and 3.0 3.main difference between sql 2000 and …

[code=cplusplus] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } static SqlConnection cn = new SqlConnection("userid=sa;password=;database=northwind;server=localhost"); SqlCommand cmd = new SqlCommand("select * from kkr", cn); SqlDataReader dr; private …

I am writing a program using the MS Sql compact edition that get embedded in the program for my database so I would like any tips for using that if anyone has any good ones, I'm a VB novice yet. What I am wondering with this question is I would …

I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA.

We have a system where analysts can upload various financial metrics about a stock from Excel to SQL2005. Multiple clients use the system and each require collecting differing metrics. Currently we have all of the metrics as columns in a table. Each client obviously has a different table structure. Not …

HI! I've got a problem... Given the schema below I need to create an SQL query, but for some reason I think there is something wrong with it.... BRANCH(BRANCH-NAME, BRANCH-CITY, ASSETS) Query: in what cities are the branches where the maximal bank assets are less than £200,000? So I've come …

I have a problem in my SQL 2005 Data Warehouse. I'm using a slowly changing dimension data flow transformation in SSIS which will not delete any records from my DB when they are deleted from the source data. I need to keep the dimension keys, but in this one case/one …

Hello Everyone, I've a problem with java & SQLServer 2005 interface, i installed a SQLServer 2005 and SP2 software bundle to enable SQLServer to run on Windows Vista, i'm using the "Windows Authentication" in SQLServer 2005 which don't need the username or password, and i've the classpath to jar archive …

Hello everyone, I'm a beginner with databases and I'm trying to do some homework. I'm writing down the exercise and I'll be putting what i've done so far replying this thread. I'd appreciate if someone could help me saying if I'm in the right way or how should i do …

Hi All I have a select statement: [size=2]Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1 Now I want to store / retrieve the values of the field that I am querying without using dataset. Is this possible? If yes how can I do this? Is it possible that I declare …

Hi everyone, Pertinent info: SQL Server 2005 Visual Studio 2005 I am having a major problem with my C# application when inserting about 250 records into a table. The entire table is locked and no other user is able to update a record. Any idea on how I can prevent …