Search Results

Search found 53054 results on 2123 pages for 'sql sample database'.

Page 373/2123 | < Previous Page | 369 370 371 372 373 374 375 376 377 378 379 380  | Next Page >

• Sql query builder c#

  - by pdiddy

  I'm building a windows mobile app. And using SqlCe. I'm looking for a good sql query builder. So instead of writing "SELECT COLUMNS FROM TABLE WHERE etc... Is there a good free library that can build this sort of query?

  Read the article

• SQL server globalization

  - by Nijesh patel

  When using arabic language, data is stored in database with ? (question mark) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.

  Read the article

• compiling a linq to sql query

  - by frenchie

  Hi, I have queries that are built like this: public static List<MyObjectModel> GetData (int MyParam) { using (DataModel MyModelDC = new DataModel()) { var MyQuery = from.... select MyObjectModel { ...} } return new List<MyObjectModel> (MyQuery) } } It seems that using compiled linq-to-sql queries are about as fast as stored procedures and so the goal is to convert these queries into compiled queries. What's the syntax for this? Thanks.

  Read the article

• Finding all tables and fields on "many" side of relations with a certain table

  - by bzamfir

  in Sql Server 2005, I have a master table, and several other tables which are related to this master through several one to many relations. How can I find all tables and fields which are in relation with the primary key in the master table, on "many" side? I know I can extract this by querying views from INFORMATION_SCHEMA, but I don't know where exactly I can find this info. Thank you

  Read the article

• removing duplicates from table without using primary key

  - by jest

  hi! I've a table(TableA) with contents like this: Col1 A B B B C C D i want to remove just the duplicate values without using temporary table in Microsoft SQL Server. can anyone help me? the final table should look like this: Col1 A B C D thanks :)

  Read the article

• Linq to Sql statement for multiple aggregate values in single expression

  - by Jeff Langston

  How would I write a linq to sql statement for the following tsql? select count(*), sum(Amount), avg(Amount), min(Amount), max(Amount) from TableName

  Read the article

• convert a sql statement to class?

  - by walter

  Is there a tool or code to convert a sql statement to class? Something like: Dim sqlText = "SELECT CustomerID, Name, Address, City FROM dbo.Customer WHERE CustomerID = 1" Dim obj As New ***SqlStatementTool***(sqlText) obj.GetTables() 'Will Return Tables in sqlText obj.GetWheres() 'Will Return conditions in sqltext obj.GetParameters() 'will return parameters in sqltext

  Read the article

• Send mail in asp.net without smtp details

  - by Zerotoinfinite

  Hi Experts, I am using asp.net and C#. I have deployed my application on the server and now I come to know that my server don't have a ip address, is their any way I could send sms without smtp details. I can use bot asp.net3.5 with C# or SQL Server 2005 to send mail. Thanks in advance

  Read the article

• SQL Server Update Group by

  - by Gerardo Abdo

  I'm trying to execute this on MS-SQL but returns me an error just at the Group by line update #temp Set Dos=Count(1) From Temp_Table2010 s where Id=s.Total and s.total in (Select Id from #temp) group by s.Total Do anyone knows how can I solve this problem having good performance.

  Read the article

• Concatinating Multiple Rows in SQL

  - by Dave C

  Hello, I have a table structure that looks like this: ID String ----------- 1 A 1 Test 1 String 2 Dear 2 Person I need the final output to look like this: ID FullString -------------------- 1 A, Test, String 2 Dear, Person I am really lost on how to approach this... I looked on a couple examples online but they seemed to be VERY complex... this seems like it should be a real easy problem to solve in sql. Thank you for all assistance!

  Read the article

• How to use split in SQL Server 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in SQL Server 2005.

  Read the article

• Why is variable declared inside IF statement created even when condition evaluates to false?

  - by AspOnMyNet

  Since @A is never declared, sql server should throw an error, but it doesn’t. Why is that? DECLARE @i int = 1; IF @i > 10 BEGIN DECLARE @A int = 100; END PRINT @A; // doesn't return any result thanx

  Read the article

• SQL Server 2005 Convert Ascii to Unicode (UTF-8 -> nvarchar)

  - by Guazz

  I have data in an nvarchar field with data in ascii format: "Zard Frères Guesta" How do I convert it to a readable(unicode) format in t-sql?

  Read the article

• SQL Server Express - Trying to add Network Service but it doesn't allow me to

  - by Ardman

  I have been trying to fix this solution for the last day. I'm trying to add NETWORK SERVICE as a user to the SQL Server Express installation on the server. Everytime I get the error 'User does not have permission to perform this action.'. Any ideas?

  Read the article

• How to perform a select using a WHERE NOT EXISTS

  - by Peter Bridger

  I'm using LINQ2SQL and I want to compare two tables and select all rows that are missing from one tables (based upon one of the column values). In standard SQL I would write this as: SELECT FirstName, LastName, RefId, Email FROM Users_ActiveDirectory AS ADU WHERE NOT EXISTS ( SELECT U.RefId FROM Users AS U WHERE U.RefID = ADU.RefId ) However I'm not sure how to achieve the same result using LINQ2SQL?

  Read the article

• Need help converting SQL to EF4 please

  - by Ken Eldridge

  I need help converting this SQL statement, into EF4: Select Posts.PostID, Post, Comment from Posts left join Comments on posts.PostID = Comments.PostID Where CommentID not in ( Select PostID from Votes where VoteTypeID = 4 --4 = flagged comment type ) In my database, the Votes table stores either the PostID of reported posts, or CommentID of reported comments in the column Votes.PostID Thanks in advance!

  Read the article

• SQL standard to escape column names?

  - by acidzombie24

  Is there a SQL standard to escape a column name? If not what works for mysql and sqlite? does it also work for sqlserver?

  Read the article

• capturing user IP address information for audit

  - by Samuel

  We have a requirement to log IP address information of all users who use a certain web application based on JEE 5. What would be an appropriate sql data type for storing IPv4 or IPv6 addressses in the following supported databases (h2, mysql, oracle). There is also a need to filter activity from certain IP addresses. Should I just treat the representation as a string field (say varchar(32) to hold ipv4, ipv6 addresses)

  Read the article

• Sorting string column containing numbers in SQL?

  - by Ish

  Dear Folks, I am trying to sort string column (containing numbers). // SELECT `name` FROM `mytable` ORDER BY `name` ASC +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 12 --+ +-- a 2 ---+ +-- a 3 ---+ You see natural sorting algorithm of Mysql is placing a 12 after a 1 (which is ok for most apps), But I have unique needs, so I want result should be sorted like this. +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 2 ---+ +-- a 3 ---+ +-- a 12 --+ Is it possible with just SQL, or I have to manipulate result-set at application level? Thanks for reading...

  Read the article

• MS SQL to PostgreSql

  - by Dezigo

  I need to create a trigger in MS SQL. Trigger works: If I found new line where T = 'A'; than.. add this line to PostgreSQL table. Is it possible to create it,without software? (I know how to create trigger,but how to create connection between two servers..?

  Read the article

• displaying sql exception in JSF

  - by user234194

  I was wondering how would I be able to show SQL errors generated during update, delete, select * etc in JSF. Any help would be appreciated.

  Read the article

• Linq@sql Is it possible to excute sql query with Linq2Sql for a type not defined in codegen

  - by Malcolm

  Hi, I have an app and I have come to a point where I need to build a sql statement up dynamically. Is there a way to execute it and return a type that has not been defined via the designer with Linq2Sql?? Malcolm

  Read the article

• node to traverse cannot be null (Hibernate SQL)

  - by tiswas

  I'm performing a SQL query through hibernate, which looks like: SELECT thi FROM track_history_items thi JOIN artists art ON thi.artist_id = art.id WHERE thi.type = "TrackBroadcast" GROUP BY art.name ORDER thi.createdAt DESC but I'm getting the message that 'Node to traverse cannot be null!'. Anyone know what could be causing this? --EDIT-- I'm pretty sure that this problem is being caused by the possibility of artist_id to be null. However, I can't prevent this, so can I just skip the rows track_history_item rows which have a null artist_id?

  Read the article

• SQL Server Password

  - by andy

  Is there any way of retreaving a SQL Server Authenticatiion password. I am running Server 2005 with admin rights.

  Read the article

• Cluster-aware client app (to SQL Server)

  - by Mikael Sundberg

  Hello, We have an .NET client app working against SQL Server 2005 (clustered), do I need to do something special in the client app to make it cluster aware? Thanks.

  Read the article

< Previous Page | 369 370 371 372 373 374 375 376 377 378 379 380  | Next Page >