[microsoft:sql-server] Forum Topics

hi guys, in one of my .NET applications I need to connect to localDB but the code I wrote originally was for sql express and now it's returning an error understandly. Does anybody know what's the equivalent of this for localDB please? protected void submitData(object sender, EventArgs e) { hookUp …

Hi I have an issue in store procedure. Error is Msg 4104, Level 16, State 1, Procedure W_usp_SO_Table, Line 38 The multi-part identifier "dbo.SVendorMaster.SVCode" could not be bound. Insert table is working fine. But update command is prompt the error Pls advice me Maideen Here is SP SET ANSI_NULLS ON …

Good day all, I am a newbiew in C# application. I am designing a Laundry application, and I want to insert data from textbox, datetime picker and the gridview control into a database table.. I am using SQL Server 2008. This is the window form and controls on it:Form with …

Hi I do not know how to sum the one of the column in #table temp table It is my SP SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_Customer_Due_Until_Now] @Code nvarchar(30) AS BEGIN SET NOCOUNT ON; select code as Code, Name as Name, sum(Nett) SINETT into #tableSI …

please assist. i can not connect to my sql server (172.16.15.119). i always get this message"Fatal error: Call to undefined function sqlsrv_connect() in C:\Program Files (x86)\EasyPHP-12.1\www\malunde\connect.php on line 5" and the code that i used is: <?php $serverName = "172.16.15.119"; //serverName\instanceName $connectionInfo = array( "Database"=>"TPA-CS_UAT", "UID"=>"sa", "PWD"=>"tpa123"); $conn = sqlsrv_connect( …

Hey all, so i am working on database queries. Add and delete are working fine. I am having trouble with Edit Query. This is what i am getting: Incorrect syntax near 'Name'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace …

Good day, gurus of this well-known site. I am using vb.net 2013 Ultimate and SQL 2012 and can someone show/link me how to save and retrieve a word document from SQL database? Thanks

Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER …

Hi again. I am on the part where I am ready to publish my .cs program and tried to install it to my friends pc when I noticed it doesnt connect to the sql and just makes an error, I noticed that i declared all my paths like this: Sample …

Hi Can any one please help me on the below issue. i can able to display values for texbox. but i don't know how to load the values for <div id='txtHint' name='ptype'></div> and if i change any value in conn_type it has to display. **test.php** <form action="<?php $_PHP_SELF ?>" method="post" …

So hopefully the title makes a little sense, but I'll explain a little more. Currently I am developing a program at work that is designed to query a SQL database for results. The code is meant to be stand alone, a single .exe that can be run on any machine. …

I need to know if there is a way to improve the below function as it takes long execution time UserDefinedFunction [dbo].[GetChildrenAccount] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[GetChildrenAccount] (@AccountID INT, @DateFrom DATETIME, @DateTo DATETIME, @TypeTransaction INT, @Currnecy INT, @Branch INT) RETURNS DECIMAL(18,3) AS BEGIN DECLARE …

There are a lot of examples demonstrating how to connect to ms sql database from windows form application using Visual Studio Professional (right-clicking on the project name -> "Add" ->"new item" -> "LocalDatabase" -> give a name with .sdf extension to the newly created database - > and so on …

Hi everyone, Thanks for visiting this thread. I have recently migrating my MSSQL database from one server to another server by copying the database. The database that I copied contains the ASPNET membership and other related tables. My asp.net web application is currently pointing to the new created MSSQL database …

Hello all, zoidmaster here. I have a question regarding work with a MS Access database. I have the code written out from a tutorial I found online for a basic database, however all it can do with the database is read, add and delete lines from it. I'm trying to …

I get the error "Syntax Error (missing operator) in query expression" sql = "SELECT Chores.ChoresID, Chores.ChoresDate, Materials.MaterialName, Advisers.AdviserInit, Advisers.AdviserSurname," _ & "Area.Area, Chores.StudentNo, Student.Forename" _ & "FROM Chores" _ & "INNER JOIN Materials on Chores.MaterialID = Materials.MaterialID" _ & "INNER JOIN Advisers on Chores.AdviserID = Advisers.AdviserID" _ & "INNER JOIN …

Hi I want to create a plain c++ program which need to connect to SQL server through odbc and retrieve values and display it. I am using qt but i need it in plain C++ . can u anybody suggest the way to achieve it . and any free api …

Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. …

I am creating a project in winforms in vb.net. My requirement is to update and delete records in SQL database with a button click event. My update coding updates the whole table instead of a particular database row.I have four columns in my table. Is there any coding way where …

Is there a way to get a total counts from the resultset of two unions? This will be for DB2. select count(*) from ( select count(*) from xyz where abc='1' union all select count(*) from x1y1z1 where abc='1' )

I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare …

Hi All, I want the query to take the sum of individual rows. It can in MSSQL Query or Mysql Query. Please help.. Thanks in Advance.

Hi guys I need to make notification icon to any computers in Hr department when i added new Employee because my employee in my company forget to tell each others about any new employee added so that some process will by delayed Meaning IF i have 4 computers in HR …

This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The …

hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …

Hi, I have to correct some data in SQL Server 2008 R2 database for an accounting system that was accidently over written. Basically I've to take stock items with fixed prices and compare those fixed prices against Sales Order Transactions for the stock item and correct entries where the transaction …

I have written a SQL query to find product information in a c# program and it doesn't seem to work at all! I have tested a variety of other queries with my C# code and it works fine, but this throws an exception every time. SELECT TOP (1) CONVERT(varchar, tmpRptAssetEvent.EventTimeStamp, …

I have a multicolumn listview. There are three button Add, delete and Updata. List is working fine, it add, delete and update list data. But i want to save every row inside listview when i click save button. Bellow is my XAML. <TextBox Canvas.Left="12" Canvas.Top="12" Height="23" Name="textBox1" Width="120" TextChanged="textBox1_TextChanged" KeyDown="textBox1_KeyDown" …

Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen

Greetings, I'm facing a problem with the SQL Server and this problem concerning numbers when compared each other and these numbers are stored in the columns of data type NVARCHAR or VARCHAR. For example, if I'm having a column with data type NVARCHAR and it contains such values: 1 2 …

Hi guys please am new to c# sharp am having trouble to insert Events into the databse for an application am building I keep haveing the this error"The connection was not closed. The connection's current state is open." please any advice on what to thanks in advance guys. here is …

 Hello again, I am now encountering the above problem. i dunno what to do and tried everything. my Column for Capital is decimal so i dunno why it is saying varchar. my codes are con.ConnectionString = //insert data source; if (con.State != ConnectionState.Closed) { con.Close(); } cmd.Connection = …

Hi all, I have created a table in which i have a DateTime Column . i need that i dont want to insert values in that column from the front end. i have created a trigger for that purpose. whenever i insert a row in that table the dateTime column …

What is meant by the bold part of the below paragraph An index is a copy of select columns of data from a table that **can be searched very efficiently that also includes a low-level disk block address** or direct link to the complete row of data it was copied …

I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change …

I have small issue with my datagridview and crystal report I am using this code for display my crystal report but my problem is I can display only one row from data grid view But I want to print all rows randomly selected from datagridview in crystal report Private Function …

I'm using InstallShield 2010 and I set the SQL Server 2008 Express as a prerequisite. However, I have an instance of SQL Server 2008 developer edition installed on my pc, the SQL Server 2008 Express prerequisite windows always appear. How to cancel such window if there is any instance of …

I have a code behind in my web pages and I'm trying to write Greek characters in my SQL 2010 Tables. I write in my Tables but what I get is ????? why is that? What I have to do in my SQL in order get the Greek characters? Thank …

Hi all, I was just wondering, how do I go about making an asp.net application accessible on the internet? The application is also linked to a SQL database (created in visual studio). I have got server space available but I'm not sure where the sql database needs to be copied …

Hi, I want to create a trigger to increment value of my VisibleNo field if it gets duplicate value. My Application is my multiple users at same time . When at first suppose two users open application it gets same visible no and it saves duplicate number. I want use …

Hey good people, I hope you are all well. Ok so here is the scenario, i have 4 tables that i have made in sql server 2008. I am using a drop down menu to diplay their names. Like this...  I am going to use a dataGrid view. …

I want to know that how can I use date picker and show that particular records in datagrid. I am using vb6.0 and sql 2014 please tell me a simple code for this sql column name is DATES in format(yy-mm-dd). Thanks it will be a greate help....

I'm trying to compare a date obtained from maskedTextBox accepting short date, with a date from an excel sheet. I need to select those rows from excel file that are equal with the date from the maskedTextBox and display them in datagridview. The problem is that i don't get any …

What is the exception that verifies if the input is in the specified sql range?

I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)

I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)

I want a parse to convert a number to different types of sql server data ranges available. For example, for an input to the firld of kind int I have parseInt, for another kind that is float I have parseFloat. How can i do parseTinyInt(), parseSmallInt(), parseBigInt(), parseDecimal(), parseNumeric(), parseSmallMoney(), …

hi again, so uhm in my project i am using sql server 2008 . and I had used vs2010 ., now all is good but i tried to follow a tutorial ([Click Here](https://www.youtube.com/watch?v=mBZWu-ZcR7M)), where he uses a entity so i followed tnd now my problem is that: everytime i put …