Non-clustered index in sql server
- by girish
can i specify more then one column as Non-cluster index, what will it affect?
Search Results
Search found 36186 results on 1448 pages for 'sql 11'.
Page 390/1448 | < Previous Page | 386 387 388 389 390 391 392 393 394 395 396 397 | Next Page >
-
-
How to retreive the last row of a table?
- by Nila
How to retreive the last row of a table which doesn't has any unique id like select * from sample where id=(select max(id) from sample)Read the article
-
Options on installations of sql server 2008 express?
- by ray247
I'm installing sqlserver 2008 express and I have a couple of questions, by default on the collation, it has SQL_Latin1_General_CP1_CI_AS I'm just wondering which collation I should choose so that it can store all languages, English, Asian etc. also this is a brand new installation on a brand new box, should I use Default Instance or a Named…Read the article
-
SQL query to get most
- by chama
I have a database with the following tables: Employee (EmpID, FirstName, LastName, RegionID) EmployeeSkills(EmpID, SkillID) [this is a linking table for the M:N relationship between Employees and skills] Skills(SkillID, Description) I need to list the name of the skill that most employees have. I tried doing a max(count(skillID)), sqlserver…Read the article
-
MSSQL 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 MSSQL 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
-
merging two tables, while applying aggregates on the duplicates (max,min and sum)
- by cloudraven
I have a table (let's call it log) with a few millions of records. Among the fields I have Id, Count, FirstHit, LastHit. Id - The record id Count - number of times this Id has been reported FirstHit - earliest timestamp with which this Id was reported LastHit - latest timestamp with which this Id was reported This table only has one…Read the article
-
SQL: count days in date range?
- by John Isaacks
I have a query like this: SELECT COUNT(*) AS amount FROM daily_individual_tracking WHERE sales = 'YES' AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31' I am selected from a date range. Is there a way to also get the total days in the date range?Read the article
-
Copy data from one SQL Server database table to the other
- by lucky
I don't know how to copy table data from one server - database - table TO other sever - database - table. If it is with in the same server and different databases, i have used the following SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data) INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy…Read the article
-
How to remove the secondary database created by sp_add_log_shipping_secondary_database
- by Siegfried
How to remove the secondary database created by sp_add_log_shipping_secondary_databaseRead the article
-
C# SQL create table IF it doesn't already exist
- by jakesankey
Hey, I am trying to put a little logic into my C# app that will create a table called Import, IF it doesn't already exist.. here is my code, it doesn't seem to work tho. con.Open(); using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandText = …Read the article
-
how to return multiple records from a view in sql server 2008
- by kumarreddy
i have a view which presently returning single record when called....i like it to return three records may be upon inner joining a different view or temp table...as those records share the same data except single column... im not sure about this plz some one throw light on this please..thank you in advanceRead the article
-
Forcing LINQ to SQL to make one single call for all child rows
- by zaph0d
Let say I have a method (example taken from another post): public IQueryable<CityBlock> GetCityBlocks(){ var results = from o in db.city_blocks let buildings = GetBuildingsOnBlock(o.block_id) //returns Iqueryable select new CityBlock { BuildingsOnBlock = buildings, …Read the article
-
Which mysql construct is faster?
- by Olaseni
SELECT ..WHERE COL IN(A,B) or SELECT ... WHERE (COL = A or COL = B) I'm trying to find out what are the differences between the two constructs? Would there be significant performance gains either way if utilized on resultsets that are nearing the 1 million mark?Read the article
-
i want to insert values from table1 to table2 with incremantal value
- by adnan
i tried something like this but the id value is not changing, getting the value for first record and set the value for all rest... insert into table1 (Id,b,c,d) (select (select max(Id)+1 from table1),x,y,z from table2 where... )Read the article
-
Selecting the 2nd row in sql
- by Alex Chen
I want to select the second row only from the table. From the ClientUserName column. SELECT ClientUserName, DestHost, count(DestHost) counts FROM #ProxyLog_record WHERE ClientUserName = (Select top 1 ClientUserName from #ProxyLog_count_2) GROUP BY ClientUserName, DestHost ORDER BY counts DESC The (Select…Read the article
-
Call stored proc using xml output from a table
- by user263097
Under a tight deadline and I know I can figure this out eventually but I don't have much time to do it on my own. I have a table that has columns for customer id and account number among many other additional columns. There could be many accounts for a single customer (Many rows with the same customer id but different account…Read the article
-
Stored Procedure - forcing execution order
- by meepmeep
I have a stored procedure that itself calls a list of other stored procedures in order: CREATE PROCEDURE [dbo].[prSuperProc] AS BEGIN EXEC [dbo].[prProc1] EXEC [dbo].[prProc2] EXEC [dbo].[prProc3] --etc END However, I sometimes have some strange results in my tables, generated by prProc2, which is dependent…Read the article
-
SQL database self interaction entity
- by Ricardo Costa
I've been working on a database, wich is referent to an Aeroport management. I'm having a problem that it's freaking me out.. What i'm trying to do is, assuming that a client wants to know the distance between 2 locations, in miles or kms. As an example, if the user wants to know the distance between London and Amsterdam,…Read the article
-
Create a complex SQL query?
- by mazzzzz
Hey guys, I have a program that allows me to run queries against a large database. I have two tables that are important right now, Deposits and withdraws. Each contains a history of every user. I need to take each table, add up every deposit and withdraws (per user), then subtract the withdraws from the deposits. I then…Read the article
-
Taking Database backup: How to skip '/' from getdate so that it is not considered to be in a folder
- by Shantanu Gupta
I am trying to take database backup. How can I do that when getdate is being appended with file name with format dd/mm/yyyy. declare @dbName VARCHAR(100) declare @path VARCHAR(100) set @dbName='CallMeIndia' set @path='F:\'+@dbName +'-'+convert(varchar(50),getdate(),103)+'.bak' BACKUP DATABASE @dbName TO DISK= @pathRead the article
-
Insert into ... Select *, how to ignore identity?
- by Haoest
I have a temp table with the exact structure of a concrete table T. It was created like this: select top 0 * into #tmp from T After processing and filling in content into #tmp, I want to copy the content back to T like this: insert into T select * from #tmp This is okay as long as T doesn't have identity column, but in…Read the article
-
SQL Server with XML and selecting child nodes
- by Zenox
I have the following XML: <tests> <test>1</test> <test>2</test> <test>3</test> </tests> And I am trying the following query: CREATE PROCEDURE [dbo].[test] @Tests xml=null AS BEGIN SELECT doc.col.value('(test)[1]', 'nvarchar(50)') FROM …Read the article
-
SQL server db and printing confusion.
- by RAJ K
I have billing application based on C# WPF, Screenshot is here. as you can see there is a datagrid, programmatically binded. this datagrid contains lists of item going to be billed. So when user reaches "Print memo" part (in stack panel 2) i have to update listed items in stock table and insert entries in sales…Read the article
-
can't attach .mdf into sql server management
- by Alexander
Why can't I browse deeper into the folder, I still have some folders there:Read the article
-
What's the difference between these SQL conditions?
- by wesley luan
Select * from Example where 1 = Case when :index = 0 then Case when DateEx Between :pDat1 and :pDate2 then 1 end else Case When :index = 1 or :index = 2 then Case When DateEx >= :pDat1 then 1 end end end And Select * from Example where 1 = Case when :index =…Read the article
