Search Results

Search found 37012 results on 1481 pages for 'sql query'.

Page 132/1481 | < Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >

• Sql Query to list all views in an MS SQL Server 2005 database

  - by Matthias

  I need an sql query to enumerate all views (I only need the view names) of a specific database in MS SqlServer 2005. Thanks in advance!

  Read the article

• Create your own language in SQL 2005

  - by nimo

  I have developed my own word breaker for SQL 2005 and the Full Text Search feature. I know how to use it by simply hijacking an existing language and add the wordbreaker to the registry for the hijacked language. However I'm not completely satisfied with that solution. I want to create a completely new language is this possible?

  Read the article

• inserting only date in a column in sql server

  - by sam

  hi! Is there a way to insert only date in a datetime column in sql server without the time? for example date (datetime) =============== 12-01-2000 16-02-2000 or i should store this as a varchar and cast it when retriving so that i can convert to whatever form i need.

  Read the article

• How do you preform an IF...THEN in a SQL SELECT

  - by Eric Labashosky

  I want to be able to perform a IF...THEN in an SQL SELECT Statement. For Example; SELECT IF(Obsolete = 'N' or InStock = 'Y';1;0) as Salable, * FROM Product

  Read the article

• Getting maximum value of float in SQL programatically

  - by Axarydax

  Is there an method for programatically (in T-SQL) retrieving the maximum (and minimum) value of a datatype? That it would act like float.MaxValue in C#. I would like to use it in some selection when the parameter does not equal any actual values in the database, so I would use something like declare @min float declare @max float /*fill @min and @max, can be null if undefined*/ select * from foo where bar between isnull(@min,0 ), isnull(@max,max(float)/*magic*/) Thanks

  Read the article

• SQL Server and Identity column

  - by andrew007

  Hi, I just noticed that if I have an identity column in a table, when I insert new rows SQL Server 2008 is automatically filling up the sequence if there are discontinuity. I mean, if in my identity column I have 1,2,5,6 if I insert other two rows in the table the system puts automatically 3,7 in the identity column. Do you know how to control this behavior? THANKS

  Read the article

• Get row where date column = today - SQL server noob

  - by Chin

  In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanks

  Read the article

• auto incrementing id in sql server

  - by Sagar

  How to auto increment an id in SQL Server whenever a new row is inserted in the table? This id is primary key of the table.

  Read the article

• To get data from table in script from sql server 2005

  - by Zerotoinfinite

  Hi Experts, I am using sql server 2005 I have a table [say tblHistory] and this table contains 100 rows. I have created the same table at the server, but the table doesn't have the data, I want data from tblHistory to convert into INSERT INTO tblHistory ------ so that I could run the script on the server to fill the database. Please help, it's urgent

  Read the article

• SQL Server: how to set return format ?

  - by Quandary

  Question: The new SQL Server 2008 database returns me values formatted English (date/float). Is there a way I can set the return format ? For example temporarely switching the database language? Or just set the language for the current query ?

  Read the article

• Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

  - by Saravanan

  Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework? thanks

  Read the article

• MS SQL SERVER BACKUP Issue

  - by Dhivagar

  In sql server 2008, i have taken Full backup type of my database and database was successfully done.My question is while restoring it how can i check or know that my whole backup was perfect ?

  Read the article

• SQL Server 2005 config file path of databases loaded

  - by Michael

  I need to find the path of the database (MDF) or at least the database logs loaded but for some reasons I cannot login through the SQL Server so I need to know if you know any file/config file that keeps the path of the databases or log file .

  Read the article

• use a sql select statement to get parameters for 2nd select statement

  - by diver-d

  Hi there, I am trying to write a sql statement that I have 2 tables Store & StoreTransactions. My first select command looks like SELECT [StoreID],[ParentStoreID] FROM Store Very simple stuff. How do I take the returned StoreID's and use them for my 2nd select statement? SELECT [StoreTransactionID],[TransactionDate],[StoreID] FROM StoreTransactions WHERE StoreID = returned values from the above query Any help would be great!

  Read the article

• Can SQL Server 2008 use a variable in a WHERE IN clause

  - by CWinKY

  Are there any updates in SQL 2008 to allow a variable for the IN of a where clause? Declare @InParams varchar(100) Set @InParams = '1,2' Select * from Category Where CategoryID in @InParams

  Read the article

• Migrate MySQL database to Sql Server

  - by RPK

  I recently encountered a problem in my production database due to MySQL bug. The bug is in the TimeStamp column. To avoid any inconvenience, I want to migrate the database to either Sql Server. Is there any FREE tool to easily and reliably migrate data and table structures?

  Read the article

• How to execute .sql file in SQL server 2000/2005/2008

  - by Stan

  When get a .sql file, how do you execute it? Double click to open it and press F5? Is there any other way to execute it and also able to see the execution result. Thanks.

  Read the article

• Sql server like for Integer

  - by Prashant

  I have a column which is integer and I want to search all numbers starting with 1500. I know I could use something like left(accountid,4)= 1500. But is that an optimum solution or is there a better approach? I am using Sql Server 2005.

  Read the article

• Cam you insert the results of a dynamic sql call into a SQL Server 2005 table variable

  - by codingguy3000

  Is there anyway to do this in SQL Server 2005? declare @tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) declare @mysql nvarchar(4000) set @mysql = 'insert into @tv_tablelist(newvar) values (''test test test'')' Exec sp_executesql @mysql, N'@tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) OUTPUT', @tv_tablelist OUTPUT select * from @tv_tablelist

  Read the article

• saving the FOR XML AUTO results to variable in SQL

  - by petergo

  select @[email protected]('*') for xml raw,type Above statement will generate following alert: Msg 6819, Level 16, State 3, Line 2 The FOR XML clause is not allowed in a ASSIGNMENT statement.

  Read the article

• SQL: How to order values inside group by

  - by Denis Yaremov

  Consider the following MS SQL Server table: ID | X | Y ------+-------+------- 1 | 1 | 1 2 | 1 | 2 3 | 1 | 3 4 | 2 | 40 5 | 2 | 500 6 | 3 | 1 7 | 3 | 100 8 | 3 | 10 I need to select the ID of the row that has the maximum value of Y grouped by x, i.e: ID | X | Y ------+-------+------- 3 | 1 | 3 5 | 2 | 500 7 | 3 | 100 The query will be nested several times so an optimal performance solution is required... Thank you!

  Read the article

• SQL Server- PIVOT table. transform row into columns

  - by Matt

  I am trying to convert rows into columns. here is my query SELECT M.urn, M.eventdate, M.eventlocation, M.eventroom, M.eventbed, N.time FROM admpatevents M INNER JOIN admpattransferindex N ON M.urn = N.urn AND M.eventseqno = N.eventseqno AND M.eventdate = N.eventdate WHERE M.urn = 'F1002754364' AND M.eventcode = 'TFRADMIN' Current result URN Date Location Room Bed Time F1002754364 20121101 EDEXPRESS 4-152 02 0724 F1002754364 20121101 CARDSURG 3-110 02 1455 F1002754364 20121102 CHEST UNIT 6-129-GL04 1757 required result F1002754364 20121101 EDEXPRESS 4-152 02 0724 20121101 CARDSURG 3-110 02 1455 20121102 CHEST UNIT 6-129-GL 04 1757 Thanks for your help.

  Read the article

• SQL Server: how to create multiple text files from a table

  - by Patrick

  hi, I need to extract data from my SQL Server database into multiple text files. I have a table with 4 columns: UserID, UserName, Tag, Score. I need to create a text file for each Tag (so basically I need to group by Tag and order by score). Before to start I would like to know what's the fastest way to create several text files: File titles = TAG field each line = userID

  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

• What is a good reason to use SQL views

  - by Luke101

  I am reading though the sql server 2008 bible and I am covering the views section. But he really dont explain the purpose of views. What is a good use for views. Should I use them in my website and what are the benefits of them.

  Read the article

< Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >