3,481 Topics
 | |
| | Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 … |
| | I want to make a recipe website.In that I had added the add to favourite button.If i click my favourite button the recipe which i clicked will add to favourites.I i re-click it will remove from my favourites.It is controlled by the status field in the favourites table in sql.How … |
| | I’m going to use main report and sub report for showing some details. Main report has InvoiceHeader Part and sub report has invoice detail part. Invoice Header and invoice detail has 2 SPs. SP_InvoiceHeader (Use for main report) ALTER PROCEDURE [dbo].[testSP1] @invnoH as varchar(20) AS BEGIN SELECT * FROM INV_HEADER … |
| | Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 … |
| | Hi I did the stored procedure in mssql 2012. working fine in server. I have an issue that I need the output of my SP into HTML Report Format in aspx.page with Sub and Grand Total I no need GridView Pls advice Maideen My SP SET ANSI_NULLS ON GO SET … |
| | Hi Everyone. Background :- Winform App creates database in MSSQL LocalDB & creates tables. Data is imported & analysed then report is created. At any point in the process the user can start a new project & tables are removed to be re-created later as the user progresses through the … |
| | hi..can somebody help me? how can i have a conditional join in my statement. i have a parameter to be passed to the SP: @pRemarks my main query: select * from MasterList if @pRemarks='ALL' then my query will be: select * from MasterList inner join tblPositionLists on tblPositionLists.Position = MasterList.Position … |
 | i am using asp.net datalist to retrieve text from database field, when i put an integer value like 10 in where clause of select statement then it retrieves data from databse on next page but when i used variable (which is used to store value sent via query string) then … |
| | Greetings, I'm trying to setup the SQL Server 2008 Express Edition using a command line Setup.exe /QUIET="False"/QUIETSIMPLE="True" But I always got a message saying that QUIET expects a Boolean value and what I'm passing to it is a Boolean value do any one knows what I'm missing  |
| | Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to …  |
| | Hi guys, is it possible for me to downgrade server . i tried to restore .bak file from 2008 r2 to 2005 but it has a compatibility error./ can anyone could help me on this matter. Thanks in advance .  |
 | In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out … |
| | hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM …  |
| | 1. What exactly is a surrogate primary key? 2. Is a surrogate primary key just a made up attribute inserted into a table by the database administrator? All I know is that you use a surrogate key when there is no primary key or the natural key may not be … |
| | Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" …  |
| | I Have one table in sql Date Day Start Time End Time Subject Teacher 2014-06-02 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-10 Tuesday 2:30 PM 04:30 PM Science Mr.Ayar 2014-06-16 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-02 Monday 3:30 PM 04:30 PM Maths Mr.Smith I want to make … |
 | Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no … |
| | I have 3 tables --Ticket_Lines (parent), Labour_Items (child), Part_Items (child). Table Ticket_Lines has 2 primary keys (ticket_number & ticket_line_number) I know that you cant have two seperate primary keys in one table so would this mean that ticket_number and ticket_line_number is a composite primary key? if that is correct, is … |
| | Hi I have the following code that uploads images and other files to an SQL Server DB on GoDaddy via a FileUpload Control on an aspx page. Public Function InsertData(ByVal cmd As SqlCommand) As Boolean Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim con As New SqlConnection(strConnString) cmd.CommandType = CommandType.Text cmd.Connection … |
| | i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL |
| | # Heading Here # how to store the coordinates (points) of a line as x0,y0 ,x1,y1 .....xn,yn in database MS SQL. coding is in c# using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsApplication6 { { List<Point> points = new List<Point>(); … |
| | Not sure where else to put this, I apologise in advance if its in the wrong place. I'm trying to migrate a program from one server to the next without having to completely re-edit every configuration file. To do this, I need to enable the sql SA account, which I … |
| | hi i created login page using php and mssql but i got an error **"Fatal error: Call to undefined function mssql_query() "** **heres my log in code** <form name="log" action="log_action.php" method="post"> Username: <input class="form" type="text" name="name"><br /> Password: <input class="form" type="password" name="ssn"><br /> <input name="submit" type="submit" value="Submit"> </form> **log_in form** …  |
| | Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance. |
 | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks  |
| | I'm working on an application for a joint-stock company. A joint-stock company is a business entity which is owned by shareholders. Each shareholder owns the portion of the company in proportion to his or her ownership of the company's shares (certificates of ownership). This allows for the unequal ownership of … |
| | I have an identity (auto-increment) column in my mssql table, which is also my primary key. I want to use these numbers on my form, such that when I open that form, the auto-increment id will already be displayed on a textbox (so I wont have to type it in … |
| | hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins …  |
| | Hello, I have my password column with varchar(50) datatype. now i have created a new column NewPassword binary(16). I want to convert password varchar data to binary(16) format in NewPassword column. How can i do it? Thanks. |
| | I am trying to add a Mysql Report to Reporting Server. I can call the stored proc and all the info appart from the date will show. So i was wondering if there was a way to do convert the date in mysql |
 | Here is a sample code snippet of logging in a user against a user table in an MSSQL database with password encryption. Scott Knake |
| | Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for … |
 | public string Data() { string dohvat_podatka = ""; using ( MySqlConnection con = new MySqlConnection("Server=xxx.000webhost.com;Port=3306;Database=xxx;Uid=xxx;password=xxx;")) { con.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT ime FROM `nastavnik` WHERE prezime=@prezime", con)) { cmd.Parameters.Add(new MySqlParameter("prezime", "Carić")); using (MySqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { dohvat_podatka = dr.GetString(0); } } … |
| | COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> … |
| | I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied … |
| | Greetings, I'm having a table that I need to retrieve its data in a specific order based on a column value(s). I need to retrieve first all rows that have the value 0 in that column in ascending order (default order) then rows that have value(s) greater than 0 in …  |
| | I made an online application to store employees information in MS SQL,I used Disconnected model and I made my class for "DataSet configuration" and call method in it in The "Form_Load" event. This is the class public static string constr = ConfigurationManager.ConnectionStrings["cnn1"].ConnectionString; public static DataSet GetDataSet(string stored_name, string table_name, params … |
| | Hey guys, what am i missing here: Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Using sqlConn As New SqlClient.SqlConnection(sqlConnString) sqlConn.Open() sqlConn.Close() End Using End Sub Public Property ServerName() As String = "myip" Public Property DatabaseName() As String = "mytable" Public Property Login() As String = "sa" Public …  |
| | How can I perform SQL Server backup recovery task? Please recommend solution for my query. |
| | Hi I am using MSSQL ODBC Connetion for my project in PHP. I have created login form with PHP and MSSQL with ODBC Function. Can any one please help how to use SESSION to carry on to next page without get function. |
| | I'm an experienced ASP/MSSQL programmer trying to make the move to PHP/MYSQL and I've been able to wrangle my way up to now. I have a simple SQL query that works great in mymcadmin but gets lost in PHP. I've simplified it a bit here but this is the actual … |
 | Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & … |
| | Hi, I need to save the inserted password on MSSQL as md5 encrypted one. Basicaly when the user inserts the password on the textbox, it must be encrypted before storing it on the MSSQL Database. How can I do that? This was made from DreamWeaver CS6. Thank you the code: … |
| | Hi. problem in where insert data into table. Using vwd 2012 and Mssql 2012. Insert command is working fine in first record. If add another record, it shows "Procedure or Function has too many argument" I have tried may way, I could not solve. Pls help me. Below is my …  |
 | Hello Im trying to display a label when my program starts, to check the server status.. For example if the user is successfully connected to the server it should say on the label "Connected" and if not the label should say "Not Connected" , my Database is located on a …  |
| | We have 2 Tables, One is Primary Table and another one is a Transaction Table. Both Tables are identical. We have to insert or update the record in Primary Table, based on Transaction Table. If a record is found identical on primary keys for Primary and Transaction Table, we would …  |
 | I wrote my first trigger and it giving error UES TRY GO CREATE TRIGGER cust_update ON TRY FOR UPDATE AS IF UPDATE (custno) BEGIN TRANSACTION RAISERROR('CUST NO CANNOT BE UPDATED',10,1) ROLLBACK TRANSACTION END Any idea ` |
| | What is the meaning that Database management systems allow access to and storage of data independently of the interal representation of the data? what is meaning of independently of the interal representation of the data? |
 | I have been attempting to crack this nut for several hours now but I cannot figure out what combination of query code is required to achieve the exact results I am looking for. I have two tables: Music and Playlists The fields for Music: ID (Primary), Track_Name, File_Path, Date_Added, Artist, …  |
| | Why is stored procedure is better than executing a sql query. What is meant by exeution plan |
The End.