[microsoft:sql-server] Forum Topics

What is cursor in SQL and when to use

Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at …

protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] != null) { if (Session["roles"].ToString() != "Admin") { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Only Admin Can Access this Page');window.location ='HomePageAdmin.aspx';", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Please Login To Proceed');window.location ='HomePageAdmin.aspx';", true); } } protected void btnRegister_Click(object sender, EventArgs e) { …

Dear Friends i want to copy data from one table to another table i know we can do this task using following query INSERT INTO Destination (EnrollNo, CheckIn, CheckOut, DiffTime) SELECT EnrollNo, CheckIn, CheckOut, DiffTime FROM Source but here is problem ... i want to add a new colum with …

i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode …

I have Table1 with a VARCHAR(MAX) column which contains values like 4, 1.4, 0.3, 4.25 and I'm trying to take these decimal values and populate them into another table (Table2) with a DECIMAL (18, 2) column with the following Scalar-Valued Function: Convert to Number. (The reason why the column in …

SQL server 2012 query. declare IDList cursor for (SELECT ID FROM [dbo].[News] WHERE PublishFromDate BETWEEN cast(@fromDate as datetime) AND cast(@toDate as datetime)) order by PublishFromDate The above cursor wrks fine. But when add order by "desc" make it is not working. declare IDList cursor for (SELECT ID FROM [dbo].[News] WHERE …

I want to know **what are the prerequisites Softwares Needed to install on my pc to start vb.net 2008 and ms sql Standalone and Server Client Software Development**? I have P4 Processor, 4 GB Ram, 1 TB Hard Disk, Oprating System Windows XP Professional Service pack 3. Visual Studio 2008 …

hi i have deattach the database from the SSMS. and a new database i have created in visual studio 2010. and i want to attach it to the SSMS. but my attach process is failed. any body is there to help me to attach the database into SSMS...

Hi, Please look at my code Declare @tableName varchar(100), @total int, @sql nvarchar(2000),@id varchar(4) set @tableName='details'; set @id='C'; SELECT @sql= ' select @total = count(*) from details where id='+@id exec sp_executesql @sql, N'@total int output', @total output select @total Error: Msg 207, Level 16, State 1, Line 2 Invalid column …

I have a sproc that pulls six years of records for a report. The person who set it up years ago set it up using statically defined years which ended in 2009. I am rewriting this sproc to pull the current year and five years previous. In the process of …

my aspx code <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" > <ItemTemplate> Product_Image: <asp:Label ID="Product_ImageLabel" runat="server" Text='<%# Eval("Product_Image") %>' /> <br /> Item_Description: <asp:Label ID="Item_DescriptionLabel" runat="server" Text='<%# Eval("Item_Description") %>' /> <br /> Price: <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' /> <br /> Qty: <asp:Label ID="QtyLabel" runat="server" Text='<%# Eval("Qty") %>' /> <br …

I have two tables of employee information from two different sources, one from Active Directory and one from our Billing Department. The AD table has the following columns: EmployeeID Surname Givenname Company Office. The Billing Dept table thas the following columns: EmployeeID Company Office First Last. I want to compare …

in this when i updated data then not updated it is deleted in update button but there is update fuction how i solve this problem that data are update????/ here is updated fuction { string constring = @"Data Source=.\SQLEXPRESS;Database=htm;Integrated Security=True"; SqlConnection con = new SqlConnection(constring); con.Open(); DataTable dt = new …

there is a table. both "age" and "DOB" columns are there. how to give a SQL command to make "AGE" a derived attribute from "DOB"? thanks

I need some help to make a order form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate SQL Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables Orders and OrderDetails) I've create a form for order entry, which contain a textbox for OrderID, a …

i am working on a POS as a school project. im having a problem in getting the stocks, which is a record in my database. this is what i need to do, i need to populate the combobox with drug names with suggests. when i choose a certain drug, its …

I want to get the relevant name of the product Id into a text box when I select the product id from the combobox myConnection = New SqlConnection(connectionstring) myConnection.Open() myCommand = New SqlCommand(" Select Name FROM [Product_Name_List] Where P_Id='" & ComboBox2.Text & "'", myConnection) Dim dr As SqlDataReader = myCommand.ExecuteReader …

i hve reservation form add function and add button public void addreserve() { string constring = @"Data Source=.\SQLEXPRESS;Database=htm;Integrated Security=True"; SqlConnection con = new SqlConnection(constring); con.Open(); DataTable dt = new DataTable(); SqlCommand com = new SqlCommand("insertreserveinfo", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.Add(new SqlParameter("@Reservation_id", myreserv.Reservation_ID1)); com.Parameters.Add(new SqlParameter("@Guest_id", myreserv.Guest_name)); com.Parameters.Add(new SqlParameter("@Room_ID", myreserv.Room_no)); com.Parameters.Add(new SqlParameter("@Service_ID", …

i have a form whcih is room and in this there is when i add a data on it that is room id,room no and service type and room type then when i add the data like as room id=1 room no=2 room type=double service type=luxury then when i again …

Hi I'm using a simple insert statemnt in from two textfield into my database using this code Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If (TextBox1.Text.Trim = "") Then MessageBox.Show("PLEASE DO NOT USE BLANK SPACES", "Data Entry Error") ElseIf (TextBox2.Text.Trim = "") Then MessageBox.Show("PLEASE DO …

Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to …

Hi All, I am trying to export data from SQL Server. But i am unable to do that. I have also created an SSIS pacage and after connecting the excel Manager when I am going to select the excel sheet it shows me the following error **The 'Microsoft.ACE.OLEDB.12.0' provider is …

I am not a programmer just learning. I would like to know how to save the scheme info into a table ? I have this sql statement that seems to work but how do i save the info into a table Dim CmdStr As String = " SELECT TABLE_NAME FROM …

Good day, I was stock in the middle of developing a simple application. All i want is to bind the data into gridview, everything is fine when i binding into a single table. i need to bind my gridview using two table. my stored procedure is wroking correctly. here is …

Hi all, This is going to be difficult for me to describe but I'm going to give it a go! I have tables called tblCPI, tblCPI_Staging, & tblVSeriesList. Please see the diagram.  Right now I am using SSIS 2008 to get data from Statistics Canada and load the …

I wrote a C# code called parent. When i run the program and try to add parent details to the database( microsoft access 2010), it gives me this error: Exception in DBHandlerSystem.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) …

Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose …

Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select …

Hello, Hii friends, I want to know how to connect sql server 2005 to vb.net windows application 1)is there any connection string ? 2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and password to enter in sql server …

Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to …

For Security Concern, I am using mssql_execute(). I am not getting way to get the recordset return from procedure. Below is my sample code $query = mssql_init("USP_GET_ICIN_DATA",$mssql_link); mssql_bind($query, '@ICIN_NUMBERS',trim($icin_data), SQLVARCHAR, false); mssql_bind($query, '@FROMRECORDNUMBER', $start, SQLINT4, false); mssql_bind($query, '@LIMIT', $limit, SQLINT4, false); $result = mssql_execute($query); while ($row = mssql_fetch_assoc($result)) { $icin …

Hi All, From a table I am getting the length of character in a column. My query is below SELECT b.[file_id],b.[lineno],b.fileContent, datalength(b.fileContent) Length1 FROM FileBascContent b join filebasic on filebasic.[file_id]=b.[file_id] WHERE substring(b.fileContent,1,4) not in('VOL1','HDR1','UHL1','UTL1','HDR2','EOF1','EOF2') and filebasic.[file_id]=347 I am getting the result 98, 97 and 100 which is fine for me. …

I am trying to use a combobox in a windows form for windows CE mobile device with sql server compact installed. I am using visual studio 2008. I have two sdf databases - MobileArticles.sdf and MobileOrders.sdf MobileArticles.sdf has a table Articles(name, weight,barcode,...) and a table Clients(ClientID) MobileOrders.sdf has only one …

For whatever reason beyond my understanding did my DB start this problem. I got 2 tables in my database. 1 dealing with personal info 1 with dates and time To keep my startup form empty I have the first row empty in both tables. But for some reason after I …

I have one datalist which retrives record from database based of Customer_ID <asp:DataList ID="DataList1" runat="server" DataKeyField="Customer_ID" DataSourceID="SqlDataSource1" onupdatecommand="DataList1_UpdateCommand" oneditcommand="DataList1_EditCommand1" ondeletecommand="DataList1_DeleteCommand" oncancelcommand="DataList1_CancelCommand1"> <HeaderTemplate> <table> <tr> <th style="width: 250px"> </th> <th style="width: 400px"> Item Description </th> <th style="width: 100px"> Price </th> <th style="width: 100px"> Qty </th> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td> <asp:Image …

i have certain codes in JSP and JSTL as following : <sql:transaction dataSource="${dataBase}"> <sql:query var="tDate"> SELECT starttime FROM campaign WHERE cid=25; </sql:query> </sql:transaction> <c:forEach var="row" items="${tDate.rows}" varStatus="totalRow" step="1"> <c:set var="starttime" value="${row.starttime}" /> <c:set var="datetime" value="${fn:split(starttime,' ')}" /> <c:set var="date" value="${fn:replace(datetime[0],'-',',')}" /> </c:forEach> <% Calendar d = Calendar.getInstance(); d.set(date); %> but …

hi all store procedure set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[insertguestinfo] @Guest_ID int, @first_name nvarchar(50), @Last_name nvarchar(50), @Gender_ID int, @Martial_ID int, @Phone_number int, @email_address nvarchar(50) as begin insert into GuestInfo(Guest_ID,First_name,Last_name,Gender_ID,Martial_ID,Phone_number,Email_address) values(@Guest_ID,@first_name,@Last_name,@Gender_id,@Martial_id,@Phone_number,@email_address) END public void add() { Guest_info gst_info=new Guest_info(); string ConString = @"Data Source=USER-PC\SQLEXPRESS;Initial Catalog=htm;Integrated Security=True"; SqlConnection …

hi there. anybody knows how to display conntents of (SQL)database in vb.net using label?

I am trying to make a basic page in ASP.Net by inserting into a MSSQL database. When I run the page it does not insert anything and no error is produced :( The connection string name is right as well as the table name and fields. This is my code: …

So I downloaded the [Adventureworks 2012 SQL database](http://msftdbprodsamples.codeplex.com/releases/view/55330) to browse hoping to find something interesting and just nearly fell asleep looking at example data when I came across something new or that I at least never noticed before...a field with a data type of "xml(CONTENT Person.AdditionalContactInfoSchemaCollection)" and when viewing the …

Hey there, Im doing for a typing platform project to test the typing speed of a user. I have a SQL database (para1) which store a list of words. I use datalist and linqdatasource to display the text in a textbox (paraBox). What should i do to match the word …

Good day, I am havinf trouble with the pageindexchanging in my gridview here is my code; my PAgeIndexChanging code protected void gvPatientInformation_PageIndexChanging(object sender, GridViewPageEventArgs e) { GetPatientInfor(_patientInformation); gvPatientInformation.PageIndex = e.NewPageIndex; } my Method Code private void GetPatientInfor(PatientInformation _patientInformation) { gvPatientInformation.DataSource = PatientInformationBL.listPatientIformation(_patientInformation); gvPatientInformation.DataBind(); } My BLL code public static DataTable …

Hello, I'm a complete noob when it comes to .Net. I'm working on my college project. In my application there's a combobox/drop-down list. My requirement is as soon as user starts typing inside it, i.e. when text_changed is triggered it should retrieve values starting from that letter from a column …

hi guyzzz in visual studio the form guest i added guest info i added it is added but not show in datagirdview and also not display in girdview but it is added in database SQL but not show in girdview plzzzzz any one tell me

I'm creating an app, that displayes a String from a database. This String is then displayed in a textbox that cannot be edited. I now require that varible (ID passed) in the text box to be compared with a column in a SQL database table which is an identical String. …

The idea is to check whether if phone number already exists(data table). If the number exists, then it will create a new row under another table(output table) with the customer ID for that customer. Table data is where pre-loaded phone numbers are stored. Table input is the table where feed …

Hi All Experts, I am a newbie to C#, my development environment is: Visual Studio 2010 Ultimate Edition Sql Server 2005 Programming Language C# I've a form with Unbound Datagridview, from which data is save to Sql Server 2005 by looping through For..Each and pass SQL INSERT Statement when user …

Hello everybody you will excuse my poor englsih I am french, since two month I began to develop an application using Vb.Net . This application must use a database . I chose MS SQL Server for the database, but I dont know how to connect my application to MS SQLSERVER. …

Good day, I'am having a problem regading the computation in sql. I been using C# and am creating a web application. All i want is to multipy the value of the record from one table and multipled it with the other table. s oi caome up with this idea. @MARKUP …