[microsoft:sql-server] Forum Topics

[code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace CarsRUS { public partial class Cars : Form { private SqlConnection conn; private SqlDataAdapter daAddresses; private DataSet dsAddresses; private DataGrid dgAddresses; private const string tableName = "CarRUS"; public class Customer { …

Hi, I recently imported about 18,000 records from filemaker into access. I initially exported the data as a csv file, i then opened it with excel and saved it as an xls spread sheet. Once i cleaned all the data i proceeded to import it into access, however i now …

DRIEND FRIENDS, I am given a project "hospital administration database" Could you please guide me how to start and proceed. Thanks and Regards. Shariq

Hi Guys It may be friday, but I am having a real brain fade with this one. I have one table which contains several columns (see below) I need to match names in the tables. The first name is in column childname1 which contains the full name, the column I …

I try to create an forgot password application. in the application, in order to get user password, user must do some input. there is 4 input : Username, Name, Security Question, and Security Answer. [CODE]Try If TextBox8.Text <> "" Then kueri = "select Username, Pass, Nama, SecQue, SecAns from Account …

Use this code [code] sql = "SELECT products.endDate FROM products INNER JOIN " sql = sql & " auctionevents ON products.idsupplier = auctionevents.idSupplier " sql = sql & " WHERE (products.endDate > CURRENT_TIMESTAMP) AND (auctionevents.ID = "&id&") AND (products.ListHidden <> 1)" [/code] but if the server is not run the …

Hi. I have a question to advanced SQL programmers/users. I would be very grateful if you could explain me in simple words why we use multiple joins on the same table (for example multiple left outer joins) - what benefits it brings? examples would be appreciated best regards q

hi guys, I am a fresher vb.net programmer. I have a requirement of storing employee's image in databse and retrive them in a form. I could insert image into the database but when I am retriving it , it does not get working. So if anybody knows the code for …

what is the differances with SQL tables and relation modelling?

Hi, I have created a temporary @table and while inserting ,i am using dynamic sql.But this is not getting executed and throws an error that "EXECUTE cannot be used as a source when inserting into a table variable" i am using SQLServer2005. Dont know where i am going wrong [code] …

I am trying to capture the COUNT of employees who are off by running a query from a table that has employee name and START DATE and END DATE of their vacation days throughout the years. I need to pull all employees who are GONE over a period of DATES …

I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses …

Thing is... I'm trying to insert a new records into database, one of those records is a "datetime"...when I type a wrong date, and try to insert those values into database, i get an error (about wrong typed date etc.)...ok, that's fine, things need to work that way. But here …

PRACTICA EXAMPLE FOR Scheduling Jobs in SQL Server 2005

[code] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.IO; public partial class Default4 : System.Web.UI.Page { SqlConnection db = new SqlConnection("database=bank;server=.;uid=sa"); protected void Page_Load(object sender, EventArgs e) { Panel1.Visible = false; } protected void …

Hi, I need help, I am trying to connect from remote windows xp computer B to ms sqlserver2005 express edition in another windows xp computer A and got this error: java.lang.classnotfoundexception com.microsoft.sqlserver.jdbc.sqlserverdriver My software can connect locally to the sqlserver 2005 though in the local computer A, however when i …

Hi All, I am storing my automation results to sql server and the displaying the results in asp page. one of result coulmn is for error images(is test case fails it capture the image , for refrence of what went wron during playback) stored in local machine or QA server. …

i want to insert the datagridview data and other ouside columns data into a single table ,database is sqlserver by using c# can anybody help.

Hi,,, we have a database grown too fast... from 19GB last march 09 into 52GB this Nov 09... I search through internet on what happen why do database grow fast and i find nothing,, i found out on how to "sp_spaceused" query and the result says: database_name database_size unallocated space …

I'm currently studying SQL and have created two tables (Orders and Inventory). I have been trying to create a trigger on the "OrderDate" column of the Orders table to update the Cur_Stock value (to subtract the Quantity ordered from the Cur_Stock) on the Inventory table whenever a new Order is …

I've been trying to get a list of values from database using hibernate. I'm using MS SQL Server XE 2005 and using Hibernate 3.2.2 to fetch DB rows. I've tried JDBC drivers provided by Microsoft as well as jTDS but all I get is an empty list. Here is my …

Hi to all I am working in ASP.NET. I need to fetch an Advertisement Message from Database into JavaScript Variable. For example [CODE] <script type="text/javascript" language="javascript"> function ShowMessage() { var msg; msg = [COLOR="Green"]//Here Get from Database[/COLOR] alert(msg); } </script> [/CODE] How can we do that? Thank You

I need help i am tired of dealing with this program and trying to get it to work. All i am doing is reading each txt file i find in a direcory and finding certain strings in the text then counting how many i find in each file and then …

I have question about the listbox. My listbox is binding to a database, and I use SelectedValueChanged to determine which my record I chose, I also get a couple button to interact with the sorting but the problem is whenever I change the database, like update new sql query, it …

hi every one, i need your help how to upload and download any file type to/from sql DB (sql server 2005) using c# windows form application i need to upload and download image type and doc type or pdf type or any else type . i need these types to …

VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET

Hi... i would like to develop a net cafe automation project using vs 2005 as front end and sql server as back end... could u pls give your idea.. suggestions... views..experience..... to get me a clear idea about the work

Help please!!!! Is there anyone has a sample code on how to call the backup and restore of SLQ server using VB6. I already have it but, unfortunately the backend of my program is Ms access and I want it to use as SQL server. Any help is highly appreciated.... …

Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has …

Hi all, i use mssql 2005 I have a doubt, how to create a schedule for a query to run every day,the result should be saved every time the query runs, into a new file For the moment I use SQL Server Agent to do this daily, with a jobtask …

hey, I'm working on a project, where I need to save data along with the image in Sql server, using Vb 2005. i just need the code for the above one. please post asap need it urgently.

Hi,, i am a newbie in SQL server.. we have a database in our office.. I notice that since 2004 - 2008 our database growth was about 19GB, but since jan. 2009 to present our database grows from 19GB to 52GB... is there's something wrong happening in our database's configuration? …

Good Day All i have the Following that table [CODE] ID | ACTV |VENU |STUD | TRIES ===================================== 1 1 4 162 0 2 4 5 104 0 3 8 5 138 0 4 15 2 68 0 5 15 4 291 0 6 21 4 171 0 7 22 …

Hi to all I am going to create online quiz/test. It will be in different categories like PHP, ASP.NET, JAVA etc. Before designing I need to work on database(in SQL SERVER 2005). I need suggestions on that about number of tables and columns in those tables. If you guys have …

HI guys I am just started learning SQL server. I have installed sql server 2008 in one laptop (call it 1) and it is connected to internet now [LIST=1] [*]i want to access it from another pc which is connected with 1 via WAN. [*]and how to connect to sql …

hello everyone, i need a code snipet that can help me retrieve username and password and to authenticate the password in the database..

Hi, I am trying to transfer some data from a Mysql database onto a Microsoft SQL database. I would need your help on how to operate this migration as I am new to MSSQL. I have been looking on Google but there are not a lot of pages on that. …

[code] import java.io.*; import java.sql.*; import java.net.*; public class sqlDemo { int eno; ResultSet rs; ResultSetMetaData md; String /*insq,*/ selq; Statement stmt; public sqlDemo() { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver; DatabaseName= Admin.sdf", "sa", "deepa#247"); //BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); //System.out.println("Enter Employee id"); //eno=Integer.parseInt(br.readLine()); stmt=con.createStatement(); selq="select * from emp"; //insq="insert into emp …

I have created an application using C# which makes use of a MSSQL Express database. Now that my project is completed I would like to package the application and database into a single executable which can be run on any machine making use of the .net 3.5 framework. My questions …

Hi, I am not sure about how to solve the following task: I have a number of distributed PCs each with MS SQL server and a database. I need to maintain the databases (schemer changes, table changes, F. key changes etc.). I have a main sever where I maintain the …

Hi, In my code I'm getting a weird error. It's caused by this piece of code: [CODE]response = SQLCommand.ExecuteNonQuery();[/CODE] The error: There is missing a ; at the end of the SQL-instruction. My eyes may be bad, but I clearly see a ; at the end of this piece of …

can anyone help..plz i have a form called transaction view.in this form there is two datetime picker.dtpstart and dtpEnddate.i want to pass these two values to report such that the report will display transactions occured in the range specified by th e datetime picker there are 3 tables in my …

Good Day All i have the Following Function [CODE] private static void OMEGA_calcActvEqv() { SqlConnection conn1 = CommonFunctions.getSQLConnectionForThread(THREAD_DATA[0].ToString()); string SQL = "SELECT MAX(D.OFFS + 1) * MAX(R.OFFS + 1) FROM TBL_ROWS R, TBL_CLMN D; SELECT MAX(OFFS + 1) FROM TBL_ROWS;"; SqlCommand cmd = new SqlCommand(SQL, conn1); SqlDataReader rdr = cmd.ExecuteReader(); …

Hi, Anybody please tell me basic idea to create a tool which should be able to export data from SQL Server. I am familiar with java and MS SQL. Please help me. Thanx in advance.

Hi all i have question again, this is my code: [code] private void btAdd_Click(object sender, EventArgs e) { SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); DataView dv; string sql = null; string connetionString = "Data Source=GOD_LOVE_ME;Initial Catalog=ProjetDB;Integrated Security=True"; sql = "Select * from Material"; SqlConnection connection = …

If i have some xml in the form [code=xml]<root> <a>hello</a> <b> <bi>hiya</bi> <bii>hey</bii> </b> <c/> <d>hello again</d> </root>[/code] how can I a) count the nodes? i.e. a, b, bi, bii, c, d so 6 b) count the nodes that are non empty a, bi, bii, d so 4 ? i …

I am working on a project, its purpose is to search a database and display the results in a data list so they can be used. I have the search working correctly but it only outputs to a data grid. Help please! [CODE] Protected Sub Button2_OnClick(ByVal sender As Object, ByVal …

Hi, I have 2 dropdownlists on a page. (DDL1 and DDL2). The DDL1 is populated by values from the database using a table1. DDL2 is dependent on DDL1. As soon as a value is selected in DDL1 I need to populate values in DDL2, though using S table2 which is …

[I m still a newbie in ASP.Net] I want to create an interface with asp.net for an SQL backend. On the interface i want the buttons to be able to execute some stored procedures. Any Ideas? Or code

I have a query that works, I wanted to add another sum from another table, but when I do, the all the SUM values are wrong this works [CODE]SELECT Clients.ClientID, Clients.WholeName, SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE 0.00 END) AS 'Admin Fees', SUM(CASE WHEN (Payments.Creditorid = 3) THEN …