[microsoft:sql-server] Forum Topics

Hello all! I have an excel file that looks like this: Time of Day Lap Lap Tm Speed 14 - Stoicescu Dan - Regularitate Coupe 9:40:50.835 1 2:47.462 88.763 9:43:37.584 2 2:46.749 89.142 9:46:33.319 3 2:55.735 84.584 9:49:58.901 4 3:25.582 72.304 9:53:13.988 5 3:15.087 76.194 9:55:50.639 6 2:36.651 94.889 9:58:49.884 …

Hello, I'm new here and I have experience in using PHP with MySQL but right now, I need to convert my code so that it can be used to connect to my DB in my SQL server. I have try out the code as follows db.php <?php date_default_timezone_set ("Asia/Kuala_Lumpur"); // …

I have a table in and MSSQL DB that list period and week start dates for any date in a financial year but the page is only display the week numbers and period number none of the dates does any body have any ideas please. <?php $serverName = 'DESKTOP-R7RU80H\SQLEXPRESS'; $connectionInfo=array('Database'=>'WebPortal', …

Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop …

Hi, I have one form with multiple reading data (using BindingSource) and I want to store those data + some text entry to third table (also using BindingSource DataGrid) Is it possoble to do that using sql statement ? I have connection to database. Picture is to show what I …

Imports System.Data.OleDb Public Class Form1 Dim pro As String Dim connstring As String Dim myconnection As OleDbConnection = New OleDbConnection Dim command As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click pro = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sinthu\Documents\Database1.accdb" connstring = pro myconnection.ConnectionString = connstring myconnection.Open() If myconnection.State = …

Hi, I want to copy the data in the PayJour table to the ARCPayJour Table using the Clients Table where the StatusCo = 108. The problem is that the Clients table stop at the first 108 it gets and then do the copy prossecc, but do not go through the …

As you may know, Transact-SQL debugger was deprecated in Microsoft Management Studio for SQL Server 18.0 and the functionality is no longer available. However, there’s nothing to panic about since Devart is rolling out SQL Complete 6.4 ( https://www.devart.com/dbforge/sql/sqlcomplete/ ) with code debugging feature honed to perfection in dbForge Studio …

I have a nested query that is counting how many invoices have been raised for a customer between a daterange which is working fine EXCEPT..... I am getting null in the Invoice_Count field and I would like to change this to 0. I have tried isnull(SUM(CASE WHEN Inv1.ih_credit = 1 …

I am crafting a code generator for something, and I have encountered some things that I do not know yet. Excuse the scambled eggs in this code, but could you please tell me what a job is, and how to get it to run a stored procedure for me? I …

I'm new to vb.net I wan to to make a retrieval of image into picturebox. This is my code: *All declaration has been initialize* Cmd= New sqlcommand ("select * from tblretrieveimages", con) dt= New DataTable sda = New sqlDataAdaptar(cmd) sda.fill(dt) Texbox1id = dt.rows(0)(0).tostring Texbox1name = dt.rows(0)(1).tostring Texbox1des = dt.rows(0)(2).tostring Dim …

Hi, I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so. please help me and give me proper syntex fro the same

How to insert data in sql server 2012 express using php pdo in wamp server 3? What connection string I need to use to connect in the database?

Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key …

$query = "SELECT COUNT (*) AS spo FROM NAME_TABEL WHERE BEFORE_OURCE_OBAT = '1' AND ROOM = 'ORCHID' AND MONTH (DATE) = '$ month' "; $row = sqlsrv_query($conn, $query); $data = sqlsrv_fetch_array($row); $spo = $data['spo']; ?> why an error appears after the program is run, please help ? Warning: sqlsrv_fetch_array() expects …

 Please help how to code this on vb.net with SQL server database

Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs …

All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu

Hi , i have two jsp forms ,one is student1.jsp and student2.jsp in student1.jsp name ,fathername,mothernames are input fields and student2jsp brothername and sistername's are there one database student(name ,fthername,mothernames,brothername ,istername's) what i want is to store two forms data into onedatabase . is it possible?then how?.

Hey everyone. I received this sql server error and I can't figure out where the trouble is: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: …

How do I process the xamarin forms that connect to SQL Server and export data to the listView ? I'm looking for this simple example. What do I find on google ?

<center><div id="piechart"></div></center> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['A', 'B'], <?php $query = "SELECT COUNT (*) AS a FROM TABLE WHERE A = '1'"; $results = sqlsrv_query($conn, $query); $row = sqlsrv_fetch_array($results); $A = $row['a']; ?> <?php $query = "SELECT COUNT (*) …

Hi guys. I have two servers: 1. Client Facing Production Server 2. API Server. The Client facing sever (Server1) sends requests to the API Server (Server2). Server2 is hosted with one staric IP address and is accessible through three domain names, e.g. **www.domain1.com**, **domain1.com**, **test.domain2.com**. Often times the Server1 seems …

Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point …

I am working on my company's ledger and my accounts department need a search ledger by COA id with from date to date. I am able to find the record from date to date but when I write the code for COA ID, then it ignore the date formula. Below …

in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] …

My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional …

Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …

TITLE: Connect to Server ------------------------------ Cannot connect to (LocalDb)\MSSQLLocalDB. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote …

I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ?

I created a worked sql query: select CONVERT(date, C.tDate) as dt, count(O.Id) as cnt from [Calendar] C left outer join [Order] O on C.tDate = CONVERT(date, O.Dt) group by CONVERT(date, C.tDate) order by CONVERT(date, C.tDate) And I want to rewrite it use LINQ: var res = (from c in db.Calendars …

Hi guys, im a newbie in programming, please i need help in populating ms datagrid from ms sql table, can anyone suggest me something thnx

Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the keyword 'FROM'." It's not clear to me what the error is. The code I've written is as follows: Dim strQ …

Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections …

Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes …

Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then is to query the database to see if that number exists. If it does, the message box displays the message …

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

I have a sp in mssql which gives multiple resultsets.I need to display the result in html table using php . I am using mssql_fetch_assoc() & mssql_next_result(). How to store each resultset in a array and retrieve it. $result=student_sp('1231','1') do curlybrace while($row=mssql_fetch_assoc($result)) brace $name=$row[name]; $age=$row[age]; $marks=$row[marks]; $term=$row[terms]; $Subject=$row[sub]; $html="<table><tr><td>$name</td></tr><tr><td>$age</td></tr></table>" $mark="<table><tr><td>$subject</td></tr><tr><td>$marks</td></tr></table …

Hi this is my first time using this site, so please bare with me. I'm also pretty new at coding and got thrown into connecting to a database in one of my classes. But anywho, I keep receiving a syntax error and I was wondering if anyone could help me …

can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp

I want when click on the Name Listed on a Listbox from the database to fill Textboxes with Username and Password of particular user from SQL database. I am able to see Names stored on the database on the listbox but when i click on the name its unable to …

** Cannot open MSSQLSSQLEXPRESS service on computer'.'. ** **What I have tried:** Dim myController As New System.ServiceProcess.ServiceController("SQL Server (SQLEXPRESS)") ------------------------------------------------------------------------------------------------------------ Private Sub Service_status() If myController.Status = ServiceProcess.ServiceControllerStatus.Running Then TextBox1.Text = "Started" ElseIf myController.Status = ServiceProcess.ServiceControllerStatus.Stopped Then TextBox1.Text = "Stopped" End If End Sub ------------------------------------------------------------------------------------------------------------ Private Sub Button2_Click(ByVal sender As System.Object, …

I hve encountered this error that I was using php pdo and wamp server 3.0. I couldnt insert data in ms sql server 2012 because it says that it couldnt find the table Error sql state[ 42S02] Base table or view not found: 208 invalid object name isys.ref_product sql insert …

Can anyone help me with a SQL string ? or point me in the right direction? I have a colum called ctn_node_path which has results like PARTS & ACCESSORIES > PSJOHNSON - SEDDON JOHNSON PARTS > JN - JOHNSON PARTS I am trying to split the string into three PARTS …

I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) …

Hi Pobably it is going to be repeated question but I wasnt able to find such thread. I just would like to do sql through C++ and I have 2008 ms database. What are free libraries available for doing such job? Thanks

A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is …

i have made leaves managment system ,now i want to mentioned leaves days in attendance register if employee take leave from 1-1-2019 to 4-1-2019 then 5 day display in attendance register as a (L) . kindly guide me how it will get done. here is my attendance register query in …