Topics
Started by
Posts
Last post
Hi, I have a sql query ########################### selectcount(tot_files) (title 'Number of files…
8 replies
I am trying to decide whether to use temp table or table variable in stored procedure. Based requir…
12 replies
Hi, I wanted to assign the column names for a particular view of which the column names are in a d…
11 replies
Hi I want to dump the result of a select into a email to send as is. Query is: SELECT DET.orderIt…
4 replies
Hi All, I would like to get some help regarding optimizing the below query. Is there anything very …
8 replies
i want to know the exact diference between table scan and index scan.i read about 6 to 7 articles b…
22 replies
Hi there, I have a table called TradeView: CREATE TABLE [dbo].[tradeView]( [tradeId] [int] NOT NUL…
2 replies
what is the major difference between EXEC and sp_executesql?
15 replies
Hello everyone, I have a SP called p_ins_support_call, which, inside it, has an exec statement to a…
1 replies
can anyone explain me the functionality of "select x from tablename"?
11 replies
Ok so I am giving myself a huge pat on the shoulder because i've had no formal training on SQL nor …
25 replies
i want to read '_1_ ' or '_2_' from the "file" column in the table as shown #######################…
6 replies
Hii, Please check the below, I pasted my requirement in the form of an image. 'ID_Current' is just …
9 replies
I have SQL 2008 server I have tables in the database that have a unique identifier called "Date_Sta…
5 replies
http://www.picscrazy.com/view/Image6V3 I wrote this sql to obtain the above data select (STREET_ADD…
11 replies
Viewing 15 topics - 8,926 through 8,940 (of 10,647 total)
You must be logged in to create new topics.