Search Results

Search found 31328 results on 1254 pages for 'sql join'.

Page 562/1254 | < Previous Page | 558 559 560 561 562 563 564 565 566 567 568 569  | Next Page >

• Does anyone use the PL/SQL Web Toolkit?

  - by colinjameswebb

  Does anyone use the PL/SQL Web Toolkit at all? We use it for internal reporting where I work. However, does anyone have any experiences of it for producing client-facing websites? General advantages/disadvantages compared to other web languages, such as JSP, PHP etc

  Read the article

• Why column rename script generated by SSMS uses temporary name?

  - by abatishchev

  When I rename a table column in Designer mode in SQL Server Management Studio 2008 (both R2 and non-R2) and generate a change script it looks like this: EXECUTE sp_rename N'table.column', N'Tmp_columnNew', 'COLUMN' GO EXECUTE sp_rename N'table.Tmp_columnNew', N'columnNew', 'COLUMN' GO What for temporary column name is used? Why don't rename at once?

  Read the article

• Basic requirements in a laptop for running VS2010 and SQL Server 2008 smoothly

  - by Yajuvendra

  Planning to buy a laptop(reasonable budget). I want to know the basic requirement to run VS2010 and SQL Server 2008 smoothly with Adobe Photoshop CS4 and Dreamweaver CS4 in Windows 7 Home. Can Pentium Processor do the job? If not please Suggest me. Thank you.

  Read the article

• Import Data From Sql Server Compact Edition To Excel

  - by hosseinsinohe

  Hi How Can I Import Data From a Table in Sql Server CE To Excel? I Try This From Excel But I Can Not Find an Item for This In Excel Please Help Me To This

  Read the article

• Are Conditional subquery

  - by Tobias Schulte

  I have a table foo and a table bar, where each foo might have a bar (and a bar might belong to multiple foos). Now I need to select all foos with a bar. My sql looks like this SELECT * FROM foo f WHERE [...] AND ($param IS NULL OR (SELECT ((COUNT(*))>0) FROM bar b WHERE f.bar = b.id)) with $param being replaced at runtime. The question is: Will the subquery be executed even if param is null, or will the dbms optimize the subquery out?

  Read the article

• mysql procedure to update numeric reference in previous rows when one is updated

  - by markcial

  There's a table like this one ______________________ | id | title | order | |----------------------| | 1 | test1 | 1 | |-----|--------|-------| | 2 | test2 | 2 | |-----|--------|-------| | 3 | test3 | 3 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' when i introduce in my mysql shell a single update to a row $sql UPDATE `table` SET order=1 WHERE id=3; And then procedure or method resamples order column in the before update lower values to get its order renewed like this ______________________ | id | title | order | |----------------------| | 1 | test1 | 2 | |-----|--------|-------| | 2 | test2 | 3 | |-----|--------|-------| | 3 | test3 | 1 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' Any help would be appreciated, thanks!

  Read the article

• Comma Separated values in Oracle

  - by Vabs

  I have a column with comma separated values like 6,7,99.3334. I need write a PL SQL procedure that will give me these values separately. The Length of the column is 40. Can anyone help me with this?

  Read the article

• MySQL float values jumping around on insert?

  - by dubayou

  So i have a SQL table setup as such CREATE TABLE IF NOT EXISTS `points` ( `id` int(11) NOT NULL auto_increment, `lat` float(10,6) NOT NULL, `lng` float(10,6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; And im inserting stuff like INSERT INTO `points` (`lat`, `lng`) VALUES ('89.123456','-12.123456'); Gives me a row with lat and lng being 89.123459 and -12.123455 Whats up?

  Read the article

• Native XML WebService Without Authentication

  - by tom

  So this my first question here, let's look how it works. I'm working on a project, which has to to provide a "Native XML WebService" on a SQL Server 2005. The web service and the WSDL generation works fine. But there are troubles with the authentication. Is it possible to turn the authentication off (The tests and the documentation by Microsoft say no.)? And if so how?

  Read the article

• How to save byte[] to varbinary(64) field in database

  - by shamim

  I have byte[] a = HashEncrypt("a"); with public byte[] HashEncrypt(string password) { SHA512Managed sha = new SHA512Managed(); byte[] hash = sha.ComputeHash(UnicodeEncoding.Unicode.GetBytes(password)); return hash; } I want to save byte[] a to my database. My database field is a varbinary(64). I'm using SQL Server 2008. I want to know the insert query with C# code. I am using ADO.NET

  Read the article

• hash password in mssql (asp.net)

  - by ile

  Is this how hashed password stored in mssql should look like? This is function I use to hash password (I found it in some tutorial) public string EncryptPassword(string password) { //we use codepage 1252 because that is what sql server uses byte[] pwdBytes = Encoding.GetEncoding(1252).GetBytes(password); byte[] hashBytes = System.Security.Cryptography.MD5.Create().ComputeHash(pwdBytes); return Encoding.GetEncoding(1252).GetString(hashBytes); } Thanks, Ile

  Read the article

• Transitioning from php to python/pylons/SQLAlchemy -- Are ORMs the standard now?

  - by EmpireJones

  Should I invest a lot of time trying to figure out an ORM style implementation, or is it still common to just stick with standard SQL queries in python/pylons/sqlalchemy?

  Read the article

• C# analog for sql in operator

  - by er-v

  There is in operator in SQL SELECT * FROM MyTable WHERE id IN (1, 2, 3, 4, 5) Is there similar sintax in C#, I mean if(variable in (1, 2, 3, 4, 5)){ }

  Read the article

• Dump to CSV/Postgres memory

  - by alex

  I have a large table (300 million lines) that I would like to dump to a csv - I need to do some processing that cannot be done with SQL. Right now I am using Squirrel as a client, and it does not apparently deal very well with large datasets - at least as far as I can tell from my own (limited) experience. If I run the query on the actual host, will it use less memory? Thanks for any help.

  Read the article

• Saving a stream to file

  - by Loadman

  Hi, I have a StreamReader object that I initialized with a stream, now I want to save this stream to disk (the stream may be a gif or jpg or pdf etc). SO my code so far is: StreamReader sr = new StreamReader(myOtherObject.InputStream); I need to save this to disk (I have the filename). In the future I may want to store this to sqlserver I have the encoding type also, which I will need if I store it to sql server right?

  Read the article

• invoke sql function using nhibernate?

  - by net205

  I want to query like this: select * from table where concat(',', ServiceCodes, ',') like '%,33,%'; select * from table where (','||ServiceCodes||',') like '%,33,%'; so, I wrote this code: ICriteria cri = NHibernateSessionReader.CreateCriteria(typeof(ConfigTemplateList)); cri.Add(Restrictions.Like(Projections.SqlFunction("concat", NHibernateUtil.String, Projections.Property("ServiceCodes")), "%,33,%")); I get sql similar : select * from table where (ServiceCodes) like '%,33,%'; But it is not what I want,how to do it??? thanks!

  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

• Convert byte to boolean string in HyperLinkField.DataNavigateUrlFormatString

  - by abatishchev

  I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1} Select command of appropriate SqlDataSource returns columns of type INT and BYTE (from SQL Server 2008). So displayed string becomes something like View.aspx?id=1&isTechnical=1. But I want to display isTechnical=true|False, i.e. Convert.ToBoolean(row["isTechnical"]).ToString().ToLowerInvariant(). How to implement such conversion in page markup?

  Read the article

• Download all tables and stored procedures to file

  - by GigaPr

  Hi , is it possible to download in a file all the table definition(create Statements) and Stored Procedures from a SQL Server 2008 database? Thanks

  Read the article

• Foreign Keys Duplicated in DataGridView

  - by John Doe

  I created a Windows Forms Application to which I added a DataGridView and LINQ to SQL Classes from one of my databases. I can successfully bind one of my database's tables to my DataGridView: var dataSource = from c in _db.NetworkedEquipments select c; dataGridView1.DataSource = dataSource; However, the foreign keys get duplicated, that is, the columns appear twice. How can I prevent this?

  Read the article

• Add SET QUERY_GOVERNOR_COST_LIMIT with Linq to Entities

  - by boris callens

  I'm in a situation where I want to add the equivalent of the sql statement SET QUERY_GOVERNOR_COST_LIMIT to my query I created with linq to entities. How would I go about that?

  Read the article

• Sql Select Query Question. Merge Rows

  - by Jono

  I have a single MYSQL Question and need help ASAP. Database: Email | Name | Tag [email protected] |Test Person | TagOne [email protected] |Test Person | Tag Two Need an SQL query that will return Email | Name | Tag [email protected] |Test Person | TagOne, Tag Two Any help?

  Read the article

• How do I cache query results using LINQ?

  - by Vince

  Hi, Is there any way to cache LINQ to SQL queries by looking at the parameters that were previously passed and bypass the database all together? I know L2S caches some database calls, but I'm looking for a permanant solution as in, even if the applciation restarts, that cache reloads and never asks the database again. Are there any frameworks for C#?

  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

• how to write sqlite update operation in two tables?

  - by sxingfeng

  I am using SQLite, TABLE A ( ID FileNAME FOLDERID ) TABLE B ( FOLDERID FOLDERPATH ) I want to write a sql statement to delete all files in A where its Folder is subfolder of C:\ABC\; How Can I make it in one sqlite statement, and is it the best way to do? Many thanks!

  Read the article

< Previous Page | 558 559 560 561 562 563 564 565 566 567 568 569  | Next Page >