[microsoft:sql-server] Forum Topics

Here is my code. INSERT INTO employees (1.Last_Name,2.First_Name,3.Title,4.Title_of_Courtesy5.,BD,6.Hire_Date,7.Address,8.City,9.State,10.Zip,11.Country,12.Extension,13.Notes,14. Reports_to,15.Photo); VALUES (1, 'Smith', 'Janet', 'Sales Manager', 'Mrs.', '12-30-1974', '08/05/2000', '123 My Street', 'canton', 'OH', '44720', 'USA', '4632', 'MBA from Ashland University', 'Andrew Fuller', 'No Photo Available Yet'); Here is error message...Msg 102, Level 15, State 1, Line 2 Incorrect syntax near …

I just want to know if is it possible to connect to a SQL server using a data link file in vb 2008? how will i create a valid data link file? How will i call the data link file in my program? please help me..

I want to validate username and password i.e.I created a table with two variables username and password in sql. I want to match table username and given username as well as for password. If those matches then only it should login. Please help me with the code sir

Hi Everyone I need a syntax for update statement LIke this: cmd.CommandText = "UPDATE tab(tab_id,tab_name) SET tab_name=@tname WHERE tab_id=@tab_id"; this one aint working ,Somebody please help. I have two textboxes tab_id,tab_name I have to Update tab_name based on tab_id,...when i Click content of datagridview then I will get the content …

Hi Forum, I need a funtion to retrieve data from more then one Table. The tables are not related.Field names are the same in all tables. The table list I get from a view and i need to go through this list and pull out any records from the different …

[CODE]<?php require('./configs/reg_conf.php'); function doesUsernameExist($name){ $exit = FALSE; $result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'"); if (mssql_num_rows($result) != 0){ $exit = TRUE; } return $exit; } if(isset($_POST['submit'])){ $user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']); $pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']); if($_POST['username'] == ""){ echo '<font color="red">Enter a user.</font><br /><br />'; } …

I have a SQL table that contains spam or naughty word phrases. I'm trying to decide how to take some text and determine if any of the values in the table exist in my text. In the past I have selected all of the phrases out of the database and …

For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time …

I'm trying to populate my textboxs with data from my database when the user name is selected but I'm having trouble getting the code right. Help Please! table users (there is a textbox for each of these fields) password lastname firstname Using upcmd As New SqlCommand("SELECT * FROM users WHERE …

I'm newbie in MSSQL, I would like to ask what web server should i use? Should i install IIS in my PC? I appreciate your suggestions... Thanks.. Mar....

[CODE]<?php $online = @fsockopen("112.205.30.106", 28000, $errno, $errstr, 1); if($online >= 1) { echo '<b><font color=#00FF00>Online</font></b>'; } else { echo '<b><font color=#FF0000>Offline</font></b>'; } ?></li> <br><li>Login Server: <?php $online = @fsockopen("127.0.0.1", 23000, $errno, $errstr, 1); if($online >= 1) { echo '<b><font color=#00FF00>Online</font></b>'; } else { echo '<b><font color=#FF0000>Offline</font></b>'; } ?></li> <br><li>World Server: …

Hi, Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve. Eg: field #1 field …

hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), …

Ok so I am able to create a user login system with data such as user ID, Username and a password. Here's the scenario - I add a field into the SQL table called 'Firstname' How do I retrieve the 'Firstname' of every user which relates to their user ID …

Hi, [B]There is a possibility that the server reset and there is nobody that can log in to system. I dont want my webpage stop working at this state.so I want it do its main job. The main job of this webpage(ASP.NET) is sending request to a client (via TCP …

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center …

Hi, I have a table Employee that has a coloumn EmployeeID, SupervisorID, and Active(values Yes or No).. I need to find the number of Active Employees(with Active as Yes) under each supervisor.. how can I write the query? I am using Access 2007. Thanks!

Hi, I have 2 level for signup memebr . 1-member 2-supermember now i send for each user value 1 or 2 to permission. SQL Table : id | name | lastname | permission | date | desc | username | password so in user profile page i have 6 link …

Hi, Am currently creating an interactive dating sms service using vb.net.but when i get to the point for user to find requested matching records,am only able to get the first 3 records. i want it to be able to move to the next 3 and the following 3 and so …

I would like to know how to increase the speed of data loading into flexgrid from Database(SQL Server).currently im using a loop but this takes a lot of time when there are alot of data...pls give me a solution to this problem.. Thank you

Can Any one Explain me about Isolation level in mssql server

Hi , I need advise for the server configuration for the following small business requirement as i am not an hardware expert. Need help to devide on small business rack mount server configurations with numbers & type of processors , Memory , RAID Hard drivers SAS .or. SCSI with type …

Hi All, I have a query that returns rows from a message table. Im basically trying to get the latest MESSAGE_TYPE for the user based on when the message was sent (MESSAGEDATE) At the moment I have a query that gets me almost what I want. It returns something like …

In my-sql i used a variable c and in a situation i used like c-- to decrement the value of c but while executing i came to know that remaining code in the line get commented, how can i avoid that without using c=c-1;

I have written the following Stored Procedure: [code] USE [BHPropertyInfo] GO /****** Object: StoredProcedure [dbo].[usp_UnitAvgByRM] Script Date: 08/26/2010 16:47:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[usp_UnitAvgByRM] -- Add the parameters …

hi i am trying to convert data from excel sheet to dataset\datatable using sqlserver2005 as backend, so anybody can help me . Thanx in advance.

Hi i'm new to programming . I'm creating a project in C#.net using visual studio. I'm facing problem. Creating a login button and a new login ID button. the new login ID should store the details in the database and when the same is entered in the login text box, …

how to establish a connection after validating all the fields in a form can any one please help me with code

Here is my code it gives me error "IsAdminuser is not member of PMS" what should i do now to resolve this problem. [CODE]Module GlobalStuff Public Function IsLoggedIn(ByVal PassUserName As String, ByVal PassPassword As String) As Boolean Dim ReturnBool As Boolean = True Dim cnString As String = "Data Source=ITS;Initial …

Do you know of any machines that would make a good SQL/server 2000 box. I want something new fast and dependable, but I dont want to run into problems like the OS disk not reading the storage controler, driver issues, ect... Thanks in advance

Good day everyone! I'm still a noob with C#.NET so patience pls! :) I'm making a Windows Forms Application with a database from MS SQL 2005 Express. I want to transfer this projects with the database to another pc. What should I do? Should I transfer the database (.mdf and …

I'm using a gridview that is working off an object data source. The object data source is connected to my class library, which has a function that delivers a data table to the gridview. This is the function: [CODE] public DataTable populateGrid(string command) { DB db = new DB(); SqlDataAdapter …

I am usins SQL server I need to fire a trigger when an appointment for the same date comes.It should not allow more than one appointment for a hall booking system,how can i do that? iam using a table called appointment and the logic i used is take the date …

[CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[createaccount] @account VARCHAR(15), @password VARCHAR(32) AS SET NOCOUNT ON DECLARE @DateActivated AS CHAR(8) IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) VALUES (@account, @password, @password, 'T', 'A', …

hi evey one ,i written code in c# language to take sql server 2008 backup using Sumo objects i am getting the error saying backup failed to [servername],the code is writen as following [code] try { sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); sqlServer = new Server(new ServerConnection(sqlConn)); dbList = new List<Database>(); foreach …

This is the error i get when im trying to Run my AccountServ.exe it pop ups an error DB LOG Connect Failed. SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

i want to insert rows one by one into a database in the sql server 2005. the problem is that i have tried all possible but the rows just dont get added to the database, i get an exception on executing this code, i get this exception Unhandled Exception: System.IndexOutOfRangeException: …

Hello to all, I am using MS SQL 2005. I have created 5 databases in it will same tables structure. The table contains the data in same structure. Now I want to merge all the databases in one database so that I can have all the data in respective tables. …

I have two forms. Form A and Form B. Form A has a datagrid that is populated from a SQL Database Table query. When a button is pressed Form B is launched that allows you to add a record to the database table. I need for the datagrid to be …

The following function works fine. [CODE] public int AddRecord(String MsgTo, String MsgFrom, String MsgCC, String MsgBC, DateTime DateSent) { SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@MsgTo", MsgTo), new SqlParameter("@MsgFrom", MsgFrom), new SqlParameter("@MsgCC", MsgCC), new SqlParameter("@MsgBC", MsgBC), new SqlParameter("@DateSent", DateSent), }; return logContactUsMessage.insertMessage(sqlParams); } [/CODE] However, when I try and …

hi, i want select all values from tables, this code i have, desplay warning! I do not know why. can you guys help me!! [B]!Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the nvarchar value '1t38123' to data type int. (severity 16) in C:\xampp\htdocs\SGFT\Dados.php on line 18[/B] [CODE]$fotog = "SELECT …

Hi, URGENT!! I need help regarding updating the datagrid. I have a datagrid with columns A , B , C , D in Page 1. Column C gets the value from a dropdown list from another page(Page 2). I need to update the column in Page1 with a value from …

Hi, I require your suggestions for the database server problem that I have. We have around 4000 thousand client programs spread across globe geographically, with one site having thousand clients. The clients report data directly to db server, not using http but using (tcp/ip connections). My question is whether MS …

i have my database ready... but when im using my ODBC i'm getting prompted with [SQL Native Client][Named Pipeline Provider] Could not open a connection to SQL Server [51]. Connection failed:

[CODE] I want to add search functionality to a website. i want to use the following controls: TextBox Dropdownlist1 DropDownlist2 SearchButton (Title) (Book OR DVD) (Category/Genre) I want the items of DropDownList2 change when a specific item is selected in DropDownlist1, and based on that search results are displayed. And …

hey, my question is, i have the visual studio and the SQL server confuration installed in my computer, i wrote a windows desktop application in C# and I am using a mdf file(microsoft SQL database file). i copied the database file which is the database file to the folder it …

hello, i'm new here and i'm also new in VB.Net and SQL Server 2008. I just got this error while creating my own login form. It generates an error "Invalid Column name manoyanx" where 'manoyanx' is the string i am querying in the database. Here is my snippet : [CODE]Dim …

I am using memebership provider in my app. I ADDED MEMBERSHIP SCHEMA TO AN EXISTING DATABASE. HOW DO I GENERATE THE T-SQL SCRIPTS FOR SQLMEMBERSHIP??

I want to display all e-mail addresses from my database in a TextBox. The reason I want to use a TextBox is that I want them in a single row, separated by "; " and that's not possible in a ListBox (right?) which I was using from the beginning. So …

I am trying to read some data from a db but I am getting an error on oledbdatareader. here is my code. [CODE]OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Power User\Desktop\Domains.accdb;Persist Security Info=False"); conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; //cmd.CommandText = "Select * from Domains"; cmd.CommandText = "Select * …