Search Results

Search found 27497 results on 1100 pages for 'sql joke'.

Page 505/1100 | < Previous Page | 501 502 503 504 505 506 507 508 509 510 511 512  | Next Page >

• hierachical query to return final row

  - by jeff

  I have a hierarchical query that doesn't return an expected row (employee badge = 444). TABLE: hr_data badge fname supervisor_badge 111 Jeff 222 222 Joe 333 333 John 444 444 Tom 444 SQL: SELECT CONNECT_BY_ISCYCLE As IC, badge, fname, supervisor_badge FROM hr_data START WITH badge = '111' CONNECT BY…

  Read the article

• wm_concat function and small characer buffer

  - by Ruslan

  Hi, i have select like: select substr(account,1,4), currency, amount, module,count(*) quan, wm_concat(id) ids from all_transactions group by substr(account,1,4), currency, amount, module But sometimes COUNT(*) is more then 600. In that case i get: 'ORA-06502: PL/SQL: : character string buffer too small' Is there any way out to keep…

  Read the article

• Users Login Info in INFORMIX-SQL

  - by Frank Developer

  INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id, date or time.

  Read the article

• bulk insert image from relative path

  - by Markus

  Hi, I wonder if some can help me out with this little problem. I have the following insert statement: insert into symbol (sy_id, sy_fg_color, sy_bg_color, sy_icon) select 302, 0, 16245177, sy_icon = (select * from openrowset(bulk 'K:\mypath\icons\myicon.png', single_blob) as image) Is it possible to make the path relative in any…

  Read the article

• Changing a column collation

  - by Stefan

  Hey there, I have a database already set up. I am trying to change the collation to case sensitive on my username column so it restricts login parameters to what they signed up with. However I keep getting this: #1025 - Error on rename of './yebutno_ybn/#sql-76dc_8581dc' to './yebutno_ybn/user' (errno: 150) there is foreign key…

  Read the article

• SQLSTATE 08001 error

  - by Joseph

  Hi all OUR SQL Server 2008 got freeze.and not able to connect the databse and we restrted the server(windows 2008). Even we were not able to login windows(Restrted via HP ILO). ANybody face this issue?and have a resolution. [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] [298] SQLServer Error: 258, Shared Memory…

  Read the article

• MS-Access 2007 Time Online Report

  - by Daniel

  I have the following data in my database: MemberID | DateTime ------------------------------------- 1 | 31/03/2010 3:45:49 PM 2 | 31/03/2010 3:55:29 PM 1 | 31/03/2010 4:45:49 PM Every time a user is authenticated or un-authenticated this log appears in the database. What I want to be able to…

  Read the article

• DateTime.MinValue vs new DateTime() in C#

  - by MadBoy

  When getting SQL DateTime Resharper suggests to use new DateTime() when value is DBNull.Value. I've always used DateTime.MinValue. Which is the proper way? DateTime varData = sqlQueryResult["Data"] is DateTime ? (DateTime) sqlQueryResult["Data"] : new DateTime();

  Read the article

• SQLDatasource CommandTimeout not working

  - by Cedric Aube

  Good day, I'm using a SQLDataSource with a dynamic query generated c#, based on user choices in many fields. However, since our tables are very large, sometimes, I get a command timeout exception. I tried to set the property in 'Selecting' of the SqlDataSource like so: protected void…

  Read the article

• SqlCommandBuilder.DeriveParameters(command) and IsNullable

  - by Andrey

  I have written an O/R database wrapper that generates some wrapper methods for stored procs it reads from the database. Now I need to produce some custom wrapper code if an input parameter of a stored proc is defaulted to NULL. The problem is - I get stored proc parameters using: …

  Read the article

• Retrieve sequence of data from different columns.

  - by janetsmith

  Let's say I have a table containing following data: | id | t0 | t1 | t2 | | 1 | 4 | 5 | 6 | | 2 | 3 | 3 | 2 | | 3 | 6 | 4 | 5 | | 4 | 4 | 5 | 5 | I want to retrieve all the rows containing 4, 5, 6 (regardless the position of numbers in the tables), so row 1…

  Read the article

• asp.net Dynamic Data Site and MS Sql image datatype

  - by loviji

  Hello, I'm just now created Dynamic Data Entities Web Site. And I have got a problem with image type. for all sql data types generated html elements by fieldTemplate. So, how can I create fieldtemplate for image-view, and image-upload ? Thanks.

  Read the article

• List stored functions using a table in PostgreSQL

  - by Paolo B.

  Just a quick and simple question: in PostgreSQL, how do you list the names of all stored functions/stored procedures using a table using just a SELECT statement, if possible? If a simple SELECT is insufficient, I can make do with a stored function. My question, I think, is…

  Read the article

• How to convert int to char with leadind zeros ?

  - by Bitnius

  I need to convert int data table field to char leading zeros example: 1 convert to '001' 867 convert to '000867' thx. ( This is my response 4 Hours later ... ) I tested this T-SQL Script and work fine for me ! DECLARE @number1 INT, @number2 INT SET @number1 = 1 …

  Read the article

• LINQDataSource - Query Multiple Tables?

  - by davemackey

  I have a database and I've created a DBML Linq-to-SQL file to represent this database. I've created a new aspx page and dropped a linqdatasource and a formview control onto it. When I configure the linqdatasource it gives me the choice only to select * from one…

  Read the article

• Data Access Layer with Enterprise Library in Mobile Applications

  - by l2mt

  How can I use Enterprise Library to do a Data Access Layer in c# for Sql CE and .NET Compact Framework? I haven't found clear examples. I would like to learn Enterprise Library but any example will be appreciated.

  Read the article

• Semi-complex aggregate select statement confusion

  - by Ian Henry

  Alright, this problem is a little complicated, so bear with me. I have a table full of data. One of the table columns is an EntryDate. There can be multiple entries per day. However, I want to select all rows that are the latest entry on their respective…

  Read the article

• SQLCMD Syntax error when running script that runs fine in management studio

  - by Troy

  When I run the this select '$(''test'')' in SQL Management Studio 2008 it returns $('test') When I run sqlcmd -S SERVER -E -d DATABASE -q "select "$(''test'')" on the command line it returns Sqlcmd: Error: Syntax error at line 1 near command '''. If I…

  Read the article

• Assign a post to a user in ASP.NET Membership

  - by Alon

  I'm writing a forum in ASP.NET. I have a table of posts. How can I assign a post to a user? If I had a normal User table, I'd just creating a new field in the post table "UserId" and creating an assocation in the Linq to Sql designer. But now? Should I…

  Read the article

• Report Builder 2.0 : How to get the correct timezone info.

  - by Veeravendhan

  I am developing report using SQL Report Builder 2.0, In this I am passing the timezone offset value as a parameter (-04:00). Using "TimeZoneInfo" I am getting all the timezones available from the system. But I am checking the timezone with the offset…

  Read the article

• .NET Message Queuing using SQL Server as Message Storage

  - by Yoann. B

  Hi, I'm looking for a MSMQ alternative which use SQL Server as messages persistance since MSMQ as some limitations : 4Mb Message Size, 1.6Go Queue Size ... Is there any open source or free project doing that ? Thanks.

  Read the article

• SQL DB User's changes

  - by Ajay Kumar Miglani

  Hi, I , unknowingly, create a user in database with loginname of 'windows_user' instead of sql server user , now enable to drop. pl suggest the way .. Regards Ajay Kumar Miglani Delhi-India

  Read the article

• MySQL - connection and security

  - by Phil Jackson

  Hi, I was wondering if someone could tell me if there is any potential security breeches that could occur by connecting to a sql database that does not reside at 'localhost' i.e. via ip address? Regards, Phil

  Read the article

• Caching a user control

  - by Rishabh Ohri

  I have a user control which I want to Output cache( fragment cache) and set the dependency to a query. I mean that on change or modification of data returned by that query the cache should get invalidated. I have read that in the output cache…

  Read the article

• LINQ Query Help!

  - by rk1962

  Can someone hep me converting the following SQL query into LINQ? select convert(varchar(10),date,110) as 'Date', max(users) as 'Maximum Number of Users', max(transactions) as 'Maximum Number of Transactions' from stats where…

  Read the article

< Previous Page | 501 502 503 504 505 506 507 508 509 510 511 512  | Next Page >