Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 571/1278 | < Previous Page | 567 568 569 570 571 572 573 574 575 576 577 578  | Next Page >

• last queries mysql v$sql

  - by soField

  i have oracle background, i am looking for oracle v$sql view in mysql in order to see last queries has been run on all sessions in database how can i see this in mysql ?

  Read the article

• How to connect to a database from VC++/CLI .NET 4.0

  - by abatishchev

  How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)

  Read the article

• Shrinking database

  - by user301751

  I have been tasked to shrink a SQL server 2005 database. This ia a live database and is runing at about 35gb. How do I shrink a database? Can this be done while that database is live? How big will that database bw when it has been shrunk? Thanks in advance.

  Read the article

• How can I query all rows that are currently before data specified in one column in table?

  - by newbie

  I need to get all rows tha are valid, ValidDate is column that shows how long these database items are valid. I need to get only valid items from the database. How can I do that? I use SQL Server.

  Read the article

• How to generate script/stored procedure to copy data from one database to another

  - by aein

  I had to restore may database to 1 day erlier, so My database is missing data from a day before, and this databse has been used by users since the restoration. How do I generate script/stored procedure to copy just the missing data from the backup database into my current database. There are PK and FK relationships that need to be considering. I'm using SQL server 2005 Thanks for your help. Aein

  Read the article

• What's the best method for sanitizing user input with PHP?

  - by UltimateBrent

  Is there a catchall function somewhere that works well for sanitizing user input for sql injection and XSS attacks, while still allowing certain types of html tags?

  Read the article

• What does ON [PRIMARY] mean?

  - by Icono123

  I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of the script: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[be_Categories]( [CategoryID] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_be_Categories_CategoryID] DEFAULT (newid()), [CategoryName] [nvarchar](50) NULL, [Description] [nvarchar](200) NULL, [ParentID] [uniqueidentifier] NULL, CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED ( [CategoryID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO Does anyone know what the ON [PRIMARY] command does? Regards.

  Read the article

• access: getting create table string

  - by every_answer_gets_a_point

  i have a table in access and i would like to get the SQL string from it that will generate the table like: CREATE TABLE example ( id INT, data VARCHAR(100) ); is there any way to do this?

  Read the article

• Find units with zero categories

  - by Kevin Sedgley

  Hello, I am after an SQL command to find units with no categories. Here are the tables: Unit id name UnitCategory id name UnitCategoryIndex id categoryid unitid Thanks!

  Read the article

• how to retrieve images from database and display in div using java script

  - by mehul9595

  Hii, I want to retrieve data from sql database and display dynamically in div using javascript can anyone please help me on this... Thanks...

  Read the article

• How do I use a file grep comparison inside a bash if/else statement?

  - by openid_kenja

  When our server comes up we need to check a file to see how the server is configured. We want to search for the following string inside our /etc/aws/hosts.conf file: MYSQL_ROLE=master Then, we want to test whether that string exists and use an if/else statement to run one of two options depending on whether the string exists or not. What is the BASH syntax for the if statement? if [ ????? ]; then #do one thing else #do another thing fi

  Read the article

• i have a date (eg: 2010-04-17 ) i need the date of after 20 days from this date

  - by Ranjana

  i have a date (eg: 2010-04-17 ) i need the date of after 20 days from this date How to get the date after 20 days i.e next month some date. either in sql or in c#

  Read the article

• Can anybody help me for the syntax of select query?

  - by Azka

  i`m doing string sql = "select * from publisher where title like "'"+tbproperty.text+"; but it`s not working! regards..

  Read the article

• The table '#sql-5f8_9c' is full

  - by gansodesoya

  hello, im trying to delete a foreign key with the following syntax (5.0.45-community-nt): alter table [table] drop foreign key [fk_name] but I'm getting the folling error: The table '#sql-5f8_9c' is full – 99543 ms any ideas? thanks!

  Read the article

• extarct characters using delimiters

  - by susanthosh

  I am having string called '200_CFL_2010'. I wish to get the characters between _'s. I want the output as 'CFL'. I have to achieve it through SQL. Any idea please?

  Read the article

• How hard is it to determine what procedures/functions no longer compile?

  - by Dave

  In sql server how difficult would it be to determine what procedures/functions no longer compile? In other words, if I scripted out alter statements for all procedures and functions in a database, I'd like to know which of these statements are going to fail? I've been working on cleaning up a database I've inherited which has gone through years of changes and I'd like to what objects are going to raise errors when something tries to execute it.

  Read the article

• 42S22 SQL error: Column not found, why?

  - by Vincenzo

  This is my SQL: SELECT `tbl`.*, 123 AS `test` FROM `tbl` GROUP BY `test` It works when I run it directly in MySQL. But PDO says: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'test' in 'field list' Why so? How to cure this problem? I'm using Zend_Db.

  Read the article

• How to execute query with empty fields?

  - by Kliver Max

  I have a SQL Query: SELECT documents.*, t_rights.rights, documents_list.docs FROM documents INNER JOIN t_rights on t_rights.num=documents.type_right INNER JOIN documents_list on documents_list.num=documents.document1 WHERE code_document=1 or code_document=1 In case if i have fields documents.document1 and documents.document1 with some value all works fine. But if this field empty i get empty query result. Its possible make query like this with empty fields?

  Read the article

• Selecting min date excluding 0000-00-00

  - by nsw1475

  I am running a query in SQL, and I need to select a minimum date that is not 0000-00-00. Is there any way to exclude this value and choose the next minimum date?

  Read the article

• [ZF] How to use Zend_Db without SQL Queries?

  - by rasouza

  The last time I worked with Zend_Db I recall I used to write SQL Queries manually. I've been searching for some ORM application, but, since I read something like Zend_Db is also capable of doing so, I started to try it, but I can't find neither a good tutorial explain it or a good documentation. I read something lake Gateway pattern and ModelMapper class but I can't figure it out. Can someone shine my path? :P

  Read the article

• What does this query mean?

  - by zihado

  I'm reading a book about SQL. In that book, I saw strange query below: SELECT * into mycustomer from customer WHERE 1=2 In this query, what is "WHERE 1=2" ?

  Read the article

• Generating SQL script from MySQL database table

  - by testingmysql

  Hi, Is there any application that will read a MySQL database table and generate a SQL script of INSERT statements (so that I can copy tables from one db to another db)? OR how can I transfer content from db1.table1 to db2.table2 where table1 and table2 is same. Thank you.

  Read the article

• access forms: forcing UCASE in a textbox

  - by every_answer_gets_a_point

  i would like to force the textbox to immediately change the text to UCASE as soon as the user moves away from the field. is this possible? the important thing is that this text will be used in a SQL query to update a table.

  Read the article

• UTF-8 vs ASCII Text

  - by user15432

  Why does sql database use UTF-8 Encoding? do they both use 8-bit to store a character?

  Read the article

• How do i check if something exist without using count(*) ... limit 1

  - by acidzombie24

  My code is SELECT COUNT(*) FROM name_list WHERE [name]='a' LIMIT 1 It appears there is no limit clause in SQL Server. So how do i say tell me if 'a' exist in name_list.name?

  Read the article

< Previous Page | 567 568 569 570 571 572 573 574 575 576 577 578  | Next Page >