[microsoft:sql-server] Forum Topics

is there any way to backup an sql server 2000 database using the front end (Vb6) ...... Had been it in Access itz even possible via save as dilog I ve done it but sql 2000 is a problem

Hello! I'm setting up a simple webpage, and I need to have a seat-reservation system. I envision a site with many square boxes that is displaying seat number, and the color green or red if the seat is free or reserved. When users click on a red box, it comes …

Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in …

Hai, I Have an sp like this: [CODE]ALTER procedure [dbo].[SP_ClassInsertion] @ClassType varchar(50), @ClassTypeId varchar(50), @ClassName varchar(50), @SchoolId varchar(50), @ClassID varchar(50), @BatchId varchar(50), @Userid uniqueidentifier, @ClassCategoryId varchar(50), @SchoolClassCategoryId varchar(50) as declare @STATUS int begin if exists(select Class_Id from SCH_Class where Class_Name=@ClassName and School_Id=@SchoolId and Is_Valid=1) begin set @STATUS=0 end else begin …

NOTE: If this is too long, scroll to the last paragraph where hopefully I've summarized my problem. I have a simple problem. I have two tables, one is for the "header" and one is for the "details" of the header. I need a view to return all details and the …

Hi, 1. Just am created a user for the login 'test'. 2. As with this login 'test', i logined to the server. 3. I don't have the permission to create the database. 4. So i tried this query: [CODE] use master grant create any database to user go[/CODE] 5. Am …

Hi guys i hm havig problem....My Code is [CODE] <?php $conn = mssql_connect("FARHAD-PC\SQLEXPRESS","",""); mssql_select_db("Testing",$conn); $query = "select * from User1"; echo $query; ?> [/CODE] The error iss Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\Testing\SqlConnection.php on line 4 Hope someone will help me.. Regards.. Farhad

I'm using Visual Studio 2010, Win 7, MS Access 2010, C++, Direct ODBC, 32 bit. The first SELECT statement executes. The INSERT, SELECT, SELECT and UPDATE statements don't nay help is appreciated. Thanks. [CODE] #include <windows.h> #include <stdio.h> #include <sqlext.h> const char* DAM = "Direct ODBC"; SQLCHAR szDSN[256] = "Driver={Microsoft …

Guys, I have those records. how to i removed the first 10 records and the last 2 records(-U)in string. P300-1110-C731-U P300-1110-INCREDIBLE-U P300-1710-DEVOUR-U P300-1710-DROID2-U P300-4410-THUNDRBLT4G-U P333-4110-8530-U Here is the correct Result: C731 INCREDIBLE DEVOUR DROID2 THUNDRBLT4G 8530 Thanks in Advance. Jonel

hi , I have database 'center' with huge data and wanted to create a dummy 'test' database for 'center' db with 1000 random data for testing purpose. I generated script to copy the db but the resulting 'test' db was tables without data. i need 1000 samples for all the …

I m running the Sql job as background thread and at the same time showing data from sysjobhistory table in gridview. While debugging the code its shows the data in old and new rows affected from table in gridview but when i put the application in debug or release mode …

Hi I have a database of one table with headings as shown DONOR COURSE TITLE START DATE END DATE MIN/DEPT ANNOUNCED TO DATE RECEIVED BY HRD DONOR DEADLINE DATE FORWARDED NOMINEES BENEFICIARIES-MALE BENEFICIARIES-FEMALE NUMBER ACCEPTED REASONS FOR NON-ACCEPTANCE DATE OF ENTRY NATIONAL COUNTY The table is in access. I would …

[CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim asm As String asm = ComboBox2.Text cmdOLEDB.CommandText = "SELECT * FROM sale " cmdOLEDB.Connection = cnnOLEDB Dim ab = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") Dim dr = cmdOLEDB.ExecuteReader Do While dr.Read v1 = dr.Item("NAME") If (asm = v1) Then pa …

I have a REPORT WITH 10 SUBREPORTS, I have 2 Parameters in the main report and links the subreports to these parameters. my code looks like this: [CODE] Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Configuration Public Class CR Public Sname As String Public Dbname As String Public Uname As …

I have 3 tables in MSSQL 2008 (ABSTRACT) [INDENT]tblContacts: [/INDENT] [INDENT][INDENT]ContactID: Auto Numbering Int[/INDENT][/INDENT] [INDENT][INDENT]FName: string [/INDENT][/INDENT] [INDENT][INDENT]LName: string[/INDENT][/INDENT] [INDENT][INDENT]Address1: string[/INDENT][/INDENT] [INDENT][INDENT]Address2: String[/INDENT][/INDENT] [INDENT][INDENT]City: string[/INDENT][/INDENT] [INDENT][INDENT]State: string[/INDENT][/INDENT] [INDENT][INDENT]Zip: string[/INDENT][/INDENT] [INDENT][INDENT]ContactType: int[/INDENT][/INDENT] [INDENT]tblStaff:[/INDENT] [INDENT][INDENT]ContactID: int[/INDENT][/INDENT] [INDENT][INDENT]StaffID: AutoNumber Int[/INDENT][/INDENT] [INDENT][INDENT]Title: string[/INDENT][/INDENT] [INDENT][INDENT]Unit: string[/INDENT][/INDENT] [INDENT][INDENT](etc)[/INDENT][/INDENT] [INDENT]tblMembers:[/INDENT] [INDENT][INDENT]ContactID int[/INDENT][/INDENT] [INDENT][INDENT]ApplicationDate: string[/INDENT][/INDENT] [INDENT][INDENT]Membership Date: date/time[/INDENT][/INDENT] …

here's my code; [CODE]SELECT b.alert_id,cur.stock_code, current_name,d.board_name,cur.year_id, cur.period_id,cur.fixed_assets, prev.year_id AS prev_year_id,prev.period_id AS prev_period_id, prev.fixed_assets AS prev_fixed_assets, (cur.fixed_assets*100/prev.fixed_assets) AS "total1", c.para1 FROM company_financial AS cur LEFT JOIN company_info a ON (a.stock_code=cur.stock_code) LEFT JOIN company_alert b ON (b.year_id=cur.year_id) LEFT JOIN ref_alert_parameter c ON (c.alert_id=b.alert_id) LEFT JOIN ref_board d ON (d.board_code=a.board_code) LEFT JOIN ref_sector …

Hey guys, Alright I have a tricky assignment to do in a view that will enable my next program to run MUCH faster and more reliable... Now I need to list all Items (1 table) and their locations where they are stored (2nd table) in a way that enables 1 …

I am writing a code that will login the user then one they are logged in they will enter in other information in textboxes. I wanted to know how to check that the username, password and ID match what is in a sql database. Also once it goes through how …

Hi all, I need to run a query that performs a count(*) on a table. This gives me the subtotals for each group. Now I need to sumarize the subtotals with sum the results given by the previous count. What would be the best way to do this? Thanks.

Hi, any one please advise me if i used Stored procedure, in this only i declared one variable and set query(select query) in that variable and then i execute that query inside the stored procedure only. when i drag this stored procedure in my .dbml, it's takes int datatype and …

HI, I don't know how to get the lastest data form the database. do anyone can give me some exmaples to see how to retrieve the latest 50 data.

Guys, what particular drive/folder to stored the text/csv/excel file that the bulk insert will be reading? what if in my local drive is this applicable? or it should be in the shared folder in the server. Thanks, JOV

Hey all, Came across this site while scouring the web for a solution to my problem. All of the answers on here seem very helpful and non judgmental. That is hard to come by in a lot of programming forums, so thanks. My Question. I am using VS 2008 and …

Dear Friends Hi I have developed VB application which uses SQL Express. When We install SQL Express it is by default set to install Service Account = Network Service. But I want to create installer which should install SQL Express 2008 (With Service Account = Local System) and along my …

Hi, I have very simple project in vs2010 and mssql 2008. with only single page for example. when i run project its take too much time for loading.. when i change the value of radio button it will take some process. i use updatepanel also and autopostback=true radio button takes …

Can sumone please give me a helping hand here am trying to do a simple sql search were it will look all items in SQL database and pull up the names that match but am having a abit of trouble with it it brings all my accounts up regardless of …

I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will …

This is problem that I have struggled with for some time, but im sure the answer is very simple... I have a sub report that performs calculations on 2 fields ( [Rate] [Hours Worked] ) from a table called [Hours]. The report is GROUPED by [Rate] and is as follows: …

Hello everyone How can i get all the table names of database and display these table names using combo box. Or store the table names in an array . I am using sqlexpress and c#

I am trying to install sql server 2005 express edition from the visual studio 2008 CD. This is the error I get. [CODE] [04/19/11,00:56:13] Microsoft Visual Studio 2008 Professional Edition - ENU: [2] CMSIDirectory::SetDirectory - Invalid argument ***EndOfSession***[04/19/11,00:56:13] Microsoft Visual Studio 2008 Professional Edition - ENU: [2] CMSIDirectory::SetDirectory - Invalid …

i m using following query for inserting data into my database... everything is ok but whenever i restart my form there is no data in my tables :( do i need to use commit statement ?? if yes then how ? [CODE] Private Sub Button1_insert_Click(ByVal sender As System.Object, ByVal e …

i really don't know how to slove the erro in my program.. ..can you please help me?? thank you in advance ,.. [CODE]Public Class Form1 Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Dim da As New OleDb.OleDbDataAdapter Dim ds As New DataSet Dim sql As String Dim …

i am writing parameterized insert query uisng asp but get the following error --------------//error Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.line 34 -------------------- i have table in MSSQL column name (item_name nvarchar 20) asp code ---------- itemname=request.form("itemname") cm.commandtext="insert into …

Hi, I have database in mssql 2008. In that, I want to fetch Column names from table in array. Is it posible? Please give me some suggestion. Thanks in advance. Jack

I had a problem on displaying count sql in vb. Anyone would help me? I had google about this, and I had to use executereader but I don't know how to use it [CODE]Dim dso1 As Label = CType(e.Item.FindControl("dso1"), Label) If Not IsNothing(dso1) Then Dim name As String name = …

OK, here is what I want to really do: I need to write a single SQL query to do the following: select count(1) from TableA where [condition1]/ select count(1) from TableA where [condition2] One way of doing it is: [CODE] select (t.numerator/t.denominator) as ratio from (select (select count(1) from TableA …

I'd like to take values between a date range and enter into a table I have a date range @startdate and @enddate i'd like my user to enter the date range and then for the system to take the date range entered and insert them into a table, however, my …

some times i connect to the localhost via Windows Authentication and i loggin normally, sometimes i get this error and after i restart the problem solve, now even if i restart always the same error :/

Hi guys, am having an issue with a mssql query an running in mssql 2005 server. I have two tables debttable (customer, subcat, drugs, form, total, paid, date, balance qty and amount as columns) and debtsum(customer, subcat, total, paid, date, balance). Now since both tables have some columns in common, …

I have data in the column '4.00504572690003' when i use select round(4.00504572690003, 2) it gives 4.01000000000000 How can i achieve 4.00 from the same. I tried a lot but didint get.

Hi All As you know One of the new figure's of SQL Server2008 is that you can Define a table as a stored procedure parameter. So my question is that how cane I pass a data set to Stored procedure as a parameter in Delphi? Thanks

Hi here is the scenario. I am using Form View to insert data to the table. My table is MS sql server table of which all the columns are allow no nulls However, sometimes i need to empty values ie no value to the table column. Is it possible?

Hi All, I have a table which holds the values like shown below [ICODE]ID Col-1 Col-2 Col-3 FID 1 Good Yes Easy 101 2 Bad Yes Hard 101 3 Good Yes Medium 101 4 Good No Medium 101 5 Good No Medium 101[/ICODE] I want to have a query which …

hi am a newbie to the vb.net thing. am using ms access for my database. i have a customer table in my database where sutomer details like first name, last name, address, etc are stored. i've created a form in vb.net and i have a text box, a datagrid and …

Hi, i am trouble to connect with sqlserver 2005 in windows authentication mode which do not contains username and password it will give me an error like connection failed for user ''(blank) here is my connection string [CODE]string URL="jdbc:sqlserver:\\localhost:1433;dbname"[/CODE] can anybody help me please

hi frnds, i have a certain application in vs2008 with several windows forms.my question is that i have to mention connectionstring on each n every form as: [CODE]con.ConnectionString = "Data Source=mypc;Initial Catalog=Main;User ID=me;Password=pwd"[/CODE] Is there any way to define connectionstring for once for all forms and and one more thing …

I had using this code to show the alert_value in repeater. But it no output is shown in the column dso. I want to count the number of alert_value which is above than 150 which the alert id is dso. anyone can fixed it? [CODE]Dim dso1 As Label = CType(e.Item.FindControl("dso1"), …

Good morning, Firstly, let me say that I have zero experience with database, servers, etc. Now that I have prefaced this long question with that tidbit let me ask the most basic questions. What is the difference between MySQL and MS SQL? I think they do the same thing but …

Hello Everyone I want to create an online exam based web application using VS and SQL...I want to know how do i start I can create a login page but how do i store questions and answers in the database and produce them during the project execution???

Hello everyone I am making a simple registration page and i want to store values in database here is my code [CODE] using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; namespace PatientSystem { public partial class Registration : System.Web.UI.Page { protected void …