[microsoft:sql-server] Forum Topics

Hi, I have a derived attribute in my table and I'm sorting the table in the descending order of this attribute. My query should retrieve all the tuples which have the maximum value for this derived attribute. If I use SELECT TOP 1, I'm only getting one of the required …

I have been having significant trouble starting this project where i need to create a databse library to access an sql database. I am working in vs2008 and I should be able to just edit my app.config file and use my ODBC connection drivers. If anyone could help explain this …

Heya, what i would like to do in one query is pull out two objs, that are very similar from the same table "ol_obj_data" These two objs are "ratings" and "reviews" they are not linked except for a USER_ID of who submitted them. But they relate to our business data. …

I try to retrive the doc file from sqlserver,when i execute the code ask me Do you want to open save file? when i click open button the doc file open with error "System.Byte[]" Dim sql As String Dim strcon As New Configsetting Dim cnn As New OleDb.OleDbConnection(Configsetting.ConnectString) Session("Req_SeCode") = …

heloo. i created checkboxes in my web interface and each time a checbox is ticked the value is stored in database but however the checboxes which is not selected , the value is stored as Undefined in database. where did i do wrong? here is my coding for the checkbox: …

Hi all, I am developing an application which reads an excel file which has the following records and inserts into a table in SQL SERVER 2005 database [Enterprise Edition]. Data: Product Version CustType ------------- ------------- -------------- Norton SystemWorks Basic Edition 2009 CS Norton 360 2 CS Norton 360 2 CS …

I have put together this whole network account creation and audit process. The creation process starts with importing data from our ADP system into SQL 2005 and creating a .csv file for each of the 12 sites to create the network accounts, based on job title. Then I add in …

Hello, I have a question on how to connect to a MS SQL SERVER 2005 using sqlcmd utility. I am not sure where to post this topic. I'm sorry if I am posting this to wrong topic. I had tried to connect by typing: 1> sqlcmd -S 127.0.0.1 2> go …

Hello , I have a database SQL server 2008 database. What are the SQL queries that I could use in the SQL server management studio to retrieve the following information: 1. all stored procedures. 2. all functions. Thank u

hello sir , Q:-How to display data in datagrid from multiple tables in SQL server 2000 and vb.net 2003 its very imp for my project i have tried with following code Pl tell me the correct way to do it tables i am using are TABLES COLUMN CONSTRAINTS COLUMN NAMES …

Hi, While trying to connect MSSql Server 2000 databse through ASP .Net application using c# I got below errror. Please help. Sql Server does not exist or access denied. Mubin

The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this. [code=sql]select * from clientcode order by cc_clientcode result:(5627 row(s) affected) select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname ,c.Client_panno,c.client_userid from clientcode cc LEFT outer join client c on cc.cc_panno=c.client_panno …

Hi everybody, I have really damned trouble here... On MSSQL 2000 I have something about 140 log tables with three columns in each one. "ID" AS INT, "SomeTextCODE" AS NVARCHAR(20) and "SomeTime" AS DATETIME I made a view (v_SomeView_ALL) in which there are all these tables united. But some SomeTextCODEs …

hi i am using visual studio 2008 express edition. i have created a database in sql ( add new item > sql database). the db has 2 fields uname and upwd. have also created a web page in asp.net that has 2 text boxes (textbox1,textbox2) and a command button (cmdbutton1). …

Hi, I am fairly new to IT (i.e. graduate). I am looking to find out about virtualization and how it can be used etc... But i have no idea how it is implmentated or what use it would be? I currently work for an insurance brokers and the only servers …

All SQL Server databases, over time, experience "internal" fragmentation of its data. In SQL Server, there are several ways to defrag internal fragmentation. Unfortunately, internal fragmentation is only part of the fragmentation problem.

Can anybody explains me why following sql statements do not work with mssql? create table place (id int primary key, name varchar(64), parent_id int references place (id) on delete cascade); create table transport (id int primary key, name varchar(64)); create table trip (id int primary key, from_id int references transport …

Hi friends, Please tell me how can i create database and user id through below code i am gotting problem of user login failed. I don't know how can i create database,user through vb.net Dim conn As New SqlConnection("Server=localhost;user id=;database =;") Dim comm As New SqlCommand comm.Connection = conn comm.CommandType …

Please Help me out. I am developing the project on online examination . I am having problem in connecting to the remote sql server. So i need help. Please show the code in vb.net SNIP

I have been using the below SELECT string for some time and it has worked well, I now need to add a SUM and GROUP BY to this string and have not been able to get it to work. Dim selstrHISTORY As String = "SELECT history.route_no,history.Acct_no,history.Post_date,history.tran_code," & _ "history.Amount,SUM(history.Amount),SERVICE.parcel FROM …

im in the process of looking at a reporting tool for my database system - can anyone point me in the right direction for the best product available. i previously used crystal a very long time ago (it may be called something else by now) but ive read alot about …

Hi I'm to stupid to write sql but im trying my hand at it anyways. I cant work this out any easier than doing a seperate command but when i do that it takes forever. So i tried doing it as a subquery, but i think somehow i need to …

Hai, ive created a SQL database, but now i want to place and use this on another PC. Is it possible to write the database files to a CD or DVD and then copy it to another PC? If yes then please explain how. Thank you

Hi guys, I am creating a monitoring program. I need to create a windows service to send a ping request to a list of servers from a sqp server database then store the results back into a sql server database. Need some help gettin started can i run the windows …

I have a standard Windows Forms Application project with an SQL database connected to it. It got some textboxes and stuff. But the tricky part for me is the checkboxes (bit values). It says (as far as I can see) in the properties that their checkstate should be Unchecked. And …

Hi, I read an excel sheet into a datagrid.From there , I have managed to read the grid's rows into a DataTable object.The DataTable object has data because when I make equal a grid's datasource to that table object , the grid is populated. My Problem : I want to …

I am trying to import paradox database data in sql server 2005 and ms access. I am getting an error called Incorrect Collating Sequence. Prior my system format it was working perfectly fine but after i formatted the system i am getting that error. I tried different collating sequences and …

Hi to all I am working with Sql server ce for mobile application with vb.net. I want to crete a table before that i have to check weather the table exists or not. Also want to know about Object id in sql server and how to create it. Thanks and …

Dear all, Does someone know how to connect to SQL Server by using Remote Method Invoke (RMI) ? I have project from my lecturer to create program as its connection to database uses RMI or socket. Thus far, I only know to connect to database by using OLEDB and ODBC. …

Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word Freq 1 Book 9 1 Study 3 2 Work 4 2 Run 5 2 User 2 3 …

Hello, I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this: [CODE]user question answer Mike 1 2 Mike 2 1 Mike 3 5 John 1 5 …

Hello, I've just migrated a website built with asp and MsSQL to a new server. The old server used MsSQL 2000 nd the new one uses MsSQL 2005. I know the database became slightly corrupted when it was uploaded. I was just wondering if anyone could tell whether the varchar …

hi there! im a newbie on asp.net and would like to ask you guys if you have any idea on how to convert my connectionstring to mssql <script language="vb" runat="server"> Dim myConnection as OleDbConnection Dim strConnectionString as String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\pubs2000.mdb" any info would be appreciated :)

Hi, I am trying to break each record into 2 records but failed Is it possible? What is the correct way to do it? Thanks in advance!!! For Example: I have a table that contains 100 records . Each record has the following 10 columns: Col1, Col2, Col3, Col4, Col5, …

hi i have a window application, wherein i have to choose the database,its table and rowfields present in the table at runtime. Now i want to remove all the duplicates from database. my database is access and whichever row field the user chooses the duplicates should be removed leaving the …

hi everyone, I have my website which i used microsoft access as my database. everything's working fine except when i submitted the site to my boss for approval, they rejected it because they dont want me to use ms access as our database because they said its not a strong …

Hello sir Can u say me how to retrive data from database and showing the result on the html page.well i have created a user DSN named as new then created a database named as DB n created a table named as information. well i am using sql server 2005. …

Hello Sir, Can i plz have query of "Find the 6th highest salary from the table" .....plz send me d query

Hi everyone, I'm trying to write a stored procedure select statement which is a little beyond my experience level. I have a table in the DB called addresses which contains the following fields: [LIST] [*]address, VARCHAR [*]count, INT [*](a few more fields) [/LIST] My stored procedure will take in a …

Hi all I am pretty new to MSSQL and have a problem. The solution is probably very simple but I cant find it :) I have a database field ZIP, I also have string with consists of a number of UK part postcodes eg 'S10 S11 S7 S17 S8 S3 …

Logfile of HijackThis v1.99.1 Scan saved at 19:36:32, on 10/10/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\WINDOWS\system32\VTTimer.exe C:\WINDOWS\system32\S3trayp.exe C:\PROGRA~1\Grisoft\AVG7\avgcc.exe C:\PROGRA~1\Grisoft\AVG7\avgemc.exe C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe C:\Program Files\Winamp\winampa.exe C:\Program Files\Ahead\InCD\InCD.exe C:\WINDOWS\SOUNDMAN.EXE C:\Program Files\Common Files\Real\Update_OB\realsched.exe C:\windows\hffext\hffsrv.exe C:\Program Files\Google\Google Desktop …

Hello I use this code as a stored procedure to delete row of the table: [ICODE]ALTER PROCEDURE dbo.DeleteRowMaterialTyp ( @CisloParam varchar(MAX) /* hodnota v tabulke, ktora nam identifikuje riadok, ktory sa ma zmazat */ ) AS Delete From MaterialTyp Where Cislo = @CisloParam RETURN[/ICODE] And this is code where I …

HAI, I'm creating a website for a computer forum (using VBScript, SQL server - back end). Im able to display the heading of the threads in a page & also im able to click and redirect to a proper .asp page but, can u tell me how can i show …

Hai, I'm creating a website for a computer forum (using VBScript, SQL server - back end). Im able to display the heading of the threads in a page & also im able to click and redirect to a proper .asp page but, can u tell me how can i show …

I have created this table and is accessing it via an aspx web form. I would like to know if it possible to update the table sending the update data to a different table in the database. If Yes how do I accomplish that? Trafmore CREATE TABLE dbo.TimeSheet( dt SMALLDATETIME …

I have a database program i have written but it can only be used on a local machine. i want to make it a client-server application whereby the database would be on a system acting as the server and the application can run on other computers as client within the …

Hello to everyone, I have a database with several representatives in different cities, sometimes there are many representatives in one city. The search is like: [code] sql_representatives.source = ("Select ID, CITY from REPRESENTATIVES Where PROVINCE_ID = " & LST_PROVINCE.ItemData(LST_PROVINCE.ListIndex) & ";" [/code] The above sql return all cities in the …

I have a table with data that i need to plot on a graph using pivot charts and selecting data for a particular patient number that is repeated severally someone with an idea.

I have an external application running on a MS SQL server2005 (express-edition) database. I need a notification each time the application reads a special table from the database. As a new user of MsSQL I experienced with the trigger function. But this is only applicable when fields in a table …

So I am completely new to ASP .NET and my first page needs to be a log in page. I have a database in SQL 2000 that has a table called tblEmployee. This table holds usernames, passwords, and group security details. I need to grab quite a few fields from …