[microsoft:sql-server] Forum Topics

Hi all, have vista HB installed here but I need to get SQL server up & running. Now I have read many articles that propose IIS7 cannot be installed on a Vista HB machine. Is there any way around this? I need IIS for SQL server to work. Many thanks.

Hi All ! I want to use the returned value of user defined function of source code(VB.NET) in Databases( MSSQL) is it possible to throw the returned value of user defined function of source code into databases? Kindly Help me in this regrads plzzzz ... its really very urgent ! …

hi All i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this [CODE] Lis_key ===========Attrib_code========================= Func_key====== ===================================================================== 01424545 1212033993 PV000000 01424545 Null GEOSS001 01424545 Null GEOSS002 01424545 Null GEOSS003 [/CODE] Figuire:1 Now …

I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with …

this is the questions i faced in an interview i am new in .net and sql so anyone knows this ans please inform me thanks *Can we have an updateable view in SQL? *What is the difference between stroed procedure and stored function in SQL? *What is connection pooling? how …

Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that …

How do you write a store procedure to meet the following conditions: PROXIMITY SERACH PROCEDURE COMPANY table PK company_id int company_name varchar(100) premise varchar(10) street varchar(30) town varchar(100) postcode char(7) x_loc int y_loc int COMPANY_KEYWORD table PK, FK1 company_id int PK keyword varchar(100) The data above shows an extract of …

I am trying to dig data from a table that has a field named begdate and another one named enddate. They hold obvious values, but I need to have the query find the record that has a begdate that matches whatever the previous Sunday was to the day the request …

Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …

How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, …

I'm working on a simple contact database style program I am using button click event to start an event that pulls an adjacent text box text and queries it however i can't seem to figure out how to update the DGV. here is what i have. private void searchButton_Click_1(object sender, …

I have been in IT for 22 years and have seen many changes. While contracting for a company in London I encountered a server running Windows 2003 running very slowly. It was a key server for the company and had been designed by a specialist. I ran a Microsoft SQL …

hi friends, i am using visula studio 2005 and database is sql server 2000. i have one table "Designation_Master" with two columns "DesigID" with datatype "smallint" and another "Designation" with datatype "Char(10)". i want to display both column in one row in combobox. i know concate the column. but i …

[B]Hi people, I want to know how could we embed SQL code into C/C++ code. Please, give me a link or give me a small example. Thank you very much. Begueradj.[/B]

hi...... i m new devloper in c# so i need to know how to write to populate data in the gridview from sql server......and we are using multiview .......plz reply soon i really mean it thanks in advance..bye

is there a way to generate sql reports with sql reporting services through the visual basic 2005 or 2008 express edition?. is there an add-on or something for express edition?.

Hey I've set up a maintenance plan to backup databases daily and noticed the following error in last night's backup - Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan. Has anyone seen this error before or have any idea what it could mean? Thanks in advance. …

hi there, creating a structured databse (maybe in SQL) that I want accessable from a UI in c#. Is SQL the best way to go about this ? cheers

Hi, I'm workin on a website where i need to update a password using a stored procedure. I tested the stored procedure on SQL server and its working fine. but somehow i cannot seem to call it from C#. Can any one please help me? Stored Procedure CREATE PROCEDURE dbo.sp_ChangePassword …

Read multiple columns data from SQL query ( 1 row ) Hi all. I am using an SQL express where I’ve designed a table named User_DB_Main I have also created a procedure that makes some selections : [code] @UserId varchar(20), @UserPassword varchar(30) AS /*- Check if UserID exists*/ SELECT COUNT(UID) …

Hi can any one help me in following case? Table A ID | Name 1 , Apple 2 , Bat 3 , Cat 4 , Dog Table B ID | Name 1 , A 2 , B 3 , C 4 , D 5 , E 6 , F 7 …

I am using SQL Server 2005 to run a stored procedure to update, delete, or insert depending on some conditions. The problem is that it gives the following error: Msg 4104, Level 16, State 1, Line 49 The multi-part identifier "PART.ID" could not be bound. I have it inserting some …

Can anyone please tell me how can i copy a table. thank you. and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company. Thanks a lot.

I created a DTS package in sql that exports a table into csv format. Is it possible to call this package from vb.net. Please help.

Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select …

I'm working with SQL Server 2005 on a stored procedure, but it appears to be going through both parts of the following statement, and not skipping the second half if it is supposed to. Basically it should update the row if there is data there, and remove the row if …

Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries) id | …

Hello, there this is my first post and I´m desperate seeking for help, I have almost not knowledge of SQL as it is not my usual work. However, suddenly it has converted in mine....Hopefully I will got help in here. Well the issue is that our database manager has resigned …

can anybody tell me abt the difference b/w sql server 2000 and 2005

Hi, I am trying to create dynamic contents in a web application where I retrieve a list of data from my database.. Let's say from table MembersInfo And in this table it consist of Membername, Member Particulars, Member Address, file location of their photo in the server. i do a …

I am in the early stages of writing a program in VB 2005 that deals with taking a test. I need to create an ERD for the project that deals with taking tests and storing the results. All users, admins, instructors, tests, questions, answers, and results will be stored in …

can anybody tell me about the difference b/s a SP and functions

Hi there. I have a datagrid that prints out data from an SQL d/b. I also have a 'Save' button which I am struggling to write an event handler for. the Datagrid data is editable, and when I press save I want the changes to update the D/b too. Any …

Hi, For a reservation system, I would like to be able to highlight those reservations where the dates and times are duplicates, so those confirming the reservations will easily see double-bookings. So, for the following list of dates & times Jan 1, 10-3 Jan 2, 4-5 Jan 1, 10-3 Jan …

hello everybody, I am working on .net application (asp.net and vb.net and sql server as backend). How can I provide security to my web application ? Please anybody tell me about it? Thank you,

hi friends, i had a problem when connecting the database to the asp.net. My database is SQL server 2005

but i hope someone can point me in the right direction. here's the story 2 pc's, one upstairs with database one downstairs used to access and make changes to. This was working no problem for months. Then the downstairs pc needed a new AGP video card, easy install no configuration …

[B][B]hi every body i'm new to MS SQL and i want to learn it if any body knows good source or web sites about sql server 2000, i'll appreciate if he lets me know thanx for your help, everunloaded, bye[/B][/B]

HI!!! I am doing Face reconition project in vb.net ... so my first module is uploading images and need to store in sql, that images i should retrive in vb.net. so, pl tel me the procedure and coding in vb.net2005

I'm a bit new to this so please bear with me. I tried searching the forums for the answer, but perhaps I just don't know what to actually search for. Here's my situation: I am using Visual Studio 2005 Standard SP1 to develop a website based front-end for an SQL …

HII, i have a column in sql srver 2000 of data type bit.I have a checkbox in my page. i want to assign bit value to the column when the check box is checked and un checked,but i am getting errors when assigning true /false to the column.

hi Me now facing another array format promble again SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE"; how to store data into to this multi array again?? DataFOr UPload_date $arrDate[0][1]=19/2/07 $arrDate[1][2]=21/3/08 $arrDate[2][3]=2/1/08 $arrDate[3][4]=4/3/08 data for TotalRawAmount $arrData[0][2] = 1000; $arrData[1][2] = 2011; …

how to save an image drawn with GDI+ to sql 2005 database?

[B][/B] Hello members, I am trying to execute the module below (SQL statement) and I am getting the above error: "Syntax error in FROM clause" on this line [code]Call db.Execute(strSQL)[/code]. When I hovered the mouse over the SQL string variable, it shows this line of code: [code]strSQL = "Insert Into …

LOL - I figured it out - but thanks for looking :)

I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment? I am looking for an industry accepted, more secure than traditional FTP. Thanks!

can we write queries in functions I mean can execute queries in funcitons?

Hello All, Iam using Sql Server 2000. I want to Bind the Gridview with the Database, by giving the name of the table in the "Use Data Source" option in the Smart Tag of the Gridview. In the Add Connection Dialog Box I give "Microsoft SQL Server(SqlClient)" as a Data …

I am a new asp.net user and I am trying to use this peace of code inorder to send data from the website to a console and email address. I have managed to write all the required functions, but when it comes to sqlConnection and sending the data, that is …

Hi, I have this app running fine on my pc with connecting to SQL server on my localhost using windows authentication. Now I am going to deploy it on my client's server where SQL Server 2K DB is on server "abcd" with SQL Server credientials (No windows authentication) My problem …