Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 269/1156 | < Previous Page | 265 266 267 268 269 270 271 272 273 274 275 276  | Next Page >

• What are good alternatives to SQL?

  - by Brendan Long

  I occasionally hear things about how SQL sucks and it's not a good language, but I never really hear much about alternatives to it. So, are other good languages that serve the same purpose (database access) and what makes them better than SQL? Are there any good databases that use this alternative language?

  Read the article

• How to insert a float into a SQL table in the right locale (in .Net)

  - by SoMoS

  Hello, I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server? Do i need to detect the locale of the server before constructing the query or what? Thanks in advance mates.

  Read the article

• Save Field Names in Microsoft SQL Query Analyzer

  - by Michael Shnitzer

  When you save the results of a SQL query using "Microsoft SQL Query Analyzer" (version 8), the results of the query are saved but the column headers (field names) are not. Any idea how to save the field names to the results file as well?

  Read the article

• ERP system written in SQL Server, Trigger job not running

  - by user333809

  We are a manufacturing plant that runs off an ERP system written in SQL Server. I have never worked with SQL and therefore do not know the language. What I do know is that a trigger job that was running and updating data for us, is now NO longer running. Is anyone familiar enough to answer any questions about this for me??? Any help would certainly be appreciated! Thanks, Jana

  Read the article

• SQL Server: how to export a table

  - by Patrick

  how can I export a SQL Server table to Mysql ? I guess I need to export a .sql file compatible... thanks

  Read the article

• MS SQL 2008 and MySQL Daily Backups

  - by Tyler

  Is there a quick and easy way to backup both MS SQL 2008 and MySQL, all their databases? Right now I have a batch script that runs, but I have to manually add a database each and every time, and I'm sick of maintaining it. So I want to set it up to backup all MS SQL and then all MySQL, I dont care if its two different solutions, just want the ability to backup all the databases without having to type them in. Thank you.

  Read the article

• LINQ version of SQL's LIKE statement

  - by Erwin

  Hi fellow coders I'm new at LINQ, searching the net for LINQ samples that mimic SQL's LIKE statement doesn't satisfy myself. What I want is producing the same query result as this SQL SELECT * FROM table_1 WHERE column_1 LIKE '__0%' I want to query from table_1 where column_1's third character is '0' Is there equivalent statement in LINQ :D thank you

  Read the article

• SQL, combining the result

  - by Newbie

  I am using Access and have this SQL SELECT land.id, land.official_name, vaksiner.vaksiner FROM land INNER JOIN (vaksiner INNER JOIN land_sykdom ON vaksiner.id = land_sykdom.sykdom) ON land.kort = land_sykdom.land ORDER BY land.official_name The SQL gives me a result like this: id official_name vaksiner 1 a A 1 a C 2 b A 2 b B 2 b C But I want to combine the result so that it looks like this: id official_name vaksiner 1 a A, C 2 b A, B, C

  Read the article

• Simulating MySql OLD_PASSWORD in .NET or MS SQL ?

  - by miensol

  I have started a new project in .NET which uses some old system's datababase in MySql. The data stored in mysql is periodicaly transfered to MS Sql on which our system works. I need to authenticate users with their login and password. User's passwords are stored as hash generated by OLD_PASSWORD function from mysql. Is there any way to generate such hash using Ms Sql or .NET ?

  Read the article

• Save All Values of Database to Text File?

  - by cam

  I was wondering if there was a way to extract all the values of a column, and then save each value into separate text files (labeled ANYTHING, 1-100 works fine). I know how to do this through another language, but I'm using SQL Server 2008 with Microsoft SQL Server Manager and it would save me some time from figuring out how to do it through C#.

  Read the article

• Sharing LINQ-to-SQL classes/models between multiple projects in a solution

  - by Maxim Z.

  I have multiple C# projects in a Visual Studio solution right now that will all use the same SQL Server database. What is the proper way to share LINQ-to-SQL classes between projects? I'm considering just copying the dmbl files into each project, but I think that may be too redundant. Is there a better way to approach this?

  Read the article

• doctrine: save 20 users with one sql query?

  - by fayer

  i save a user like this in doctrine: $user = User(); $user->name = 'peter'; $user->save(); is there a way to save 20 users in one sql query? or do i have to loop the above code 20 times hence creating 20 sql queries? thanks

  Read the article

• Any good examples/references implementing ACLs via SQL?

  - by FilmJ

  I currently have a web-application that implements a rudimentary form of ACL using UNIONs in SQL, but it's somewhat limited, and doesn't necessarily scale that well I'm interested in any alternative ACL algorithms that could be implemented efficiently in SQL. Thanks!

  Read the article

• Linq-To-SQL Vs T4 Template.

  - by jalpesh

  I am using Linq-to-SQL for my projects but i heard about the T4 Template Code generator? Whether T4 Template is better then Linq-To-SQL Data Context?

  Read the article

• Little (Employee - Shift) SQL Database help

  - by latinunit-net

  Hi Guys, Im creating a little database that has employee, emp_shift, shift, tables now im suppose to be able to calculate at the end of the month which employee has done the most number of shifts. Ive created the SQL creation, insert statements for the tables, and a little diagram to explain what im trying to acomplish, im a beginner and this is a homework ive been trying to do for the last 4 days. Diagram: http://latinunit.net/emp_shift.jpg SQL: latinunit.net/emp_shift.txt can you please guys check it, deadline is 2 days and this is just a part of the whole database

  Read the article

• Show child and parent together using CONNECT BY Sql statement

  - by martilyo

  I have an sql statement that currently is just returning all the end parent rows for a list of child rows: SELECT DISTINCT row FROM table heirarchy WHERE parent_row = NULL CONNECT BY nocycle PRIOR parent_row = row START WITH row IN (select statement returning child rows) Is there a way to show the child and its corresponding parent together in the same result set using a modified version of my sql? Thanks.

  Read the article

• howto have condition in a nested SQL query?

  - by fenec

  here is my SQL statement , i would like to find all the games that have the status 0 and names of teams that are like key_word or the sport's name that are like the key word. The problem is that all the games that are displayed don't have status 0 . What am i doing wrong? sql="select * from games where games.status=0 and games.team_2_id IN (select id from teams where name like '"+key_word+"') or games.team_1_id IN (select id from teams where name like '"+key_word+"') or games.sport like '"+key_word+"' "

  Read the article

• using ansi sql syntax for formatting Numeric

  - by changed

  Hi I am using two different databases for my project. Oracle and apache derby and trying to use as much as possible ansi sql syntax supported by both of the databases. I have a table with column amount_paid NUMERIC(26,2), in a table. My old code which was using oracle db need to retrieve value in this format SELECT LTRIM(TO_CHAR(amount_paid,'9,999,999,999,999.99')) . How can i do this using ANSI sql syntax.

  Read the article

• SQL Server: Declaring variable type based on a column type

  - by Bernard Dy

  In Oracle's PL-SQL, you can declare a variable and define its type based on a table column: declare var1 table.column%TYPE; Is it possible to do something similar in MS SQL Server? I searched but could not find a duplicate for this question. If there is one, please let me know and I'll refer to it and delete this.

  Read the article

• Linq DBML multiple sql servers

  - by Hurricanepkt

  I have an archive system that had to be on two sql databases for simplicity one is Archive2009 and the other Archive2010 they are both on the same sql server and instance and have identical structures however I have a page that needs to view the old one and the new one (I can make two seperate pages) How best would I go about doing this? Dynamically changing the connection string etc?

  Read the article

• Oracle for the SQL Server books?

  - by MattK

  I am looking for a reference for a SQL Server DBA who has to come up to speed on basic Oracle 11 DBA tasks: backup, recovery, user administration, etc. There seems to be some material on the web for the reverse: Oracle - SQL Server, but the only potentially useful resource I have found in a few searches is yet to be published: http://www.amazon.com/Oracle-Database-Administration-Microsoft-Osborne/dp/0071744312 Can anyone provide references to something currently available?

  Read the article

• Oracle for the SQL Server DBA guides?

  - by MattK

  I am looking for a reference for a SQL Server DBA who has to come up to speed on basic Oracle 11 DBA tasks: backup, recovery, user administration, etc. There seems to be some material on the web for the reverse: Oracle - SQL Server, but the only potentially useful resource I have found in a few searches is yet to be published: http://www.amazon.com/Oracle-Database-Administration-Microsoft-Osborne/dp/0071744312 Can anyone provide references to something currently available?

  Read the article

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• SQL programming interface to external storage application

  - by Gopala

  My application is a non-relational database application with a tcl interface to retrieve data. I would like to add SQL programming interface to my application. Is there any library that converts SQL/PLSQL statements to API calls? It should also support stored procedures. SQLite(Embedded) has 'virtual table' mechanism that suits my requirement but it lacks stored procedure feature. -Gopala

  Read the article

• sql query to replace a blank cell with any text in access 2007 column

  - by silverkid

  I have an access table which has some cells as blank ( no data ) in a particular column. how i write an sql query to replace a blank cell with any text in access 2007 column any help appreciated. i have already tried the sql query update tableA set colA = 'abc' where ISNULL(colA); It updates 0 rows.

  Read the article

< Previous Page | 265 266 267 268 269 270 271 272 273 274 275 276  | Next Page >