Topics
Started by
Posts
Last post
Some previous DB guy added the new UD Datype using sp_addtype, he used that in one procedures , Bu …
2 replies
Hi Gurus, I've a text field. I need to just retrieve complete data of that field. When I use select…
2 replies
How do you find the second largest value in a column of table without using any sub queries??:excla…
4 replies
How trigger works on update statement affecting more than one row?
4 replies
Hi all, I have a table full of server names some of which include "." How can I strip out everythin…
6 replies
Hi, I am new with ComputedColumns. There are 2 errors that I get when creating computed colums (Pe…
1 replies
How do i enable SPARSE on all the valid columns in an existing table ?
1 replies
Can you determine the DB an SP was called from? i.e. given this code: USE DB1; GO EXEC DB2.dbo.usp_…
11 replies
Dear experts, I have the following query which generates for me row with identical entries :- SELE…
13 replies
I know: Linked server name, data source. How to know table name and retrieve data? Thanks
7 replies
I have a TSQL Query which selects data from a decimal(25,6) field. The result has the following for…
4 replies
Hi, When i ran the store procedure in sql 2008. its getting the following error Cannot resolve t…
2 replies
I have first name and last name in my table. I have to concatenate these two columns and update i…
10 replies
I'm looking ove rthis proc and i noticed theire using dynamic sql however instread of using ticks t…
1 replies
Hi, my results looks in this format Sorce YearMonth CountEntery A 2003-04 43 B …
23 replies
Viewing 15 topics - 9,496 through 9,510 (of 10,635 total)
You must be logged in to create new topics.