Search Results

Search found 36773 results on 1471 pages for 'sql statement syntax'.

Page 108/1471 | < Previous Page | 104 105 106 107 108 109 110 111 112 113 114 115  | Next Page >

• Open Source C# Syntax Editor with Intellisense

  - by Anindya Chatterjee

  Can anyone please suggest me a good open source C# code editor control with syntax highlighting and intellisense to use in my application. I am not asking for any IDE like VS or #develop, I need only a winform code editor control so that I can use it in my application for scripting. Can you please suggest me a good one ... I found ScintillaNET, but I want some other alternative..

  Read the article

• Is there a syntax highlighting editor component for Mac OS X

  - by Bytenik

  I am looking for a syntax highlighting component that I can include in a Mac OS X XCode project to allow editing of Ruby, C++, Lua, etc. I need a component that is open source or has the source included. My Google searches didn't turn up much in the way of Mac OS X frameworks or components at all, let alone the type I am looking for. Thanks for any pointers!

  Read the article

• C# Syntax Highlighting for Confluence

  - by Andrew Bienert

  Does anyone know of any C# syntax highlighter plugins for Confluence? Using the default Java highlighter works, but it misses things like string in C# and String in Java, with the latter being highlighted and the former plain black text.

  Read the article

• Syntax Highlighting VS Addins

  - by ctrlShiftBryan

  What tools are out there that compete with this product? CodeKana I know ReSharper has improved syntax highlighting. Is it comparable to this?

  Read the article

• Is there a goto statement in java?

  - by Venkats

  I'm confused about this. Most of us have been told that there is no goto statement in Java. But I found that it is one of the keyword in Java. Where can it be used? If it can not be used, then why was it included in Java as a keyword?

  Read the article

• SQL Server ':setvar' Error

  - by Randy Minder

  I am trying to create some script variables in T-SQL as follows: /* Deployment script for MesProduction_Preloaded_KLM_MesSap */ GO SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON; SET NUMERIC_ROUNDABORT OFF; GO :setvar DatabaseName "MesProduction_Preloaded_KLM_MesSap" However, when I run this, I get an error stating 'Incorrect syntax near ':'. What am I doing wrong?

  Read the article

• TextArea: Syntax Highlighted for TSQL?

  - by Abs

  Hello all, I am looking for a very simple web based syntax highlighter where users can paste in code and be able to edit the code in a simple text area. I am hoping there is one for TSQL? The best I have found so far is this but this is SQL, I was hoping it to be TSQL. I could probably edit it myself but I am looking for something that I can easily drop into my web app. Thanks all

  Read the article

• error in mysql syntax

  - by fusion

  while executing the following query, i get an error that there's an error in the syntax near line 9. since i'm using mysql workbench, i can't really figure out what could be wrong: CREATE TABLE IF NOT EXISTS `proquotes`.`thquotes` ( `idQuotes` INT NOT NULL AUTO_INCREMENT , `vAuthorID` VARCHAR(8) CHARACTER SET 'utf8' NOT NULL , `vAuthor` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL , `cQuotes` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL , `cArabic` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL , `vReference` VARCHAR(100) CHARACTER SET 'utf8' NOT NULL , PRIMARY KEY (`idQuotes`) , INDEX `vAuthorID` () , CONSTRAINT `vAuthorID` FOREIGN KEY () REFERENCES `proquotes`.`author_info` () ON DELETE NO ACTION ON UPDATE NO ACTION) DEFAULT CHARACTER SET = utf8;

  Read the article

• SQL Server 2008 Splitting string variable number of token per line

  - by josephj1989

  I have a fairly simple requirement -I have a table with the following (relevant) structure. with cte as( select 1 id,'AA,AB,AC,AD' names union all select 2,'BA,BB' union all select 3,'CA,CB,CC,CD,CE' union all select 4,'DA,DB,DC' ) i would like to create a select statement which will split each "names" column into multiple rows. For example the first row should produce 1,'AA' 1,'AB' 1,'AC' 1,'AD' Can we do it using only SQL. This is failry easy to do in Oracle.

  Read the article

• Flex Builder 3: syntax coloring, add keyword

  - by Kasper

  I wish to know where I can add Keywords for the syntax coloring in Flex Builder - i need to extend it a little for my own sanity.

  Read the article

• .NET/C# - Disposing an object with the 'using' statement

  - by AJ Ravindiran

  Hello, Suppose I have a method like so: public byte[] GetThoseBytes() { using (System.IO.MemoryStream ms = new System.IO.MemoryStream()) { ms.WriteByte(1); ms.WriteByte(2); return ms.ToArray(); } } Would this still dispose the 'ms' object? I'm having doubts, maybe because something is returned before the statement block is finished. Thanks, AJ.

  Read the article

• Why JavaScript Statement "ga = ga || []" Works?

  - by Morgan Cheng

  Below javascript statements will cause error, if ga is not declared. if (ga) { alert(ga); } The error is: ga is not defined It looks undeclared variable cannot be recognized in bool expression. So, why below statement works? var ga = ga || []; To me, the ga is treated as bool value before "||". If it is false, expression after "||" is assigned to final ga.

  Read the article

• Syntax highlighting with Chili

  - by Nimbuz

  I want to use jquery Chili plugin for syntax highlighting a piece of code thats generated on the fly, but its not working for the same, because the code is inserted into the #output div on page load. When I tried chili with static examples, it worked but not on the dynamically generated code. Is there any workaround? Thanks in advance for your help!

  Read the article

• SQL Server Distinct Question

  - by RPS

  I need to be able to select only the first row for each name that has the greatest value. I have a table with the following: id name value 0 JOHN 123 1 STEVE 125 2 JOHN 127 3 JOHN 126 So I am looking to return: id name value 1 STEVE 125 2 JOHN 127 Any idea on the MSSQL Syntax on how to perform this operation?

  Read the article

• PHP syntax highlighting in Visual Web Developer?

  - by teh_noob

  I recently installed PHP 5 on IIS, however, I am unable to find a PHP syntax highlighting plug-in or extension for VWD. Where can I find a plug-in? I thought there was an official one.

  Read the article

• delete all but minimal values, based on two columns in SQL Server table

  - by sqlill

  how to write a statement to accomplish the folowing? lets say a table has 2 columns (both are nvarchar) with the following data col1 10000_10000_10001_10002_10002_10002 col2 10____20____10____30____40_____50 I'd like to keep only the following data: col1 10000_10001_10002 col2 10____10____30 thus removing the duplicates based on the second column values (neither of the columns are primary keys), keeping only those records with the minimal value in the second column. how to accomplish this?

  Read the article

• Syntax error when using "with open" in Python (python newbie)

  - by Tony

  [root@234571-app2 git]# ./test.py File "./test.py", line 4 with open("/home/git/post-receive-email.log",'a') as log_file: ^ SyntaxError: invalid syntax The code looks like this: [root@234571-app2 git]# more test.py #!/usr/bin/python from __future__ import with_statement with open("/home/git/post-receive-email.log",'a') as log_file: log_file.write("hello world") and I am using Python 2.5.5 [root@234571-app2 git]# python -V Python 2.5.5

  Read the article

• weird array syntax

  - by dnagirl

  I'm trying to figure how a function I've been given works -- or rather doesn't work. The problematic areas include array notation like this: $small[$end[$i]{0}] I think the idea is to append "0" to the value of $end[$i] and use that for the index of $small. But it doesn't work in PHP5.3. Is this a deprecated syntax and is it trying to do what I think it is?

  Read the article

• jQuery selector syntax gives Firefox warning

  - by FreekOne

  The following code stringref = "tab_2"; jQuery('.someclass a:not(.someclass #a_someclass_'+stringref+')').css('color', '#000'); gives me this warning in the FF 3.5.5 error console and I can't figure out why: Warning: Missing closing ')' in negation pseudo-class '#a_someclass_tab_2'. Is my syntax failing me or has FF gone bonkers ?

  Read the article

• Convert this Linq query from query syntax to lambda expression

  - by Jinkinz

  I'm not sure I like linq query syntax...its just not my preference. But I don't know what this query would look like using lambda expressions, can someone help? from securityRoles in user.SecurityRoles from permissions in securityRoles.Permissions where permissions.SecurableEntity.Name == "Unit" && permissions.PermissionType.Name == "Read" orderby permissions.PermissionLevel.Value descending select permissions There is a many-to-many relationship between users and security roles that makes this extra confusing. Thanks! Kelly

  Read the article

• Why would you use "AS" when aliasing a SQL table?

  - by froadie

  I just came across a SQL statement that uses AS to alias tables, like this: SELECT all, my, stuff FROM someTableName AS a INNER JOIN someOtherTableName AS b ON a.id = b.id What I'm used to seeing is: SELECT all, my, stuff FROM someTableName a INNER JOIN someOtherTableName b ON a.id = b.id I'm assuming there's no difference and it's just syntactic sugar, but which of these is more prevalent/wide-spread? Is there any reason to prefer one over the other?

  Read the article

• Microsoft SQL Count problem

  - by Matt

  Hey smarties. I'm having trouble with the following SQL statement. I know that I can't do a GROUP BY on the OnlineStatus column, and it makes sense because it's a function call, not an actual column in my table. How would I modify this so that I can get a count of how many users are online? SELECT CASE dbo.fnGetWebUserOnlineStatus(W.Id) WHEN 1 THEN 'Online' WHEN 2 THEN 'Ingame' ELSE 'Offline' END AS OnlineStatus FROM dbo.WebUsers W WHERE W.[Status]=1 GROUP BY OnlineStatus

  Read the article

• Dynamic SQL to query an Adventureworks table

  - by salvationishere

  I am trying to see a list of tables from Adventureworks DB from "Person" schema in Sql Server 2008. I developed teh following SP, but after running it as follows it gives me error "Incorrect syntax near ')'". Do you know how I can revise this SP or exec statement? CREATE PROCEDURE [getTableNames] @SchemaName VARCHAR(50) AS BEGIN SET NOCOUNT ON; SET @SchemaName = 'PERSON' DECLARE @cmd AS VARCHAR(max) SET @SchemaName = RTRIM(@SchemaName) SET @cmd = N'SELECT TABLE_NAME ' + 'FROM information_schema.Tables ' + 'WHERE TABLE_TYPE = ''BASE TABLE'' AND TABLE_SCHEMA = @SchemaName' END exec sp_executesql getTableNames, N'@SchemaName NVARCHAR(50), @SchemaName'

  Read the article

• If else statement within Jquery function

  - by Vafello

  I have the following code in Javascript and Jquery: $("<li />") .html('Somehtml') I would like to be able to change the content of .html by using if-else statement. My code should be something like this, however it's not working. var showinfo = <?php echo '$action'; ?> $("<li />") if (showinfo == 'action1'){ .html('Somehtml') else { .html('Other html') } Any ideas how should I change it?

  Read the article

• When to use a switch statement in Java

  - by Dan

  I appreciate that anything that can be done done by a switch statment can be done by an if else statement. But are there stylistic rules for when one should use the switch rather than if else statment.

  Read the article

< Previous Page | 104 105 106 107 108 109 110 111 112 113 114 115  | Next Page >