Browse by Tags

Home ›

All Tags » sql » SELECT (RSS)

Adding characters to SQL returned string

Hi All, I have a select statement in my SQL that returns the first 200 characters of a string. I would like to add a ... to the end of each string, is this possible to do in my select statement? Here is the select statement I am using: SELECT LEFT (articleBody, 200) AS [articleBody] FROM [tableName]...

Posted to Getting Started (Forum) by magicjoef on 01-04-2009, 12:00 AM
Filed under: net, SQL, string, asp, select
Select then insert..

Hi, I am really confused about how to do this: I have two tables (users and bookmarks). They both have a UserID column which is a unique identifier. I want to insert some data into bookmarks along with the UserID. I obtain the userID by doing something like SELECT UserID FROM users WHERE OpenIdUrl =...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 12-24-2008, 12:00 AM
Filed under: SQL, Inner join, insert, SELECT
Problem in creating a view.

Hi All, Did anyone know how to solve this kind of problem? I am using Microsoft SQL Server 2005. Based from this table, Table: tblAttendance TransID EmpID BranchID TransDate TransType IsAdjusted Status 1 12 3 10/1/08 8:50 AM IN FALSE - 2 15 1 10/1/08 8:52 AM IN FALSE - 3 21 3 10/1/08 8:53 AM IN TRUE...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by van.net on 12-17-2008, 12:00 AM
Filed under: SQL, SQL Server 2005, Table, View, join, joining queries, SELECT
Select, SqlCommand, SqlDataAdapter, Data.DataTable ?? How can i sort my code lines ???

hi friends.. my select code lines are below.. i sorted my cmd and i didnt create new cmd2 for SqlCommand... How can i sort my code lines for da(SqlDataAdapter) and dt (Data.DataTable)? i dont want to use daa and dtt.. How can i do this with da and dt ? my da and dt are begin of my code lines.. i didnt...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by oguzkaygun on 07-17-2008, 12:00 AM
Filed under: sql, sqldataadapter, dataatable, Select
hi need help in cross tab query

I wanna develope a report using cross tab query. I have table wit the name spend in which i have spenddate and there is also a amount field which will show the sum of amount field against months, i wanna develop repport in this format merchant name jan 2007 feb 2007 dec 2007 jan 2008 feb2008 test 45...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by azwaralam on 04-14-2008, 12:00 AM
Filed under: SQL, sql 2000 "sql server express 2005", SQL 2000 Server, sql alias, SELECT
Set Session Variable from SQL SELECT Statement

Hi All, I am not sure how I would go about doing this. Here is what I want to do, I need to set a session variable based on what is returned from a select statement when a button is clicked. Here is my code. It is by no means complete, as I need your help to finish it. Much thanks in advance. Protected...

Posted to State Management (Forum) by bslaght on 12-19-2007, 12:00 AM
Filed under: SQL, Select, session variable
Re: Custom Paging in a Gridview - Runtime Error When Filtering

hopeful bump After some more investigating I can see that the error is occuring here: //return how many rows are in the total recordset public int GetTransactionCount( int fkToOrgID) { try { return ( int )Adapter.usp_GetTransactionCount(fkToOrgID); } catch ( Exception err) { //Catch the error here and...

Posted to Data Presentation Controls (Forum) by glosrob on 11-30-2007, 12:00 AM
Filed under: paging, sql, ASP.NET, database, SELECT, GridView, Filtering GridView
Select query -with a NULL FK- return nothin!

Hi, I'm trying to select this sql statement, which selects some items from 3 tables: mail, SysUsers and projects table. The query works fine when I pass parameter @messageId and the FK [mail.projectId] is NOT null. But when it is null, the query doesn't return any rows, although it is not the...

Posted to Data Access and ObjectDataSource Control (Forum) by jocker_wow on 11-28-2007, 12:00 AM
Filed under: null, sql, FK, Select
SELECT COUNT FROM MULTIPLE TABLES

Hi everyone, I have 3 tables 1. Users (UserID,UserName) 2. Threads (ThreadID, UserID, ThreadTitel, Date) 3. Posts (PostID, UserID, PostTitel, Date) I want 1 table for use in (GridView) with the users and the # Threads and # Posts for that User Like this: UserName #Threads #Posts Peter 2 7 John 2 0 Ellen...

Posted to Data Presentation Controls (Forum) by Bonaparte on 11-24-2007, 12:00 AM
Filed under: Multiple table binding, sql, SQL Datasets, SQL Query, sql2005, sqlldatasource, SELECT
How To: Create a SELECT to select records from a table based on the first letter.......

Dear All I need to cerate a SP that SELECTS all the records from a table WHERE the first letter of each records starts with 'A' or 'B' or 'C' and so on. The letter is passed via a parameter from a aspx web page, I was wondering that someone can help me in the what TSQL to use...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rhaskins on 08-16-2007, 12:00 AM
Filed under: SQL, SELECT

Page 1 of 2 (16 items) 1 2 Next >

Browse by Tags

Related Posts