Search Results

Search found 43145 results on 1726 pages for 'sql select'.

Page 251/1726 | < Previous Page | 247 248 249 250 251 252 253 254 255 256 257 258  | Next Page >

• What is better sql string or stored procedures?

  - by Sem Dendoncker

  Hello, I have a dataaccesslayer which uses Enterprice libraries. Now I was wondering what is better? Using stored procedures to create my sql or writing sql strings within the dataaccess classes? Cheers, M

  Read the article

• How to store data in a table locally and present it in C#

  - by joslinm

  I want to setup a table that can: Save the data on the user's machine Reference & present the data in the GUI Capable of adding rows dynamically during runtime What's the best way to go about this? DataGridView or TableLayoutPanel or...? I'm having trouble with SQL server CE, as I was going to connect it with the DataGridView, but I'm very new to this kind of work, and wondered if it was even necessary to use SQL.

  Read the article

• TSQL Writing into a Temporary Table from Dynamic SQL

  - by Jeff

  Consider the following code: SET @SQL1 = 'SELECT * INTO #temp WHERE ...' exec(@SQL1) SELECT * from #temp (this line throws an error that #temp doesn't exist) Apparently this is because the exec command spins off a separate session and #temp is local to that session. I can use a global temporary table ##temp, but then I have to come up with a naming scheme to avoid collisions. What do you all recommend?

  Read the article

• What is the best way to estimate how much memory a row will require?

  - by Ryan Elkins

  I'm working on a project that will have a single table holding lots and lots of rows on either a SQL Server or SQL Azure installation. I'm trying to estimate how many rows I can store per GB. Is it a matter of simply adding up the memory size of the individual column data types? Is there other overhead to consider?

  Read the article

• weekly Automatic running sql server script

  - by AmRoSH

  I have sql server script and i want to automatic run it on the database every week. any help. i tried sql server agent job but i have alot of data bases on my server and i should make step to every database and it will run in the same day and same time.

  Read the article

• Query between SQL server and Client side

  - by Karim

  I create a query: Select * from HR_Tsalary where month='3' and year ='2010' the result is 473 records and I found 2 duplicate record, then I create another query to find duplicate record only: SELECT Emp_No, COUNT(*) FROM HR_Tsalary WHERE year = '10' AND month = '3'GROUP BY Emp_No HAVING COUNT(*) 1 the result is zero record from client side (thru Visual Basic Adodb code). But when I use same query from server the result is 2 records. Is there any different when create a query between from server side and client side?

  Read the article

• Restrict varchar() column to specific values?

  - by adam

  Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008? For example, I need a column called Frequency (varchar) that only accepts 'Daily', 'Weekly', 'Monthly', 'Yearly' as possible values Is this possible to set within the SQL Server Management Studio when creating the table?

  Read the article

• Getting/setting SQL Server instance settings

  - by dotnetdev

  Hi, Is there a way to get the settings of a SQL Server instance via C# or TSQL? And then apply these settings to another SQL Server? Thanks

  Read the article

• 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

• 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

• MSSQL SQL Building Software

  - by TheGambler

  What are the option in terms of applications that help build SQL statements against a MSSQL database? We have some users that need to build sql statements, perferably through drag and dropping or linking up tables etc.., against a MSSQL databse who don't have any experience in this area. Any Ideas?

  Read the article

• Selecting events from SQL Profiler in 2005 for profiling a query

  - by user279521

  Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped. I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window. Thanks

  Read the article

• Insert ADO.Net DataTable into an SQL table

  - by strakastroukas

  The current solution i implemented is awful! I use a for... loop for inserting records from an ADO.NET data-table into an SQL table. I would like to insert at once the data-table into the SQL table, without iterating... Is that possible, or am i asking too much?

  Read the article

• SQL most executed query?

  - by Esabe

  Hi everyone, I have a database in SQL Server 2008, and there are a lot of machines making queries against it. I know there is a SQL Server profiler, but I don't know very well how to use it. Is there any way to know what are the most common queries executed in the database? Through the profiler or not, it doesn't matter. Thank you very much in advance!

  Read the article

• T-SQL Subquery Question

  - by Nick

  Hi, i have two queries. For each tuple of query1 i want to run query2. i dont want to use cursors. i tried several approaches using subqueries. query1: select distinct category, Count(category) as CategoryCount from mytable group by category query2: select top 3 Text, Title, Category from mytable where Category = '1' Category = '1' is a sample. the value should come from query1

  Read the article

• Efficient SQL to count an occurrence in the latest X rows

  - by pulegium

  For example I have: create table a (i int); Assume there are 10k rows. I want to count 0's in the last 20 rows. Something like: select count(*) from (select i from a limit 20) where i = 0; Is that possible to make it more efficient? Like a single SQL statement or something? PS. DB is SQLite3 if that matters at all...

  Read the article

• How do I Make Management Studio Express use proxy settings to connect to online SQL service

  - by TheAgent

  It doesn't seem like SQL Management Studio Express 2005 considers Internet Options proxy settings defined for the LAN when trying to connect to SQL Server 2005. Is there a way to make it use the proxy settings?

  Read the article

• SQL OUTER JOIN with NEWID to generate random data for each row

  - by CL4NCY

  Hi, I want to generate some test data so for each row in a table I want to insert 10 random rows in another, see below: INSERT INTO CarFeatures (carID, featureID) SELECT C.ID, F.ID FROM dbo.Cars AS C OUTER APPLY ( SELECT TOP 10 ID FROM dbo.Features ORDER BY NEWID() ) AS F Only trouble is this returns the same values for each row. How do I order them randomly?

  Read the article

• Resource database in MS SQL Server

  - by Dhivagar

  I need to know what the Resource Database in SQL Server is, and why can't we see this physical file in the SQL Server installed directory?

  Read the article

• Resource database in SQL Server

  - by Dhivagar

  I need to know what the Resource Database in SQL Server is, and why can't we see this physical file in the SQL Server installed directory?

  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

• convert xml file to sql server 2005 table?

  - by subash

  how to convert a xml file in to sql server 2005 table?can any one help me? do we have any query to convert xml file to sql server 2005 table

  Read the article

• Import excel file into sql express 2008

  - by ck

  Hi, I've got some excel files, that were exported from tables in Access, and I want to import them into sql express 2005. I need a script that will convert nvarchar(255) columns to varchar(255) and preserve links, when importing the data into sql express. Thanks

  Read the article

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• Excel VBA SQL Data

  - by user307655

  Hi All, I have a small excel program. I would like to be able to use this program to update a SQL table. What would be the function to say update line 2 in SQL table Test in Database ABC Thanks

  Read the article

< Previous Page | 247 248 249 250 251 252 253 254 255 256 257 258  | Next Page >