[microsoft:sql-server] Forum Topics

I am running a website of crossword puzzle and Sudoku games. The website is designed to be: [LIST=1] [*]There are 20-30 games onlines each day. [*]Every registered user could play and submit the game to win scores. [*]For each game, every registered user could get the score for ONLY one …

pls help me to do this in C#

Hi Everybody How can I use 2 update stmts in a single SP? I want to update two tables, with different data, but with the same, where clause Is there any way to do that? thanks

how to do a conversion of string into binary format in sql server( how to use CAST or CONVERT in sql query)

Can someone please show me a code syntax on how to update an SQL database programmatically ( execute on click of button). I want to get all records from the "Student" database table where StudentStatus = 'New'' .Find a particular RegDate (2001/02/02) , StudNo ( 200144176) and update it's StudentStatus …

Hello, I am using ASP and MS SQL Sever 2000 as backend database.. I am writing a SQL query which will pick up top 5 recipes details who have scored the highest marks from the following table tblrecipes - [code] ID | recipe_name | Total [/code] [u]The following points to …

i am trying to install the ms crm trail version and i keep getting err msg " The minimum required version is SQL Server 2000 SP4 (8.0.2026)." i already downloaded the sp4 with all its components updrade and my sql version is 8 but i need it to be 8.0.2026. …

can anyone tell me the coding for creating a sql table programatically in vb.net

Hi,I want to save a picture in a database(SQLserver2005) and use it the picture in a web form by binding to a control how can I do it?

[B]Intro[/B] I'm not the best at this, but I thought we were lacking a SQL tutorial... [B]Test table[/B] My Little Test Table called "test" for this great exercise contains the following [B]FirstName[/B] [B]LastName[/B] [B]EyeColor[/B] Paul Esson Brown John Smith Blue John Howard Green Kim Beazley Gray [B]SELECT[/B] This selects data …

hi I am working in asp.net but new to xml q: I have some data in xml format. I have to convert the data to SQL table and display the data in web page through gridview through coding. the problem is as i am new to xml I dont have …

can anyone tell me the code how to connect database in C..The databas3 may be either Oracle ,SQL Server Or MS Acess.. plz help me...

I hava a table that stores payment information, with invoicenumber int and part varchar, where part can be (1/1, 1/2, 2/2, 1/3, 2/3, 3/3, etc) The thing is not all payments are related to invoices, so I have many null value for invoicenumber. Is it posible to create a UNIQUE …

Hi all, I need to build a application in which i have to test wheather sql server 2000 is connected or not.I cant be dependent on any query using master database as user might not have access to it. I used following code [COLOR=#0000ff]Try [/COLOR][COLOR=#0000ff]Dim[/COLOR] objIPHost [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] System.Net.IPHostEntry objIPHost …

Hi there I was wondering how to get visaul basic to bring up another form when a button is clicked. what I am looking to do is have a database (SQL 2005) that uses two tables but in the same database but have each table on a different form. but …

Hi everybody I am trying to develop an application, in which i want your help and suggestions. I have a master page and many content pages. I want to write a javascript function in the master page script, and call that function in body onload. I have a field in …

I have a problem creating a ODBC connection. I am using MS SQL server 2000. Local access. I create it in System DSN. 1. I select the "With SQL Server authentication using a login ID and password entered by the user rather than Windows NT. But the error message occur …

i have a datadriven form which is fetching data from sql server and displaying it into textfile now i want if any error occures in this application then it will log error into the following database tabel i have created following fields,And table name is ErrorLogFile errorid auto edate datetime …

Please help me, about make class module to manipulation database ACCESS (*.mdb), so i can execute SQL statement like SELECT, INSERT, DELETE and UPDATE database itself.. I made my own project sample VB6.0 with no class modules at all, i thought my code/script not very powerfull.. Can you help me??? …

I am planning to build a web based database system using SQL Server 2005 ( any edition) for the database and Visual Studio 2005 ( I am not yet sure which edition to use) for the web interface. Is it ok to use Visual Studio 2005 Team Suite with any …

[COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I …

I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL …

I need to complete a task, although I am not quite sure how? The task is to create a very unusual search system for a car rental site. There is a database of cars that the rental company possesses, and when the user specifies the rental dates - the list …

Hi Friends, I have the following query, i am using the column alias by this way, select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature it works fine and i get this output. Work Code Work Nature 1 External 2 DE-Sales 3 DE-Miscellaneous 4 DE-Equipments &Transport But my requirement …

[COLOR=#008000]I have a table with a primarykey ID and a unique key for ID_EMP and OSID When I insert I want to populate the OSID column whth the next int value related to id_emp My trigger works but is returning the error message: Warning: Null value is eliminated by an …

Hi all, I have an application written in C#, it connects to a SQL database using SQL Server 2005 Express. What I need to do is install my application on multiple computers on a network, but they must run from a single database on one of the machines, so I …

In my database, I have two tables: Forum and Files Files have two fields. First one is [B]FileID[/B] and second one is [B]FileAddress[/B]. [B]FileId [/B]field is fine. but in [B]FileAddress [/B]field I have a lot of urls. I want to just change certain parts of url. For example, instead of …

We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or …

hi, table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 how can i get reqult which has been shown below ? MAX value ali elli 5 ali elli 5 …

I am planning to build a website system (a web interface that connects to a database). I am planning to use SQL Server 2005 Trial Edition but I am not sure if I can use Visual Studio 2005 Team Suite. Is it possible to build a web based database application …

Greetings. How are all of you? I'm new to Daniweb, but heard of you through Mauisun. Anyhow, I have a copy of SQL 2000 standard, but it's an old school copy without reporting services. I understand that 2000 now comes with RS for free... does anyone know where this "free" …

Hi guys. Hope you can help me with my problem here.. It's quite complicated so I'll try to explain it in a very detailed manner.. I have these two databases which we may call dbaseA and dbaseB. I created another dbase which we call dbaseC. dbaseC is going to be …

I'd like to split a full name field on a space into first name last and update my database, I would prefer to stick to TSQL/SQL if it can be done on SQL Server 2005, any ideas? table actors actor_id int Unchecked actor_name varchar(50) Checked rating smallint Checked actor_last_name varchar(50) …

Hi Guys I've got a bit of problem with date. When I transfer data of a table to txt file the date column that appears in the table like "28/03/2001" changes to "28/3/2001 0:00:00" in the txt file. I've tried to change the format of date in the table but …

I get the following error "Timeout expired. the timeout period elapsed prior to obtaining a connection from the pool. this may have occurred because all pooled connections were in use and max pool size was reached." The below code is in the click event of the Upload button. This works …

Hi all - I am a newbie to this forum, but maybe someone there can help. I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, …

I'm no IT specialist but need some help for my company. I'm currently using a customized program in SQL for my invoicing, and a rudimentary mix of paper and some Quickbooks for my accounting. Double entries is just one of the major problems, with tax time and gathering info from …

I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as …

Hello all - I've got an interesting problem that I can't seem to solve, so any input on this would be greatly appreciated. I have a group of web pages. I'm passing several variables back and forth between those pages successfully. One of the variables is called sntime. Essentially, it's …

Hello All, I need a help from you all ,I have a big problem right now I am developing a stock market related site where I have to calculate XIRR return of investment and this is in built function of excel So wht I want is to take data from …

Hello Im a beginner one in programming. My first problem is, How can i view a image file from the database(sql 2005) as "image" to visual basic 2005. for example: a text viewed in the textbox from database. the code is. textbox1.text=rs.fields("text").value My problem is how can i view the …

Hi, When backing up earlier versions of media player I used to back up a database file stored in c:\Documents and Settings \ Mark \ Local Settings \ Application Data \ Microsoft \ Media Player that I assume stored additional information I entered for each music track (e.g. correct album, …

Sir/Ma'am, I have a winforms datagrid with some of the fields (see my attachment file) and button such as (add, edit, delete, search). My question is how can I insert, edit the rows from datagrid to database i'm using sql server.Can you please help me. Thank you in advance nikki

i,m dil involved in learning .net .its really great to know from .net we are able to transfer data from sql server to excel.but im intrested to get the data from the excel to .net could u plz help me? thanq

Hello, and thank you in advance for any help you can provide. Each line in our datagrid control contains a product number, description, and a textbox for the user to enter a quantity-to-order. Users enter quantities (not necessarily on every line), click the Next button, and continue. Sometimes users return …

I am programmer.Have been using VB 6 and Access.I now want to start using SQl server.Somebody to assist me on how to connect. Thanks

Greetings all! To get to the point, I'm having issues accessing SQL databases. The specific error is as follows: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here's the setup: The workstation(s) …

Hi all, DECLARE @STA as char(50) SET @STA = 'TT' SELECT * FROM ABC_TBL where ABC_Filed in (@STA) if i have multivalue in parameter @STA, like 'TT', 'DD', 'AA' so how can i write my statement? i only need to pass one parameter with multilist, so do anybody know how …

How can I find active users and UsersID online in MSSQL ? I cannot find it in Enterprise Manager ? Someone know a scripts that can do ? I need to find active users before I do some upgrade jobb on servers ! Thanks in advance....

Hello Everyone, I need to complete a task, although I am not quite sure how? The task is to create a very unusual search system for a car rental site. There is a database of cars that the rental company possesses, and when the user specifies the rental period - …