[microsoft:sql-server] Forum Topics

hi all i m using asp.net 2005 and sql server 2005...i have a dropdown list in my page...i have a table called as details...all i want to do is bind the fname from details table to dropdownlistbox...but the thing is tht i want to each and every step through coding...is …

Hi All, I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder. I have a table projects and a table clients [B]Projects_Tbl[/B] ProjId ProjName ClientId [B]Clients_Tbl[/B] …

i am working in sql 2005, i have problem in Sql collations. our database modified in different people, some time we get collations error. how to solve this error? and how to avoid this problem in my future?

hi guys, im using microsoft c# along with sql server 2k8 to build my database software, i have 2 problems.. 1st is i cant seem to make an incrementing primary key that doesnt start with 1? i wanted to make my primary key start from 00001 then increment it by …

I have generated some SQL code SELECT Invoice.InvoiceID, Invoice.CustomerID, Invoice.RouteNumber, Invoice.TreatmentType, Invoice.Information, Invoice.StreetAddress, Invoice.Postcode, Invoice.Invoicecost, Invoice.InvoiceDate FROM (Invoice INNER JOIN Customer ON Invoice.CustomerID = Customer.CustomerID) WHERE (Customer.CustomerID = '?') When i test it in the query generator everything works. However when i add the following code to my vb form …

I have to tables as parent & child tables as below Table 1 TID1 Name 1 Test1 2 Test2 3 Test3 Table2 [U]TID2 || TID1 || ID1 || ID2 || ID3 || Name[/U] 1 1 1 2 3 All 2 2 2 2 2 All2 3 1 1 1 12 …

I have several questions: Here is the context: The ASP.NET application I'm building - a web service in essence - will be connecting to MSSQL to log requests to a table. These are basic INSERT commands. During high-volume hours, do I risk race conditions? How does MSSQL handle sequential INSERT …

can't solve a homework problem for computer class. Any clues?: Given two tables, USERS and LOG, where USERID is a primary key in USERS and a foreign key in LOG, write a SQL statement that will return LOG records (all fields) with corresponding USERIDs in USERS. The report should include …

Hello Guys, I was dumped in the middle of a project with not a lot of experience in MS SQL server. I have 3 little questions 1) If i receive a bak file(restore file) from another server, is it normal that if i restore the file i will no see …

Hi, In my Insert SP, I have 5 local variables: @MemberID int, @VideoID int, @Total money, @DateRented datetime, @DateDue datetime insert into RentalRecord values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE())) When I try to execute the SP, I get this error: Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied. Please advise. …

i need a software in microsoft's sql server 2005 ... to make myself more efficient in accessing any databases..so could u make some arrangements...

is it possible to convert system made from php with a database of mysql to ms sql database..? how? thaks

hi to all, i am a student, 2nd yr.college taking computer science, i want to learn about in coding in SQL except (SELECT, INSERT, UPDATE & DELETE). i just wanted to learn more complex and difficult coding, syntax, command and etc. please help me. thanks!

Hi, I Have data stored with the following structure: Version Month Amount 1 Brand1 Jan 100 1 Brand1 Feb 200 1 Brand1 Mar 150 1 Brand1 Apr 500 .. .. .. Id'like to transform it in the following table: Version Jan Feb Mar Apr May ... Dec 1 Brand1 100 …

Hi all, Can anybody help me out with the connectionstring for connecting VB6 to a Microsoft SQL Server 2005 Express Edition. I have tried several documented varieties which do not work. My latest attempt was a version from [URL="http://msdn.microsoft.com/en-us/library/bb264566(SQL.90).aspx"]this website[/URL]. I downloaded the application and associated files and changed the …

Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in …

Hi All I am writting an stored procedure to get the recently inserted records primary key as follows: [CODE]ALTER PROCEDURE [DBO].[AddEditUserMsgDetails] ( @iJobID [INT]=NULL, @iUserID [INT]=NULL, @vFromName [VARCHAR](50)=NULL, @vFromAddress [VARCHAR](50)=NULL, @vSubject [VARCHAR](50)=NULL, @iListID [INT]=NULL, @vActualText [VARCHAR](100)=NULL ) AS BEGIN /* Logic Comments: INSERTING OR UPDATING INTO THE TABLE ezlMailJobs EXEC …

I have problem with datatypes. When I use the text datatype on SQL Express, I get "The data types text and nvarchar are incompatible in the equal to operator." error. Wwhen I set my variables to "varchar" or "nvarchar", I don't get an error, but my update command does not …

SqlDataReader rdr = objCon.GetData("SP_BudgetID"); while (rdr.Read()) { txtBudgetID.Text = rdr.GetSqlInt(64); } i m getting an exception hw is it possbile to assign values from dataeader to the control like texbox and i want to assign these value into an array. wat is the way of doing it

Hello, I am trying to display SQL query results in a GUI. Right now I am displaying the information in a standard TextBox, but I would like to be able to sort by the different columns and stuff like that, much like if I had a excel spreadsheet open with …

When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus.

I have an awkward problem. I'm debugging what I believe is a race condition in a legacy codebase. The issue involves a userID column being set to the wrong value. Essentially, one user's record will be non-deterministically reassigned to another user. The real problem is that this column is set …

hi. i would like to work on my computer without connecting to server. i installed the ms sql management studio 2005 express. how can i create a local host server to work on ?

Hi everyone. I'm printing a list of articles from my database. Some articles are set as 'sponsored', meaning they appear at the top of the list. Articles also have a 'type' field - if it's set to 0 then there is no specific type, otherwise the value corresponds to a …

Hi I wrote simple query like [code=sql]select Code,CashDeposited,Date from dbo.RDBankingDetails where Code='SE0001' group by Date,Code,CashDeposited[/code] It generate report like below TE0001 12000 2005:03:26 TE0001 49150 2005:03.26 TE0001 209000 2005:03.26 I want to generate the report like below Code Date CashDeposisted1 CashDepostis2 CashDeposists3 TE0001 2005:03:26 120000 49150 209000 In above CashDeoposisted …

Hi Everyone, I would need your help. I have a project that I need to insert multiple records into my table. Here is more detail. I design a purchase order table with 3 columns (a, b, c): a: is primary key with identity (1,1) primary key b: is defined integer …

Hello Everyone! I'm new to MS SQL, so this may be a dumb error, but anyway, I can't figure it out. I'd like to connect to an SQL server on the internet, I've a valid username and password, but it can't find the server. So, I've tried the following connectionstring: …

when trying to update a sql database i get the following error message on Update Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information the column UserID is the PrimaryKey any ideas would be appreciated Thanks Peter example code: …

Hi, [code=sql] SELECT DISTINCT dbo.RoomRates.RoomID, CASE WHEN (dbo.RoomRates.Overflow = 1 AND MIN(dbo.RoomRates.Availability) <= 5) THEN 5 ELSE MIN(dbo.RoomRates.Availability) END AS Availability, SUM( dbo.RoomRates.Price ) AS RoomTotalPrice FROM dbo.RoomRates WHERE dbo.RoomRates.[Date] BETWEEN @FromDate AND @ToDate GROUP BY dbo.RoomRates.RoomID , dbo.RoomRates.Overflow[/code] Input [code] roomid Date AvailableRooms RoomPrice FreeSale 100 01/12/08 FA 0 …

Hi I hope I have the right forum for this. This is a tricky one....I think! I have a reporting services report that runs off a csv file using integration services 2005. The report is based on a link between two tables linked by cc. The cc field links to …

i have created a database and populated it with information but i have to run queries on it without using a query builder and am quite rusty on SQL. Below are the tables for the database! Staff : Man no, SName,LName, Address, Tel Mobile. Students: Driver No, Group, Exp Date, …

Hi Everyone! I have the following problem: I'm trying to create a web shop (now just the sample of it), using Visual Web Developer 2008 (Express). I've added an SQL database, and a ButtonColumn, where the button selects the line and add the datas to another database. My only problem …

Hi Everyone! I have the following problem: I'm trying to create a web shop (now just the sample of it), using Visual Web Developer 2008 (Express). I've added an SQL database, and a ButtonColumn, where the button selects the line and add the datas to another database. My only problem …

hi, i m fetching the record from the given xml but not success full please help [code]DECLARE @XMLString xml set @XMLString ='<timetable> <day1 id="DY101"> <lecture1 id="LECT101"> <subject>SUB101</subject> <faculty>FAC101</faculty> <room>ROOM101</room> </lecture1> <lecture2 id="LECT102"> <subject>SUB102</subject> <faculty>FAC102</faculty> <room>ROOM102</room> </lecture2> <lecture3 id="LECT103"> <subject>SUB103</subject> <faculty>FAC103</faculty> <room>ROOM103</room> </lecture3> <lecture4 id="LECT104"> <subject>SUB104</subject> <faculty>FAC104</faculty> <room>ROOM104</room> </lecture4> <lecture5 id="LECT105"> …

i have a page in which i m using grid control to display data from sql server. i have two fields in my table.name,image in which image datatype is image.i m using an sqldatasoure for data binding.when i run my page image not displayed in my page.only name field is …

I've got a multi union sql statement however union distinct doesn't work the way I want it to because I just use distinct on 1 column only (link_id). I've several ideas from the internet but I just can't get it to work. Below is the statement. [code] SELECT TOP (500) …

Hello, I have SQL Reporting Services 2005 installed. When I go into the SQL Reporting Services Configuration Manager I immediately get an error that says that "No report servers were found on the specified machine" then Details: Invalid Namespace. Pls help Thanks in Advance

Hello everyone I have a problem with the connection of MS sql with the windows application problem. All i need to do is to insert something to the database table. However i'm not sure how to connect the ms sql with it. I have some codes written out, but i …

I have SQL code in my VB6 project for select, insert, and truncate. For example: [code=VB] strSQL = "SELECT CASE_IDENTIFIER" & vbCrLf _ & " ,DOCUMENT_TYPE" & vbCrLf _ & " ,DOCUMENT_NUMBER" & vbCrLf _ & " ,CASE_LINE_NUMBER" & vbCrLf _ & " ,DELETION_INDICATOR" & vbCrLf _ & " ,MASL" …

I want to access an MS Access database using IP Address on internet using a desktop application. Please let me know as to what has to be done using VB.net Please reply in this or email me the solution at [email]abatechcal@yahoo.co.in[/email]. Thanks.

So... I have 3 textboxes and a Submit button. Here's the code behind: [CODE] public void Submit1_onClick(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); DateTime laiks = new DateTime(); conn.ConnectionString = "data source=.;initial catalog=ForumDataBase;integrated security=true;"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO PostTable(ThreadTitle,PostMessage,UserName) values('" & ThreadTextbox.Value …

I'm not sure I did this right. It's for an assignment for school where i'm supposed to return the author last name and the balance (described below) relating to each author. It's from the pubs database (I'm thinking that most people have used it for testing/learning before?) I'm an SQL …

hi all pls help Input string is not in a correct format. string selectsql = ("select title,convert(varchar,date,106)as date,description,cast(status as bit)as status from event_tbl where i_eid=" + Convert.ToInt32(id2) + ""); Regards

New to triggers and SQL programming but I'm trying to figure it out by looking at code examples. I have a table, called child. My program inserts a new child into the child table and stores the parentid as a FK. What I need to do is when a new …

I have studied sql. I know what is relational database. I wanna konw how we store the data in a relational database and how to query the data when we emplement a "select" statement Is there a open source relational data base? I wanna konw the data structure of the …

Hi I have been looking after my companies intranet and internet for 12mths now, and have managed to wrangle most of the everyday problems - through dedication and search functions on internet, even managed the most basic of web design courses (focussed mainly on CSS). I was employed as a …

I am trying to create a property for my UserControl that will allow me to work with data that the user selects. I have the property working correctly, in that it will drop down a list of data sources in the test project. I am working with the Northwind database …

How do I get [B]ONLY[/B] data type and name of all the columns available in given table_name

Hi, I'm having trouble building the correct syntax select statement for a system to handle support tickets. The table "tickets" has the following columns: id (int) inserted (smalldatetime) ticket_id (nvarchar) owner (nvarchar) subject( nvarchar) category (nvarchar) message( nvarchar) status (nvarchar) The id is unique for each record but the ticket_id …

[I]In this example I'm using the AdventureWorks database in MS SQL Server 2005[/I] I was wondering what other people thought about Schemas vs. Roles when it comes to security access. If you have an employee who just started working for Human Resources and needed access to all the database objects …