[microsoft:sql-server] Forum Topics

Hello everyone, I am current upgrading some of the functions on an inventory system. Current system accepts manual data input from the user and stores them in a SQL database. One of the inputs is control number which is a primary key in one of our table so it needs …

I am using Windows Vista Ultimate. I was getting an error while installing MS SQL server express edition 2008 R2. I use VS 2008. I cannot find any any correct version of power shell on the internet. Please Help !

Hi, So i've tried asking this question many times and haven't been able tp come up with an answer so i'm trying again in a much more understandable way, well i'll try.. [B]Scenario -[/B] [LIST] [*]Ok if you think of facebook, there are many different users. [*]These users are able …

Hi everyone, I want to implement an "achievement" system of sorts into one of my projects. Similar to StackOverflow where if you do a certain thing or answer a certain number of questions etc you get a trophy that is linked with your user profile. The membership section of my …

HELLO GUYS.. IM NEW TO THIS FORUM.. WELL.. MY I AM DEVELOPING AN HELP DESK SYSTEM AS MY FINAL YEAR PROJECT.LANGUAGE IS c#,SQL SERVER 2005,VISUAL STUIO 2010. I HAVE 2 COMBO BOXES. FIRST ONE IS REPRESENT COUNTRY, SECOND ONE IS CITY, WHAT I NEED IS IF I SELECT A COUNTRY …

Hi. I'm having a problem with that code. Im getting this error: [I]Warning: mssql_execute() [function.mssql-execute]: message: Error de conversi�n al convertir una cadena de caracteres a datetime. (severity 16) (Translate: error converting string to datetime) Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed[/I] But I dont use datetime in this script! …

How can i write my data from EditBox to SQL Table whit using ADODataSet,ADOTable and DataSource? Please help me? and write Example Code...

Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD …

Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which …

Hello! I was looking for some help with something I'm trying to accomplish with MS Access. I have data set up in the following manner: [CODE] CUSTNBR|TRANSYTD| RPTDATE --------------------------- 1 | 7 | 5/28/2010 1 | 10 |12/31/2010 1 | 2 | 4/29/2011 2 | 8 |12/31/2010 2 | 6 …

Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List Especially with table or View

Hi guys Ive created a piece of software to extract data from 2 fields in an mssql table, and using php translate them into a graph. Im now trying to extract the field names as titles for my axes. I'm using sqlsrv_query s and have retreived data from the table …

Guys i have created a simple Java Desktop application in netbeans.I want to connect it with SQL server 2008.I want to know how to connect it by using ODBC.Plz help me.....

Ok I'm new to coding and am trying to figure out how I can code in Visual Studio C#. I have a database table that has 3 columns and 10 rows. The column headings are Status, ID, and EmployeeName. In the Status colum, each row has a single digit from …

I'm novice to C#.net & i'm using Visual Studio 2010 as the IDE.I have created a Desktop Application in C# & i want to connect it with the Database in SQL server 2008.Friends can you tell me the code or web links to solve this issue.....

Is it bad practice to create relationships between tables where the PK is an identity AKA auto incremented? The reason why I ask is, while identity keys won't repeat, they are set based on the order that someone enters data, so the first entry is 1, second is 2 etc... …

I have a table named "Table1" Its schema with data is like this [CODE=text] Id col2 col3 col4 col5 isUnique dbUnique 1 red 3M 1995 UK 1 null 2 red 3M 1995 UK 0 null 2 red 3M 1995 UK 0 null 3 red 3M 1995 UK 0 null 4 …

hay guys... i m new here and having problem in finding a row through a combobox i did that with a simple text box it is working fine here is the coding [CODE] private void btnFind_Click(object sender, EventArgs e) { string searchFor = textBox4.Text; int results = 0; DataRow[] returnedRows; …

I am working in SQL 2005 I want to Create view for one table. Table Name abc 1. id 2. name 3. percentage 4. marks How can i create view for one column I want to search the name and makrs and name and % both have searching on name …

Hi Guys, I am working on converting a console application into a user friendly GUI. The actual application is written in visual C++ and person has no information none what so ever on how to run it. So to understand the technique I am trying to experiment with the application. …

Hello :D we've been working on this simple student database where we can add, edit and delete a student record... sooo going straight to the point I'm having problem with displaying details from two different tables as you can see we can only open using one connection string and try …

Hi. Here's my scenario: I have a native Windows service running on a machine. The service is installed under Administrator privileges. Once per day, the service fires, creates a login to SQL (using the administrator account), queries a specific database (read only). The database is stored locally (same machine) and …

Good Day all i have a SQL Job and i want to change the times in the job programmatically from C#. The application that will change the Job Settings will be accessing the job remotely. Is is possible ? Thanks

Hi guys, I am creating a window application in vb.net that need to use sql server database. I want to install this application to client machine without installing sql server so that my application can still connect to a database is there any way for this ?

Hi. I've been trying to populate a <select> option list in HTML by querying a Microsoft SQL Server database. For some reason I can not do this by mixing the scripting code (VBscript) with HTML. If I place the query between the <select> and </select> tags it does not run …

I'm very new to programming and was wondering why I am receiving a warning. "Function Checkbox doesnt return a value on all code paths. A null reference exception could occur at runtime when the result is used" I then want to execute this function through button.click event: CheckBox.ExecuteNonQuery() [CODE]Function CheckBox() …

Hey, as a part of my semester project. I've made an application which is using the database from the data directory. But i wanted this application to be distributed and for others to be useing it on the same lan etc. So do i just have to change the connection …

Hi, I am doing a window servise application using VB.net. I have faced problems with sql suery, as below: [CODE] Dim dt As New DataTable() SQLStr = "SELECT FautyScanTbl.Model, FautyScanTbl.Version, FautyScanTbl.WIP, FautyScanTbl.ScanNo, FautyScanTbl.LotSize, FautyScanTbl.SerialNo, FautyScanTbl.PIC," & _ "SerialNoTbl.SetWeight, SerialNoTbl.AccesWeight, SerialNoTbl.pdmid, ScannedPartNoTbl.ScannedTime " & _ "FROM FautyScanTbl LEFT OUTER JOIN " …

I have a application which take data from CSV and dump to the respective table using SQLBULKCOPY I am using the same connection string for truncating data from the same table and while writing to server SqlBulkCopy bc = new SqlBulkCopy(connection_string1.ConnectionString, SqlBulkCopyOptions.TableLock); bc.WriteToServer(dt);//Its giving exception on this line I am …

The date stored in my db is in the following format: 2011-06-10 17:15:26.000 2011-06-10 17:15:27.000 2011-06-10 17:15:28.000 2011-06-10 17:15:29.000 However I intend to retrieve the date above using the format below: 2011-06-10 How is it done? Your help is kindly appreciated.

I'm trying to import a Visual FoxPro database into SQL. The database is a free table directory data base, and I can import all but 3 of the tables. All three tables that won't import give me the same error message, that the memo file is missing or invalid. I …

hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to …

I am taking a database course and we are required to create some SQL queries. So don't give me the answer if possible. Just let me know what is wrong with this code: [INDENT]SELECT p.pat_id, p.pat_first_name, p.pat_last_name, p.pat_dob, ph.phys_last_name, s.service_desc, v.visit_date FROM Visit as v LEFT OUTER JOIN Visit_Service as …

I would like to auto-generate a column which has a mixture of both numbers and alphabets. Like AA01 or AC24. I want to start at AA00 until AA40. From here i will go to AB00 until AB40, and do likewise for other subsequent alphabets until the last one which will …

Hi I m Having a Problem in retrieving records. I want to get nth maximum value in a column. I have tried it using top select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc) But i m getting all the n records. Any …

We have 4 tables with field types like NVARCHAR and SMALLINT and we have 4 tables in the same database with VARCHAR and SMALLINT. The all reside i the same MSSQL2008R2 database with a database collationtype LATIN_GENERAL_BIN. If we run a simple query on the VARCHAR tables it comes with …

Hi everyone, Thanks for viewing this post. I have a question about SQL. May i know how to remove rows that have NULL value in one of the colums. SELECT name, grade, age FROM education If let say grade 1 of the rows is NULL, how do i remove that …

Hi In my compnay we use web based application and backend as sqlserver 2005.recently this backend is move into another new server.I restore database backup in new server.Issue is after 4 days I saw transaction logs file size is more that 16GB in new server .In old server transaction log …

i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the …

In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring …

Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this

Here is the condition,i have a table with the records for every months per year. I would like to retrieve the records only for three months per year. Lets make this clear, the records would be around Jan~Mar or Apr~Jun or July~Sept or Oct~Dec. Current date is 1-May-2011, so the …

Hey. i have a table that has the columns of A,B,C,D and another table that one of the coulmns the VALUES of A,B,C,D i am trying to subquery the 2nd table at the coulmn that stores the abcd. and the result act as a column name for the 1st table. …

Hi i am using .net 2.0 & a window application which is connected to sql server there is checkbox in the application. i want to bind the checkbox with database field which is bit type 1 or 0 please tell how to ? thanks in advance

I am facing problem in storing an image file into sql server. Following is my jsp page form tag which calls a servlet which has the storage code.. [CODE] <form name="form" action="NewServlet" method="POST" enctype="multipart/form-date"> <input type="file" name="file" size="20"> <input type="submit"> </form> [/CODE] here is my servelt code for the same …

Dear All, I have a search page on which I have two DropDownLists. One for Catagory and another for Item. When I select both of them it takes me to the result page and displays the result in GridView. It works for a single value but for more than one …

Hi, I have two DropdownLists. One is for Category and another is for Product. The concept is that with each Category and Product selected, the website will display the result on another page and show all the results present in the database. With more than 25 Categories with me and …

hi guys i know this is just a very simple but i do not know to get started.. im developing a loan mng't system wherein the starting application of the customer say for example today. 06/08/2011, the initial payment will be on 08/08/2011.. how am i going to that do …

Hope someone can help [B]I am using Visual Studio 10 Languague VB [/B] It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column …

Can someone please tell me why the results of my query are not appearing in my console application? I have a feeling it is something wrong with the console.writeline or readline [CODE]Imports System.Data Imports System.Data.SqlClient Module Module1 Private Property Sql As String Sub Main() Dim ConnString As String = "Data …