[sql-server] Forum Topics

Hi all! I have a simple procedure which should return an 'id' field if parameter is passed. The problem is that if I provide the single letter parameter it returns no records although there are matches. But if i provide the whole word as it's written in a table, I …

Hi guys, am trying to populate textboxes with data from sql server database. below is the code I am trying to use in Visual studio 2012, Vb.net. Private Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSearch.Click Dim query As String Dim MyConnection As SqlConnection = New SqlConnection("Initial Catalog=PayRoll;" & …

Hi to all! I have to install sql server first time. But I have a confusion that what is difference between sql server and sql server management studio? secondly is sql server management studio embeded in sql server or will it installed separately? If it will installed separartely then which …

Hi, using sql server 2012 as backend and coldfusion 11 as front end for development.Nowadays, weird scenario happening that the application is not working at some times. But there is no trace of any error in the coldfusion application logs or in the sql server part. The site start working …

Hi All, I have a problem when trying to change user account password in my project I am using Visual Studio 2013 and SQL Server 2012. This is the code I am using and I don't know to how to adjust it to check for the old password before changing …

Hi EveryOne, I have a following controls in my vb.net form: txtID txtName btnAddNew btnSave This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated …

some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position. …

Hello guys. I'm trying to create a registration form that takes in employee information. The error I'm getting is: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 I'm …

I am currently developing a CMS for my firm using .NET Framework ,ASP.Net(C#) & SQL Server Express 2008 ADV. Whenever a user creates an Article i want to genrate a permalink for each article so that navigation is simple instead of using query strings and exposing article id to common …

Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …

Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …

i need samples on calculating average the average of "C Program=50" "Html5=70" "DreamWaver=70" "SQL Server=80"

Hi everyone, I need help in selecting between date ranges. I have two dateTimepicker and want to retrieve only records selected between selected dateTimepicker.I tried but im getting all records. I'm using SQL server database. Here is my code: selectQuery = "SELECT * FROM EmployeeRegistration WHERE EmpJoinDate BETWEEN '" & …

how to export asp.net(using sql server as database) project from localhost to godaddy server??please help me

i would like to know if it is possible to translate my code according to a database(currently using microsoft sql server) the code i have it is encrypting and decryption on a file inside the microsoft visual studio project i want to connect it to the database this code is …

Hi, I have recently started working with SQL databases of which I have 0 previous experience. I have added the datasource to my project using the Visual Studio wizard and the DataSet appears in my solution explorer. Everything that I have read thus far has shown connecting to the SQL …

i am new in this encryption and decryption i would like to have my encryption appear on my database (currently using microsoft sql server) i create 3 forms : one for the registration which means when u will register, u will be able to access the 3 forms by entering …

Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features …

Hi Every one >>> I'm doing visual basic program with sql server database I need to Export database to but it in my own server and connect to my prgram but i can't do it could you help me ...

My web hosting plan does not include a database. Is there a way i can get around this? Like upload a .sql file or ms access db into my server and connect to it using php?

hello to all. I have used jdk 7 and now i have started to use netbeans8.0.1 i want to know that how to connect ms acces and sql server database using netbeans. Please send me procedure and sample code to connect to these two databases.

i need some help concerning the encryption and decryption i have a login table on my microsoft sql server 2012 but i want to do the encryption and decryption remember i have 5 departments and i want to direct each username and password to a specific department form that i …

Hi there, I have have a challenge with my application. I am developing it using VB.Net and SQL server 2014. My database contains 2k plus records. I used to search and return the results very fast when the database was still small. The problem now is that whenever i try …

i have two combobox and i have two database table in sql server 1st table name is Province and 2nd table name is City if i select province in my 1st combobox then show all cities against selected province show in the 2nd combobox when we click on combobox dropdown …

Hi I tried connecting to my database but I am getting this message The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server …

hi i'm struggling to read data from database i created a table with 5 rows as for Login form username and password i would like to have access to forms when i enter password and username of department 1 it shows department 1 but when i enter password and username …

Hi all! I have developed my application in VB.NET that uses a mysql database. From my application, I can make mysql backups and restore them. When i take a backup, the result is a .sql file which is saved somewhere. But as usual, one can open that sql file with …

My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at …

Hi im attempting to copy a php code and get it to work with a script im trying to create and i have come across the error below can anyone tell me whats going off any help would be much appreicated x You have an error in your SQL syntax; …

dear members, i need help, i have one datagrid and two dataset with two diff. tables, what i want is to insert data into datagrid and save grid data to other tabel in sql server.