[microsoft:sql-server] Forum Topics

Hi Guys, I am trying to make a webpage using asp.net and SQL server 2008. Just a simple page through which data will be inserted to the database. But I noticed it is taking duplicate records as wel. So I used "Unique" constraint while the respective table and it is …

Hi All, I tried reading through this: https://www.owasp.org/index.php/Password_Storage_Cheat_Sheet . But I'd like to know if the following scenario is considered good practice for a simple login/registration system. The userlist table: create table simp ( USR VARCHAR (128), PWD varchar (512), SALT VARCHAR(512) ) I created a stored procedure to execute …

Hello I'm a newbie in SQL I have one pos system on my bar that work with ms sql server 2005 express On sql has one table with some settings.One from this settings can enable the software an html5 interface and the waiters can take orders via tablet or smartphone. …

Hi, I am trying to get the the number of rows that are populated in a SQL Server table. I am using the code below but it only counts one row everytime when I know in fact that there are 47 row in a particular table. Could someone please point …

so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with …

Hi Dw. I have a timer that in every 600 interval access the database and the database I'm using is MS Access database. The problem I have is that with this being said, the MS Access database has a limitation of 64 connections on each thread so this 600 interval …

In the code below i see this error when i try to connect to connection string this error appears Format of the initialization string does not conform to specification starting at index 0. How can i fix it? In the code below i see this error when i try to …

Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data from a vb.net datgridview. I have looked for a tool or examples but cant find any information that can point me to …

Hi friends i want to read a csv file and then store it in sql server 2005 table , know how to read a file but i don't know how do i write it in the table. plz help me

hello every one this my code to fill my combobox with the name of clients and i but the connection string in a module to let my prog workimg in any pc in the group But the problem here in the combobox says can not make the connection, I know …

hello every one i made a Simple sales program by vb with tables sql I have worked and use the following to connect with data con.ConnectionString = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\hany_\Documents\Visual Studio 2015\Projects\hanysql\hanysql\Database5.mdf;Integrated Security=True" Now, after the completion of the program I want to know what is the way to run …

cmd = New SqlCommand("INSERT INTO temp_balance ( debit, credit, accname ) SELECT Sum(temp_sheet.debit) AS debit, Sum(temp_sheet.credit) AS credit, IIf (debit < credit ,'loss','profit') AS expr1 FROM temp_sheet group by temp_sheet.debit,temp_sheet.credit ;", con) there an error i dont know the error incorrect syntax near ' )

How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement cmf.CommandText = "SELECT QUOTE_ID FROM RETENTION_LEAD_TRACK where CREATE_DTG > '2016 - 04 - 25 18:18:15.2891'" throws this error {"Conversion failed when …

I want to insert a table cell into a table from another table by select method and after, to display an error in text prompted from the user was not found. Can someone tell what's the problem with my codes? My codes are as follows: Dim Item As String = …

Hi all, I've been wrestling with CodeIgniter to work with MSSQL. Turned out to be a whole ordeal with changing the functions to use the newly updated sqlsrv functions. After all that, I still seem to have issues with it. While I'm working this out, I wonder if anyone has …

Dear All , Hope everyone is fine. I have little question. We use this query normally in MSSQL select * from emp where empid in (1,2,3,4) How to write this query in lambda expression. Is there any way to perfrom above mentioned operation ? Best Regards

Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. <?php $ic=$_SESSION['ic']; $query=" SELECT * FROM form WHERE ic='$ic'"; $result=mysql_query($query); $record=mysql_fetch_array($result); $query1=" SELECT * FROM login WHERE userIC='$ic'"; …

Hi to all ! I need your help. Actually I have enrolled in final year project and chosed Data Warehouse. According to the project scenario I made dimension tables and fact tables. Before making star schema, I want that you check my dimension and fact tables. I am giving you …

Hi Dw. I have a MS Access database that has 9 columns what I want to do is to retrieve all data from a database only on 5 columns. I think I have to use the `select * from data` but I don't know how to select the columns I …

Hey fellas, some time ago I started trying out Brackets, and guess what? Loved it! If you don't know, it's an open soude editor made out of html, css and javascript, powered by node JS and chromium and sponsored by Adobe. A lot of open sources projects coming together to …

Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number

At the bottom is my code and I want to save data on my joined table. Please advise or edit the codes. Thanks :D 'VB.net Public Class RadTechLP Private Sub RadTechLP_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'PNJKDataSet.Procedure1' table. You …

Hello! I have written a simple program which connects netbeans with SQL Server database. The program is giving an exception. I am displaying the source code of my program and exception below. Please guide me to solve this problem. public class dbconnection { Connection con = null; public static void …

1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into …

I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to …

Hi everyone, i need someone to help me. my code below will loop to fill the data .my problem now is i need to sum the total of the amount based on the region. How to get the amount based on region without enter the loop and only print out …

Hi, Does anyone have some good examples of ADO.NET code that demonstrates a coded connection to SQL Server such that bound controls bind to retrieve and update data. Thanks

Hey I have a problem with execute query into sql I got an error I want to add query like sql into sql can I put query by click on new query then i execute it I need to make the same idea but without open sql I need to …

Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …

Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it …

Delete checked item (one or more) from listview I write this code. Dim x As Long For x = LVEmp.ListItems.Count To 1 Step -1 If LVEmp.ListItems(x).Checked Then con.Execute "DELETE FROM stock WHERE [SrNo] = '" & LVEmp.ListItems(x).SubItems(1) & "'" LVEmp.ListItems.Remove x End If Next con.Close Set con = Nothing but …

Hello everybody i would like some worked on the field of **SQL test cases generation based mutation**. In fact i almost wrote the test cases mutation code and i generated mutated test cases. but now i want to validate thus inputs or test the mutation by verifiying the killed and …

I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …

Im doing a appointment booking site for a project And Im trying to disable radio button(s) if the sql statement returns true. Example: User selects a date from asp calendar and a timeslot is in the form of radio button I wanted that the count of radiobutton selection should be …

I have been searching and try out number of different articles regarding how to insert data using a wcf service. With every example I try I end up with errors. I need to created a wcf service and pass data to a database in a MVC 5 application. I'm currently …

hello guys My SQL Server doesn't restore a backup because of active connections. How can I force it?

hiii frnds i am work in vb.net windows application now in sql empid field is Unique (primary key) that how can i impliment and handle Empid manually

My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not …

Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > …

I am trying to get data from the SQL database with stored procedure using dataset and populate that data in combobox. It gives error as cannot find table 0. SqlConnection conn = new SqlConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; SqlCommand cmd2 = new SqlCommand("GetBatch", conn); cmd2.CommandType = CommandType.StoredProcedure; cmd2.CommandText = "usp_CAMR_GetBatch_Status"; cmd2.Connection …

I am using visual studio 2012 and creating a project. I want to use inbuilt sql server with VS 2012. I have create a service based databse i.e. student1.mdf. I have a button and when i click on the button, data should be permanentlly saved onto the database. But its …

Save value from the combobox for the index that will be changed. For e.g: If I have 5 items listed and 1st one is selected and when I change index to suppose 4th one, I need to save the value of 1st listed item at time of index being changed …

Hello I have VB.NET System ; I wanna to make setup (.exe) for the program. The Program depend on SQL Server Database. How I can make it exe file with the database, and to install all the configuration on any PC. What I shall do according to the connection string …

I am trying to populate textbox on winsows application from database. The stored procedure pulls data using datareader. Data looks fine when I execute stored procedure on SQL server management studio. But when I am trying to populate from the application its not getting same result. I apprecaite all help. …

hi i want a code with c# Programming language to select some picture and convert thats picture to binary and save them in sql server database. thanks

I have been looking at this code and can't see the errors. I would like as a test for myself to post a SQL query to a PHP file and do the query and return the selected rows. So what is wrong with this POST, and how do I pickup …

Hi, I hope I've posted this in the right place, please just tell me if not. I've been having an issue with connecting to a database from a website and have recieved this as an error message: *Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] …