[microsoft:sql-server] Forum Topics

hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL …

hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL …

i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login. ALSO i can login well using the sql server …

i want to connect to a sql server running on another xp computer. i have made the sql connection, sql data adapter (using Data controls, not connecting manually from code). i can fill the data adapter from the design view by right clicking on the adapter, Fill dataset and i …

hi.. i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created. [code] CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] …

Hello, hopefully you can please help me. I've been tasked to upgrade an old system and there's many different versions of VB code that uses MDAC to talk to MSSql. Version 1 of the program is: [code] Public cnxEventLog As New ADODB.Connection (defined globally) <code in a procedure follows> If …

I am using visual devloper express, and i have been following allow in the "starter videos". for lesson 8 (editing and insterting into a sql express db file on the local host), the example worked fine, but when i try to replicate the example with a SQL database (external one) …

Visual Basic 2005 How do I go about adding a column to an SQL database. Everytime I did it in the past it was a disaster and I literally had to start all over again from square one. I would go into Dataset Designer to add the column then I …

I have a populated table and would like to store a link in a field. I am populating an html table from the table and want the value of the field to be a clickable link....is this possible? :-/

Hi, I am getting error when i am installing Sql Express 2005 on Vista Machine. I am getting error message like this "Microsoft Express service Can not be started.Installation Aborted." Even i have checked the Log file on "d:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\summery.txt" in that also it has given the …

[COLOR=#000000]I have two record sets. One is transactions and another is GL posting. I am aiming to create a third table to find out the customers are from which country inflate our GL.[/COLOR] [COLOR=#000000]For example GL Table has following fields[/COLOR] [COLOR=#000000]GLCode[/COLOR] [COLOR=#000000]GLDescription[/COLOR] [COLOR=#000000]GLAccount[/COLOR] [COLOR=#000000]GLAccountCCY[/COLOR] [COLOR=#000000]Balance[/COLOR] [COLOR=#000000]BalanceUSD[/COLOR] [COLOR=#000000]Transaction Table has the …

Hi, I am writing a query that requires as input the difference in days from two dates (Project_End - Project_Start, both of data type DATETIME), how can I find it? Can I subtract the two dates? Thanks, Robert

Hi! I want to share news... Found an interesting SQL editor supporting intellesense. Site vendor [URL="http://www.yukondev.com"]www.yukondev.com[/URL] there is no editing tables, but otherwise that is what I was lacking. [COLOR=black]Regards, Mike [/COLOR]

Hi, I have created a stored procedure that would insert new records in one of my database tables. I have tested the procedure in SQL Server 2005 and it works all right. What I want to do next is to connect the stored procedure to my form in VB.Net so …

Hi, I'm a bit stuck. I've been breaking my head quite long figuring how to do this. I need to generate areport that is grouped by week. i need to display total number of patients who are enrolled in the system. And they are grouped by the weeks in a …

lstUsers.Clear() lstUsers.View = View.Details lstUsers.Activation = ItemActivation.TwoClick lstUsers.Columns.Add([COLOR=#800000]"First Name"[/COLOR], 100, HorizontalAlignment.Center) lstUsers.Columns.Add([COLOR=#800000]"Last Name"[/COLOR], 100, HorizontalAlignment.Center) lstUsers.Columns.Add([COLOR=#800000]"Email"[/COLOR], 100, HorizontalAlignment.Center) lstUsers.Columns.Add([COLOR=#800000]"Job Title"[/COLOR], 100, HorizontalAlignment.Center) lstUsers.Columns.Add([COLOR=#800000]"Mobile No"[/COLOR], 100, HorizontalAlignment.Center) [COLOR=#008000]'lstUsers.Columns.Add("People Involved", 100, HorizontalAlignment.Center) [/COLOR][COLOR=#0000ff]Dim[/COLOR] cnn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDbConnection [COLOR=#0000ff]Dim[/COLOR] da [COLOR=#0000ff]As[/COLOR] OleDbDataReader [COLOR=#0000ff]Dim[/COLOR] cmd1 [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDbCommand cnn.ConnectionString = [COLOR=#800000]"Provider=Microsoft.JET.OLEDB.4.0;DATA SOURCE=c:\ApptDB.mdb" [/COLOR]cnn.Open() cmd1.Connection …

Hii Friends I am doing an erp web application using jsp,servlets,struts,sql server 2000 but havent implemented connection pooling, but want to do it now can anyone quide me the best way to master it or show me where can i find some pdfs which will give me the most knowledge …

I needed code for dynamically selecting the TopN/Sort Group Expert in crystal report. I am using VB.net and SQL. My report has its data coming from a stored procedure written. This will be of great help as i needed to give the option for my top sales report.

Hi all, I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a [code]select * from sales[/code] I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser` I …

[COLOR=#434343]Hi all, I would like to seek for some help from you on how to create a connection to a sql server database which is host on web with my local VB6 program. I appreciate if you could provide me the relevant information about that with some sample codes. Thank …

I have a Access 2003 database which has a table we'll call orders. There are 10 other tables linked to orders through Order_ID. I'd like to be able to create a duplicate of a record and all the associated records in the linked tables. I've read it possible with an …

Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in …

Hi, I have a small database with 15 tables and 20-40 records in each table. I just want to ask how can I print all the tables together with their names, atribute names and all the records? (the Print option from the File menu is not active) Thanks, Robert

Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in …

Hello all. I was hoping maybe someone could help me out with my problem that I am having right now(well not me, but a co-worker at work). We use Visual Studio.Net 2003 along with Reporting Services here at where I work. Well, all is going good for all the clients …

Hi. I have just installed 2005 in my on my database server. Now, I have a web server and will need to access my database from my web server for simple stuff such as querying the database and checking tables, etc, etc. What should I be installing on the Web …

Hey, first poster here: I'm not actually running on MySQL (I'm using MS), but my question is more of a design issue. The model I've been using is perfect for maintaining relationships between data logging devices I have in the field, and so-so in keeping an aggregate of that data …

Private Sub btnsearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsearch.Click Try txtmsg.Text = "" OleDbDataAdapter1 = New OleDbDataAdapter("select * from phbook where name like '" & ddl.SelectedItem.Text & "%'", OleDbConnection1) OleDbDataAdapter1.Fill(DataSet21, "phbook") OleDbConnection1.Open() Dim com As New OleDbCommand com.Connection = OleDbConnection1 com.CommandText = "select * from phbook" dg1.DataBind() …

i have a small project with oledb (access) connection how can i make exe file to allat the same meaninig i have to deploy the project to work on any pc without change the path or the connection. i did it but i get errors cuase it was belong to …

I have a view that looks at new student records and a table that stores those records and information related to their Active Directory logins. What I need to do is filter out any duplicate records between the two "tables". So I only see unique records in the view to …

My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those …

Hi, I am interested in applying for a junior application programmer in a financial company. Just want to know what kind of job it will be. The job description says that the role will work on .net, C#, SQL server, VB and VBA. I am not familiar with any of …

Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)

Hi crystalians, [B]With reference to the Crystal Report 11 product[/B], I have created 2 sub-reports from 2 unrelated tables: A and B. Then inserted them onto one blank master report in the Report Header section. I need to pass SQL statements from within Visual Basic 6.0 to the sub-report so …

Hi, I am writing a small search engine. There are two tables. The first one holds the search engine main index, the second one is link table. I have the following query that retrieves results. I would like to sort the results by: dbo.OCCURS2(LOWER(:query),se_links.anchor). se_links.anchor obviously comes from se_links table, …

HI, [COLOR=#000000]I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing …

hi! I need a program in vb that does this as soon as possible, I'd be very grateful if anyone could tell me how to do it: the customer gives a table containing the old values and new values in an excel sheet which will be connected to an access …

I have the following select query: [CODE]SELECT DISTINCT Job.JobID, Job.DateAdded FROM Job, ImageTag, Image, Tag, TagCat WHERE TagCat.TagCatID = Tag.TagCatID AND Tag.TagID = ImageTag.TagID AND ImageTag.JobID = Image.ImageID AND Image.JobID = Job.JobID AND ImageTag.TagID IN (#TagIDList#) ORDER BY Job.DateAdded DESC [/CODE] However, I need to add to the query the …

I need a solution on how I can connect SQL2000 DBase Management to VB6. pls any body with good solution and sample code can give me as soon as possible.

When i make click on signout i m destrying the session object by session.abandon qith modifying the database with status = offline.. Bt when IE is closed directly without clicking on signout session object get destroyed bt the real problem is that [B]how to update SQL Server database as session …

Hi i basically new to visual c# and i want to create a stock portfolio program to store my stock information, i have decided to use SQL server 2005, but i'm not sure if i should use mangement studio that comes with sql server to create the database or a …

I'm attempting to upgrade an Access database to use a SQL Server 2000 back end. I have installed SQL Server and created a DSN. However, when I attempt to link to the SQL Server database from Access (File/Get External Data/Link Tables/Select ODBC Databases) nothing happens! Any ideas what I'm doing …

Hello this is Bhanu. I am presently working in Parsvnath Developers Ltd., as Assistant Executive, IT Deptt. Attributes in our SQL Server is getting changed automatically due to which we are not able to change the permissions, which gets disabled on its own.

I have created the following stored procedure in sql server 2005.I m using asp.net with C# 2005. Can someone please rectify my errors why i m getting such type of the errors... [code] ALTER PROCEDURE CompanyStoredProcedure @uspcompanyid INT NULL, @uspcompanyname VARCHAR(20), @uspaddress1 VARCHAR(30), @frmErrorMessage AS VARCHAR(256) OUTPUT, @RETURNVALUE AS INT …

Hi, SELECT * FROM veriler WHERE (name LIKE '%in%') This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access? Thanks

Hi, i'm new to all this. I'm really stuck!! I'm running XP Prof and have recently installed SQL Server 2000 Personal edition. It seems to have loaded in ok,,BUT,,it won't connect to my localhost,,i don't know what the problem is i get the 1069 error message. Pleaaaaasssee can someone help …

I want to install SQL Server agent using [B]Setup Factory 7[/B]. Can anyone please help me on how exactly I can do this? (I am installing a VB6 program that must access data from SQL Server 2000, so I want the setup to: 1. Install the SQL Server part. 2. …

hai guys, I am a newb in SQL server. yesterday i have installed microsoft sql server 2000 to my computer. But i don't know how to employ this. I have a group of ASP pages that contains my MBA assignment notes and files, and is successfully working with IIS in …

My dears, I have installed SQL server 2000 on my computer. And have made database through the below command: Create database mydb go exit But nothing happens. I don't know how to manage this database. Can anybody clarify how can i store my ASP pages in this database. How can …

[B]Any expert can solve this??[/B] Error message will occur during execution, is something related to sql. the program will show an error on objcommand.executeNonQuery. Can solve this? Imports System Imports System.Data Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As SqlConnection = New _ SqlConnection("server=(local);database=uni;" & _ "Integrated Security=True") …