[microsoft:sql-server] Forum Topics

Group, The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected …

hey every body , i need to know how i can create an automatic back up for my database step, i am using sql Enterprise server 2008 R , what i need is the steps of how to do thats and how i can check if the job start or …

Good day, I want to get the latest value of the newly inserted record in my label.. The value that i want to get is not the primary key. Here is my code . //for saving _patientInformation.firstName = txtFname.Text; PatientInformationBL _patientBL = new PatientInformationBL(); if (_patientBL.addPatientInfo(_patientInformation) == true) { lblMsg.Visible …

I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field 'Players must be over 16 years of age' So how should I validate this. my table name is : Players field name is DOB and the datatype is 'DATE' I tried …

How to find email address format(@) in word or pdf files stored as binary file via indexing in sql server 2008...I am able to retrieve files with keyword search using sql where contains query,...How to find email address format in stored binary files via indexing..

How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? i have used this function datediff(ss,grn_date,GETDATE()) . this function gets the jobs done how ever if the diffrence btw the dates is huge …

In my project i want to create a database through my application, how can create new database using sql statement.( i.e create database...)

how i can make the relation ship in MS SQL ?

Hi All! I have 3 tables: test1 id name1 1 value1 test2 id name2 1 value2 test3 id name3 3 value3_01 4 value3_02 I want to display all records of table test1 with values of table test2 (test1.id = test2.id) and values of test3 (if test.id match with test1.id) - …

I have a table named Machines with fields: MACHINEID, MACHINEName MACHINECode, FACILITY where MACHINEID is a primary key. And i like to create a general stored procedure that does ADD, EDIT and DELETE operations and after updating i want the old record to be kept. How can i do that?

Having this error appear when I hit a button in a gridview to unlock a user. The description with the error is Description: For security reasons, the identity 'IIS APPPOOL\ASP.NET v4.0' (under which this web application is running), does not have permissions to create the App_Data subdirectory within the application …

I'm trying to do my Computing coursework, and every time I try to write an UPDATE statement in SQL, it tells me there is a syntax error in the statement. The connection is set up, I know, as other SQL statements like select statements work, but I can't work out …

Hy all, I'm new at using sql server compact,so I don't know yet if what I want to do is possible:)? I have the following setup: 1.Datatable created from a table from my database(this is the table that I want to update later); 2.Make modification on datatable and save it; …

Hi Friends I got lots of help from you all for diiferent types of problem. I am making a project using C# , SQL SERVER 2005 and Crystal Report. I already developed the project but problem is I have to deploye it on other computer. So how can I make …

A lot of questions in the VB.NET forum are database related. Most of the code that gets posted result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't describe the nature of a SQL injection because it is easily looked up via google. …

Hello Group! I've created a fairly large database with approximately 170 columns. I now want to begin writing data to that database table and saving the data. I'm using a form I'm calling "frmInventoryMasterSetup". I've also created the individual textboxes that I want to link to the columns for saving. …

In my database there two table call sample and sample customer in sample table primary key is sample_Note_no and it is a foreign key in sample_customer table I got same error after I wrote this coding also ALTER TABLE Sample Customer ADD CONSTRAINT FK_Sample Customer_Sample FOREIGN KEY (Sample_NOTE_No) REFERENCES Sample(Sample_NOTE_No) …

Hello. I'm Having this problem since yesterday. My professor wants us to create a VB.net Program connected with MS SQL. The problem is when i put my VB.net Project to other pc, i need to change the current connection String. Currently im using this code for my Connection String. Data …

Hi All, I have the following statement which is intended to have a Year over Year Percentage change: select CurrYear.Variable_Date,CurrYear.Variable_Value,cast(100*(CurrYear.Variable_Value-PrevYear.Variable_Value)/PrevYear.Variable_Value) AS Percentage_Change from dbo.tblCPISC as CurrYear left outer join dbo.tblCPISC as PrevYear on year(PrevYear.Variable_Date) = (select MAX(Variable_Value) from tblCPISC where year(Variable_Date) < year(CurrYear.Variable_Date)) order by year(CurrYear.Variable_Date) For some reason, I …

Good day, I just want to ask how could i start to create a simple database using SQL server 2008. I have all the employee images that was on the folder, if i create a table for let say employee table. All i want is to create a link or …

I'm planning to develop a system that can connect through online sql database and a website connected on the same sql database.. Can anyone help me.. Please response..

Hy all, I have the following problem with an update in my sdf database.I want to update a table data using a sqlceresultset.This is the code that I'm using but nothing happens. connection.Open(); string sql="SELECT * FROM Table1"; SqlCeCommand cmd = new SqlCeCommand(sql,connection); cmd.CommandType = CommandType.Text; SqlCeResultSet rs= cmd.ExecuteResultSet(ResultSetOptions.Updatable|ResultSetOptions.Scrollable); IEnumerator …

Good day people! I have a problem with my C# window application. I can't insert new record to database. I have sought for many tutorial in ADO.net and Entity Framework. I have been tackling it in Entity Framework because that is my preference. My piece of Entity Framework code would …

Hi to all, I need to install my own application to an another server,I change my coding to client server name,USerid,PAssword,Etc..But if i run : it will shows an error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may …

hi ihave create simple stored procedure for test in sql server 2008 studio then i run it inside sql query : exec test it gives me red line under test (strored procedure name) and when mouse come over it tolled me "could not find stored procedure test" then i go …

Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there …

hi i have create database with tables using sql server 2008, having table named 'Users' i have create this stored procedure : USE [Licenses_DB] GO /****** Object: StoredProcedure [dbo].[InsertUser] Script Date: 02/17/2013 23:25:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[InsertUser] @ID int , @userName NVARCHAR(50), …

Hi, I have a problem that in a database (named DDS) i can change or delete records in all tables but there is one which i can't. There isn't any primary or foreigh keys(There is one dependency, a view). So could you please tell me that is there any way …

HI TO ALL, I get this error:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.When Running my vb6 module on Another server SQL Server is installed on Windows Server 2003,and i am testing the application from WinXP and Win7 on my server it will work. Testing from other machines(Server) with …

i am making an inquiry kiosk for a certain company and it required to be on a network, with sql server as backend database. is there any way that i can connect to the database which is on the server and fetch data?

Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January …

Hi when i connect the sql server 2005 it will display this kind of error. `An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow …

Hi All, I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value' but the output still has the 2 decimal places which are 0s and pointless in …

hi i am writing a report, it must have parameters ToDate and FromDate,now the thing is i did all that but it stllrespond with just headring no data. Please help what am i doing wrong

Hello! I am currently developing a web interface that has access to an MS ACCESS database. However, I am unable to key in more than 6 Values into the database using the INSERT INTO sql code. Here are the codes that I am using: protected void bnAddPart_Click(object sender, EventArgs e) …

Ok I know many of you already done with this sort of situation i have a form which have few fields and on submitting that form i want these field values save into two tables. Both the tables contains a primary key and foriegn key. Let table one have id …

I want to make the closing balance of the current month lets say of March to be the opening balance of April in sql or crystal reports how to i go about it. Help need the solution agently please. the script below is the one i have used to get …

Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …

Hello i have a problem on connecting my database. i have this kind of code which would get the item in the combobox and use it as my connection Dim ConFunnelLocation As String = "C:\Database\Funnel\" & Form_Funnel_Report.Combo_Funnel_EBU.Text & ".xls" and a table Dim TblFunnelCon As String = Form_Funnel_Report.Combo_Funnel_AM.Text & "$" …

hi Actually i am trying to do a task given by my lead.First in a form i have grid view i have loaded my database content in that and i have a combobox there i have loaded my one column of my table in the combo box .so i have …

Hi experts, kimangel is here again, doubling my time. Thanks alot for helping. I have problem with two tables, when I click cmdSearch button searching for Employees_IdNo error occur "The specified field 'Employees_IdNo' could refer to more one table in the FROM clause in your SQL statement. below is my …

i am doing an application at school and i always have this error message: Cannot open database "users" requested by the login. The login failed. Login failed for user 'SERVER\Student'. what is the possible solution for this? thanks :)

Hello, I had a very peculiar problem today which I am sure hundreds would have had and solved before. I have developed a VB.Net + SQL Server application and installed it in a few dozen places. All worked very well. Then I installed it in a persons computer in Middle …

I have two tables Employer Employee Employer Table: I have one field EmployerID (pk Key assigned to it) Employee Table: EmployerID(pk Key assigned to it) IDEmployer(fk key assigned to it,and Allow Nulls:Checked) Now my question is how to relate two tables ,that I will now that who works for who? …

hi i am an intern i am given an assingnemnt to have server A updated by etl but now we need server A to update server B everday morning so that the two servers will have the same info, server has more than 10 tables and fact tables i need …

I want to develop a simple application which runs on single computer (just runs in one mechine) and did not need network. Program has to store some data in database and show them for printing. I have no experience with real-word program so I confused here: If the program is …

hi every one, iam try to build aconnection to sql database using sql string inside my c# class, but i cannot use ConfigurationManager i donot know why ? iam beginner in c#. i have read in enternet, i need Configuration Manager dll file but it doesnot work with me. what …

How to delete duplicate record in sql serer plz suggest me............ thanks

Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strsql As String = "Data Source=.ITSupport;" & _ "Initial Catalog=Information;Integrated Security=true" strsql = " insert into table_1 (name, address, age ) values ('" _ & txtname.Text & "','" _ & txtaddress.Text & "','" _ …

Hy all, I'm facing a problem with some data that I need to check and update it's status in my database.I've got a data grid with some info from a table in the database..now for evry entry I send that data to a server server then I get the server …