[microsoft:sql-server] Forum Topics

hello ! i am working on a single page of asp ,and i am using ext js 4.0 with it . i have a grid of extjs , my task is to show records in that grid from mssql server 2008 , for getting records i am using webservice . …

i am new to vb.net... my problem in this query is that "Format is not a recognized built in name" this Format() is an sql function right? is there a header file to call the format() function just like c++? can anyone help me with this? please! here's my query …

Hello Guys, I really need your ideas on this one... Ok, I'm only familiar with php and simple html coding. I'm designing simple book loan database. Consist of two sql tables (a very simple one) table 1 book_in table 2 book_out Ok.. Let say, every book is determined by a …

I want to take backup of my server database at my local machine........ how can i do this...... Thanks in advance

In my project, all my forms access the connection string from the login form which takes data from an XML file [CODE]Dim thisConnection As New SqlConnection(LoginForm1.cnString)[/CODE] now when i create crystal reports. i first select a viewer which calls the report via code [CODE]cmd.Connection = thisConnection cmd.CommandType = CommandType.Text cmd.CommandText …

sql SP ALTER PROCEDURE arunsss @suppid VARCHAR(50), @suppname VARCHAR(50), @dispname VARCHAR(50), @exists bit output AS SET @exists=0 BEGIN IF EXISTS (SELECT suppname from [supp] where suppname=@suppname) SET @exists=0 ELSE BEGIN if(@suppid is null) begin select @suppid= isnull(MAX(convert(int,suppid)),0)+1 from us.dbo.supp where ISNUMERIC (suppid)=1 end INSERT INTO [us].[dbo].[supp] ([suppid] ,[suppname] ,[dispname]) VALUES …

As I am new to Vb, I am not sure if this is even possible. i have created a program and now we are testing the maximum clients possible for the server.the thing is since, we are at the beggining stage, we come across numerous errors and so the person …

We are using C# as front End and Sqlserver 2005 as backend.We are using visual studio 2008. System.data.sqlclient is the provider for sqlserver in our localhost and our functionality is running correctly. But we are using bigrock as hostgator, where we uploaded our files and we get to know that …

I was hoping someone might be kind enough to throw some advice my way on this one. I am using stored procedures to perform many of the queries for my application. One of the reasons I chose stored procedures was for security. Because I would like to make the application …

Hi, So here's what I have, Ive got a Listbox which displays a data/record from a SQL database, it displays "Amount" and only numbers would appear. it has a datasource. Goal: I'd Like to get the total sum of those numbers from the Listbox and Display it to a textbox …

hi , i have made a login system which saves and chekcs the data from sql server. My login is working perfectly fine. now i just want to know how to logout from an application. can any 1 help. what functionality can i add to the logout. so that application …

hi every one i wanted to get some information on how to insert data into sql server through combo box selection. i have 2 values in combo box. 1 is admin and 2nd is employee. basically its an employee registration form. could any 1 help me if during registration the …

I have a sql table for storing unique e-mails.I need a stored procedure that could let a user that uses aspnet page to insert data know that the e-mail address already exists on a table and specify a new one. The table looks like this: EMailID int NOT NUL (1,1), …

Hi guys! I've been searching all day about this and can't find a solution.. I'm fairly new to VB and SQL Queries, so I apologize if I sound a little daft. Basically I'm working on a project in VB 2010 where a user can add new teams, players, also create …

hi every one i am trying to save data from vb.net form in sql server 2008 below is the code which i am using but the only problem is . i am not getting any error instead the data which is being saved in sql server in my First Name …

hello guys! anybody can help me this type of error in Login form. Im using combo box for multiple users thank you very much. Run-time error'-2147217865(80040e37)': The Microsoft Jet database engine cannot fined the input table or query 'login'. Make sure it exists and that its name is spelled correctly. …

Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2006 15-Jan-2006 15-Jan-2006 15-Jan-2006 16-Jan-2006 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, …

hi every 1 i am trying to make a search form . i want to display the data saved in sql server in a grid view upon hiting the search button . below is the code which i am using but i am getting an error > Conversion failed when …

hi every one. i am making a booking app in vb.net and im using sql server as my database. i am confused about table creation. I have increment of 1 in customerid which is primary key in customer table. Suppose if a customer books a room and according to the …

Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: …

I'm hoping someone can help me out with this. I have a datatable populated from an SQL Server 2008 database table. I created a DataAdapter with a commandbuilder to manage the updating, inserting, and deleting of records. The Updating and Inserting work as expected. However, Delete does not. The code …

Hello, I am working through an SQL Server 2008 book. I am to the query section. I have copied the query below, word for word (I believe), but the system is showing a problem at line 10. This is the first query I have tried to create. I don't see …

Hi all, Im running a update query like this to update multiple rows(about 1000). Example of query: [CODE]UPDATE DATA1 SET Column = CASE WHEN TIME = 0 THEN X WHEN TIME = 1 THEN y WHEN TIME = 2 THEN Z WHEN Time = 3 THEN Q END [/CODE] The …

Hi, Please help me out to get this issue solve. Am don't know, how to get the output. This is the way, i need. But i don't know. (a)select distinct empid from emptable where year=2011 order by empid (b)I needs to pass this empid with the while loop: while() { …

Hi guys well what I want to do is that when a button is pressed it increases the value in one of my database cells. So my question is how do I do this? As I cannot get this to work. My code so far: Any help would be appreciated …

SQL = "SELECT * FROM tbldes WHERE Category LIKE '%" & Replace(Trim(Text1.Text), "'", "''") & "%' ORDER BY category" rs.Open SQL, cn, 2, 3 use of this sign(%) anybody can explain me, what is the use of this code? br

I have Sql query consists of multiple tables in ms Access database(has Join Right/inner join) and I would like to insert and Update data on it using ADO.NET. I would be most grateful if someone could provide me with a clear example. Thanx

How can I replace only "North" in this following string when it is by itself? 'E NORTHCREST DR NORTH' UPDATE address SET streetname = REPLACE(streetname, ' NORTH',' N') This script changes it to 'E NCREST DR N'

I have to save 4 different pictures in my database. NSO, GoodMoral, ReportCard & TOR. Here is my code. [CODE] Sub savepic() Dim str As String = "My connection" Dim con As New SqlClient.SqlConnection con.ConnectionString = str Dim ms As New IO.MemoryStream() nsopic.Image.Save(ms, nsopic.Image.RawFormat) goodmoralpic.Image.Save(ms, goodmoralpic.Image.RawFormat) repcardpic.Image.Save(ms, repcardpic.Image.RawFormat) torpic.Image.Save(ms, torpic.Image.RawFormat) …

Hi, I am using a Dynamic SQL to create a stored procedure. The stored procedure is as follows: [CODE]CREATE PROCEDURE spRetrieveBalanceSheet (@Pfcode varchar(5), @period varchar(10)) AS BEGIN DECLARE @tablename varchar(12), @sql varchar(2000) SET @tablename='SALFLDG'+Upper(@Pfcode) SET @sql='SELECT S.ACCNT_CODE As Code, SUM(S.AMOUNT) AS Amount, A.ACCNT_NAME AS Name FROM '+ @tablename + ' …

hello! i am working on a Asp.net project using C#, now i want to connect mssql server 2008 using JS or AJAX , i am very new with JS so i have no idea where to start .can anyone help me in this . Regards M.Waqas Aslam

Hi I am trying to bind a list box with Video data from an sql query and use the selected url of the video in a session object posted to another page media player object. The problem is that i'm not sure why the session value is not being passed. …

[CODE]Dim connectionString As String Dim cnn As OleDbConnection Dim cmd As OleDbCommand Dim sql As String connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = d:\sprrg\scm\scm\sprrg.mdb" sql = "insert into mr_detail select job_Code,mr_no,item_code,qty,addl_description" cnn = New OleDbConnection(connectionString) cnn.Open() cmd = New OleDbCommand(sql, cnn) cmd.ExecuteNonQuery() cmd.Dispose() cnn.Close()[/CODE] I am getting eror as No value given …

[b][i]please help to connect our vb.net forms with database. I know make forms and connecting that forms.i know creating tables in database and inserting values in it.no idea about connecting forms and data base.pls help me.we use sql server 2008.i am a beginner in vb.net[/i][/b]

declare @suppid as varchar(50) if(@suppid is null) begin select isnull(MAX(convert(int,suppid)),0)+1 from us.dbo.supp where ISNUMERIC (suppid)=1 end

Cannot connect to x. =================================== A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 …

[CODE]Hi Forumer's kindly please optimize my query. I need to separate the colums for statusissue = 0 and statusissue =1 my query create double entry. ]--Sample Table Create Table #Table1 (Itemid nvarchar(10), Datephysical datetime, Statusissue int, Qty numeric(28,12)) --Sanple Data Insert into #table1 (Itemid, Datephysical, Statusissue, Qty) values ('HTC1175','2012-02-14',1,50) Insert …

hi to all vb6 and vb.net expert! i need help. i want to split the data from a text file and save it to the sql database. attached here is the .txt file and the format.this data is from a chronolog machine im thinking of using string token but it …

hello every 1 i am new to this forum i am having a lot of difficulty in giving privileges to login user. i am using vb.net and sql server 2008. What i want to do is i want to create an admin account . Admin will have all access on …

i have a problem with sorting this thing... i want to sort a column without changing the data in the other column. i have an attached document. a picture of my query and database.. tnx :)

Hi guys well I have a problem on my JFrame which is once I click on my List all Videos button it displays my data from my MS database which all works well. However as you can see from the png the query results are not aligned up correctly together …

[CODE]SqlCommand command = new SqlCommand("SELECT Id FROM users WHERE Username=@Username AND Password=HASHBYTES('MD5', @Password)"); command.Parameters.AddWithValue("@Username", pieces[1]); command.Parameters.AddWithValue("@Password", pieces[2]);[/CODE] doesn't return correct result [CODE]SqlCommand command = new SqlCommand("SELECT Id FROM users WHERE Username=@Username AND Password=@Password"); command.Parameters.AddWithValue("@Username", pieces[1]); command.Parameters.AddWithValue("@Password", pieces[2]);[/CODE] returns correct result, however the data in mssql database has to be not …

Hi , I have 2 columns named 1. Tel_H 2. Tel_H_Code How can i merge these two columns to make them one ?? I am clueless here...The best i can do is to view them as one [code] SELECT Tel_H_Code + Tel_H AS 'Tel_H' FROM Detailed_List [/code]

Im creating a project where the a blog can be submitted, the date is stored in the database as dd/mm/yy, however im using LINQ to SQL to get the date as well as other information, the problem comes when i want to display the date in a particular layout (similar …

Hi guys I am able to drop my tables that I want but however when I come to trying to drop rows the rows do not delete. I have tried the following which have all produced the same error duplicate key TABLENAME : Any help you can give for a …

Hi, I'm using SQL Enterprise Library (Microsoft.Practices.EnterpriseLibrary.Data.Sql) objects and I'm considering using a DbTransaction to execute multiple DbCommand(s) for inserts/updates in one transaction. Let's say these queries take a few minutes to execute, I do not want it to prevent another process from queries the same tables. Considering I do …

Hi, How can i call a stored procedure for fetching records & use records fetch by procedure in crystal report. can anybody help me. Awating for Reply. Thanks for favour.

Hi Its in fact easy to handle special characters like "%" in query, with just a bit of research one can found solution for this. Today when i checked events for my server i found that one error message and that was because a user searched for " l'atelier " …

Hello Everyone, I'm facing with one problem since two days at importing and exporting data from different file format, actually I want to import data from different file format such as txt, csv, xls etc in sql server and apply some filtration in it. After that export data in these …

Hi Forumer's, I have 3 tables, my objective is to compare the returndate from receiptdate and trandate and get the most recent receiptdate or trandate based on returndate. [CODE] Create Table #USPRODUCT (ESN Nvarchar(35), returndate datetime) Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-04-21') Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-08-08') …