3,481 Topics
 | |
| | I am having trouble figuring out how to execut the following SQL query. Say for example I have the following 2 databases. Db1 Col_1 Col_2 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 j 9 h 10 i Db2 Col_1 Col_2 1 j …  |
| | Hi everyone ; i using to VS2008 -- devexpress V10.1.2 and MSSQL i make to same project .. my project setup is work my computer but same setup doest work to another computer error: ERROR DETAILS Following errors were detected during this operation. * [07.11.2012 02:17:57] System.Deployment.Application.InvalidDeploymentException (SignatureValidation) - Strong … |
 | i am trying to do something like this but it gives me error that **cannot convert int to string** , even the field which i am accessing from db is int and i parsed it into int but why ? here is my code: userId = (int)com.Parameters["@ReturnValueUserId"].Value; Response.Write(userId); SqlDataSource1.InsertParameters["@userId"] = … |
| | my griedview is half shown on browser's screen and even it disabled horizontal scroller on screen (browser), why ? whenever i fill my gridview with many columns than it is half shown and disables scroller too, why ? |
| | see i am using this mode of SQLDATASOURCE configuration  and now on the basis of this sql statement i want to generate UPDATE, INSERT, DELETE queries, especially UPDATE and i tried my best to do it but can't. this thing is quite possible in the mode given below … |
| | Greetings, I want to know what is the pest practice in the following issue. I have a From for releasing decision such as hiring employee, discharging employee etc. The process of releasing a decision takes the following steps 1- You fill the necessary data within the from and then click … |
| | Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following: idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie The kingdom, phylum, class, order, family, genus and … |
| | Greetings. I'm having a problem that is we have a fingerprint devices in the factory, we have 2 work shifts OK so the security guys must switch the devices from "in state" to "out state" so that the [in/out mode] in the database being 0 "means attend state" it changes …  |
| | i am retrieving textual data from database on my page , asp.net(c#), now i want to save in pdf format and want to store that pdf file on my server(localhost) so how ? |
| | during signup by applicant he/she must fill her educational details , total 5 educational levels, 1.ssc 2.hssc 3. BS 4. MS 5. Phd now lets say that an applicant has only BS passed then it mean that he/she would not have fill 4 and 5 option, now i want that … |
| | *.cs page code* using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class advertisementSubmission : System.Web.UI.Page { protected String EmplyrSession; protected int userId; protected void Page_Load(object sender, EventArgs e) { EmplyrSession … |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
 | i have two tables with the following columns: departments: departmentID tinyint not null department varchar( 30 ) not null employees: employeeID SMALLINT(5) not null departmentID tinyint not null firstName varchar(30) not null lastName varchar(30) not null how do i create the two tables using SQL with a foreign key linking …  |
| | ***using select query result in insert query*** ***i have this code in .cs Page .cs page*** String query = "select userid from tblUser where email='" + EmplyrSession + "'"; SqlCommand com = new SqlCommand(query, con); try { con.Open(); int noRows= com.ExecuteNonQuery(); Response.Write(noRows); } catch (Exception ex) { Response.Write("Sql Error:" + …  |
 | I'm new to MSSQL though I have some grounding in MySQL. At the moment, I'm trying to use a variable. Reduced to simpler form, my query to search people with 'and' in their name is: DECLARE @MyVar nchar; SET @MyVar = '%and%'; SELECT name,email FROM db.dbo.users WHERE name LIKE @MyVar; … |
| | I need to split my Access 2007 .accdb and place the back-end on SQL Server 2008. I am not able to utilize SSMA due to security reasons. SQL Server resides on a different machine from the Access Database. I tried looking for books or tutorial to no avail to any … |
| | I just task with sql related Syntax,using ERP software.How i want to more about sql database?  |
| | Hey guys. I am trying to move a SQL database from one SQL server to another. One is SQL server 2003 and the destination is running SQL server 2008. Can anyone provide some guidance with this. I have never done this before so any pointers with be greatly appreciated! Thanks! |
| | in databse tabel i have fieild with type varbinary(max) for storing image, so i achieved it and stored my image but the problem is that when i use this line SqlParameter p8 = new SqlParameter("logo", SqlDbType.VarBinary).Value= productImage; then it gives me an error but when i use this line : … |
 | Hi all, I have the following VB.NET code where I am attempting to connect to a SQL Server table, query it to find out if a date in the table is between a derived date called "fileCreateDate" and now/today. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim … |
| | if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level … |
| | i stored session variable in string variable in .cs page , but now i want to retrieve that string variable on .aspx page and want to put into selectcommand of sqldatasource how ? |
| | am using asp.net 3.5(c#) + sql server 200 DB, doing this GIVES me an error , *Error:The multi-part identifier "email@yahoo.com" could not be bound* why ??? using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; … |
| | i have imagepath stored in database , now i want to show on asp.net page via datalist , so how to do it , i tried by best and binded textual data from database bt not able to bind or show image on asp.net page via datalist ? i am … |
| | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
| | i have field (advDetails) in database with datatype TEXT, and i am trying to insert text from asp.net detailsview into database but it isn't working. here is my code. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="advertisementSubmission.aspx.cs" Inherits="advertisementSubmission" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> … |
| | Hi, I have a table with date column where the date data is represented by a number. I would like to view this data in a date format (dd-mm-yyyy) after running the sql statement. Appriciate if you could let me what is the code for it. Thanks. Y |
| | Hi All, In my table (dbo.partha) i have three fields. the first one is id, 2nd one is CM_Name and the last one is empid the table looks like id name empid 1 Das 5 2 Ram 9 3 Abi 5 1 Wed 5 4 Sat 4 5 Sun 3 … |
| | Greetings, I have 3 tables in my database HR_Employee_Personal_Info, HR_Employee_Job_Info and HR_Attend_And_Leave_Of_Staff respectively, I want to get the attendance of each employee based on his work shift. I will mention the columns within each table which will be of interest in order to do the job. Table HR_Employee_Personal_Info: [Employee ID], … |
| | Hi All, I am trying to link two database in different servers. Are there any ways I can do this? If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I … |
| | Hey everyone, I'm using CTEs to try and get the totals of two different criteria queries that I want to group by Month depending on the associated Inquiry Date. Here is what I have right now; ;With CTE(total, InitDate) as ( SELECT count(Inquiry.ID), Inquiry.Date from Inquiry Inner Join Inquirer on … |
| | Hi All, In a table (dbo.UnquotedContacts) I have few columns from where I am trying to extract few columns. But My crcern is as follows IF the field 'Date_ABC_Updated' is NOT empty AND the field 'subscribed_to_Business_XL' = 'SUB', the contact has an ACTIVE BXL subscription IF the field 'Date_ABC_Updated' is … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable … |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
| | Hi All, I am new comer in this site. Through Google serach I have found this community. Hope this site is really helpful for the beginers who wants to learn everything However I have written a query and got the result. Now I want to insert the data (what I … |
| | i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table: CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 … |
| | HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password … |
 | Hello I have a table item1 | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | 2 | | c … |
| | Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to … |
| | Hey everyone, I have the following two queries, and want to know why the first one would return a count of 52, but the second would return a count of 51 when technically they should be the same; SELECT count(*) from Inquiry Inner Join NoDecision on Inquiry.ID = NoDecision.InquiryID_fk Inner … |
 | Hello, Can we perform bulk insert for SQL data? I have the complete SQL data in text files. There are multiple tables and the corresponding text files. I tried to do the bulk insert but always got some new error. Please help me to get an answer. My code Imports … |
| | |
| | i have a table for cities and data which has entries in LACS , now i want to copy that table from one database to another, is it possibe ? i googled but couldn't find reliable solution mean i have fear to loss data .s o anybody , plz suggest … |
| | when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field |
| | Hi I have a question, I want to transfer all nodes to a datarow Here is my XML <Employee> <person> <firstName>Jon</firstName> <lastName>Johnson</lastName> <skills>Singing</skills> <skills>Dancing</skills> </person> </Employee> THE HEADER TABLE SHOULD LOOK LIKE THIS WITH RELATION Profile_ID | Firstname | Lastname| 10 | Jon | Johnson | AND THE DETAIL TABLE … |
| | Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID … |
| | Hi, I have 2 tables tbl_class & tbl_Divisions. structure: tbl_class tbl_Divisions tbl_class_division ---------- ------------- ------------------- class_Id (pk) division_Id(pk) class_division_id(pk) class_name division_name class_Id(fk) division_Id(fk) In my application I want to select division_Id,division_name by passing more than one class_id. if I pass 3 class_Id's , I want to get only those divisions … |
 | Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, … |
| | Hi guys I'm Indrajeet Roy, and I have a problem with a piece of code I am trying write in VB.net. I am using Visual Studio 2010 as my IDE. The basic idea behind the form and the coding I am trying to do is to create a username, password … |
| | Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on … |
The End.