Topics
Started by
Posts
Last post
Hi everybody, i work with sql server 2005 and i must to create a batch with some t sql commands ins…
2 replies
Can anyone advice how to join results from two (or more) SELECTs with aggregate function? Select 1 …
2 replies
Hi All, I have a dropdown list which is a multi selection field, when multiple value is selected it…
4 replies
I'm executing several discrete queries in a single batch against SQL Server. For example: update ta…
5 replies
So I know how to do a begin and commit with rollback on one tran or a try catch block. This is a l…
3 replies
Hello ALL, If in my database SQL 2005 as value NULL where is an empty cell, and I wish to display i…
10 replies
Hi all, I am trying to create index views but i get error as follow: Remote access is not allowed f…
5 replies
I thought it might be interesting to create a consolidated Tips and Tricks thread. These should be…
1 replies
I have been asked to develop a report that returns similar output as the attached excel file. I am …
2 replies
Sorry if this is the most basic of questions. I've searched high & low but I cannot find an an…
2 replies
what are the Common Mistakes in T-SQL ? For example: @@Error gives correct value in next line onl…
73 replies
From reading BOL on the FROM statement it says that it should be linked_server.catalog.schema.objec…
5 replies
Hello ALL Experts, I have created three VIEWs and I wish to merge them into one View. Would someone…
17 replies
hi friends. i have a distinct problem with view. -- that is my view: ALTER VIEW [dbo].[b]vwPurchas…
17 replies
Hi i am trying to do update from if clause if (EXISTS(select name from tablename where name = table…
5 replies
Viewing 15 topics - 7,771 through 7,785 (of 12,230 total)
You must be logged in to create new topics.