Search Results

Search found 10550 results on 422 pages for 'syntax rules'.

Page 204/422 | < Previous Page | 200 201 202 203 204 205 206 207 208 209 210 211  | Next Page >

  • MS SQL Server stored procedure meaning

    - by den-javamaniac
    Hi. I'm developing a simple database architecture in VisualParadigm and lately ran over next code excerpt. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'getType') AND type in (N'P', N'PC')) DROP PROCEDURE getType; Next goes my stored procedure: CREATE PROCEDURE getType @typeId int AS SELECT * FROM type t WHERE t.type_id = @typeId; Can anyone explain what does it mean? P.S.: It would be great, if you may also check for any syntax errors as I'm totally new to MSSQL and stored procedures.

    Read the article

  • Facebook Privacy Permissions Design

    - by Ian
    Does anyone know the general layout of how facebook's privacy permissions system works (database)? I've been trying to figure out how they manage to have such a complex set of rules be applied to various content on their site, yet it remains fast. How are they doing that?

    Read the article

  • MYSQL updating data from other table

    - by atif089
    Hi, I have two tables like of this structure content (content_id, content_type, user_id, time, comment_count) comments (comment_id, content_id, userid, comment, comment_time) What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) from the comments table. I am not able to figure out the right syntax Thanks

    Read the article

  • scala implicit or explicit conversion from iterator to iterable

    - by landon9720
    Does Scala provide a built-in class, utility, syntax, or other mechanism for converting (by wrapping) an Iterator with an Iterable? For example, I have an Iterator[Foo] and I need an Iterable[Foo], so currently I am: val foo1: Iterator[Foo] = .... val foo2: Iterable[Foo] = new Iterable[Foo] { def elements = foo1 } This seems ugly and unnecessary. What's a better way?

    Read the article

  • Custom warning in Xcode

    - by maximumnamelength
    I'm working on an API library and I'd like to add a few warnings that would appear when another developers builds the app if an optional apikey is not included. It should be buildable w/o the key (since it's optional) so I can't just add a syntax error to force a build error. I know Xcode supports TODO and FIXME but those aren't really highlighted anywhere major. Any other thoughts on how to approach this?

    Read the article

  • What does the following line of a bash script do?

    - by Bialecki
    Usually work in Windows, but trying to setup RabbitMQ on my Mac. Can someone let me know what the line below does? [ "x" = "x$RABBITMQ_NODE_IP_ADDRESS" ] && [ "x" != "x$NODE_IP_ADDRESS" ] && RABBITMQ_NODE_IP_ADDRESS=${NODE_IP_ADDRESS} Specifically, I'm curious about the [ "x" = "x$RAB..."] syntax.

    Read the article

  • Switch case in where clause (sql server)

    - by user685565
    I want to use case in sql statement where clause but I have a problem as I want to create a where clause condition on the basis of some value and I want to set a not in clause values on the basis of it here is the query where am facing an issue WHERE CODE = 'x' and ID not in ( case when 'app'='A' then '570','592' when 'Q' then ID 592,90 else 592,90 END but its not syntax

    Read the article

  • How to store the hostname in a variable in a .bat file?

    - by eqbridges
    I would like to convert this /bin/sh syntax into a widely compatible Windows batch script: host=`hostname` echo ${host} How to do this so that it'll work on any Windows Vista, Windows XP, and Windows 2000 machine? To clarify: I would then like to go on in the program and use the hostname as stored in the variable host. In other words, the larger goal of the program is not to simply echo the hostname.

    Read the article

  • Where can I find some good tutorials for C++

    - by Rob
    My friend has convinced me to start learning some C++, so my question is simple: where can I find some good tutorials for it? But please don't link me to the usual dry boring tutorials that only tells you the function syntax, I need more thorough explanations. I get sidetracked very easily, and I need tutorials that are more on a human level, that I'll not only learn from, but enjoy reading as well. So I'd appreciate any links that would help :)

    Read the article

  • Unity 2.0 and policy injection in .config

    - by marcusoft.net
    I want to use unity (2.0) to resolve my dependencies in a way so that i can configure policy injection (policies, matching rules and call handlers) in the .config file. Or an other way to put it; i want my resolved objects to be "policy enabled", so that i can add and change to policies in config without have to recompile. Any ideas on how to do that?

    Read the article

  • Calling function with 1 paremeter @ selector.

    - by Mr. McPepperNuts
    I want to call this guy -(void)addFavorite:(NSString *)favoriteToAdd at, @selector here action:@selector([addFavorite favoriteToAdd:@"string"])]; But I keep getting syntax error no matter which way I write it. Can someone point out the appropriate way to call this function? When it had no parameter and was "addFavorite," it worked fine.

    Read the article

  • Multiple Regex on String

    - by George
    How can I apply multiple regexs to a single string? For instance, a user inputs the following into a text area: red bird blue cat black dog and I want to replace each carriage return with a comma and each space with an underscore so the final string reads as red_bird,blue_cat,black_dog. I've tried variations in syntax along the lines of the following so far: function formatTextArea() { var textString = document.getElementById('userinput').value; var formatText = textString.replace( new RegExp( "\\n", "g" ),",", new RegExp( "\\s", "g"),"_"); alert(formatText); }

    Read the article

  • Can I lock tables in an IF statement in MySQL?

    - by MalcomTucker
    This is throwing a syntax error - --from body of a stored proc IF (name = in_name) SET out_id = temp; ELSE LOCK TABLE People WRITE; INSERT INTO People (Name) VALUES (in_name); UNLOCK TABLE; SELECT LAST_INSERT_ID() INTO out_id END IF do I have to lock any tables I need at the start of the SP?

    Read the article

  • How to display complex object in debugger?

    - by 4thSpace
    I'd like to display the contents of the property myarray, from the following singleton: [Session sharedManager].myarray I've tried these: po [Session sharedManager]. myarray po [[Session sharedManager] myarray] but always get this error: A syntax error near end of expression. Any suggestions?

    Read the article

  • Query having 2 Where Clause

    - by Harsha M V
    i am trying to login and want to validate username and password against the records in the database. I am not sure how to pass two Where clause public Boolean login(String username, String password) throws SQLException { Cursor mCursor = db.query(TABLE_USERS, new String[] { ID, KEY_NAME, KEY_USERNAME}, KEY_USERNAME + "=" + "'"+username+"'", KEY_PASSWORD + "=" + "'"+password+"'", null, null, null, null, null); if (mCursor.moveToFirst()) { return true; } return false; } Am getting a Syntax Error.

    Read the article

< Previous Page | 200 201 202 203 204 205 206 207 208 209 210 211  | Next Page >