Topics
Started by
Posts
Last post
I've got a list of strings I need to look up. They are a little variable, and the best way I've fo…
4 replies
Hello, I am new to SQL scripting, and need advice on creating a script that interrogates a column w…
5 replies
hi Rename all the column name from bank_account to current_account IN bank database in all the obje…
2 replies
I need to remove triplets from a table. The table can contain triplets but not always. A trip…
3 replies
Hi all, I've never come across this problem before. I have a 5.5 million row table in …
10 replies
Dear all, I heard that using derived table is quite faster than using correlate subquery. I tr…
7 replies
Hi, I need to create tables with a fixed number of rows, lets say 50. When a new row of data is add…
18 replies
SET NOCOUNT ON DECLARE @student TABLE ( Class VARCHAR(10), [Group] VARCHAR(10), Score&nb…
6 replies
Does anybody know of any logic or algorithm that will determine the gender of a person based on the…
25 replies
SELECT CONVERT(NUMERIC(28, 2), 2.5608655E7) --works okay SELECT CONVERT(NUMERIC(28, 2), '2.5608655E…
2 replies
Hi, I have an SP which does one recompile every time it runs due to [SET DATEFORMAT DMY] comm…
3 replies
My problem is that i have a string which is {PN}?Hello{PN}' and when i want to remove the {PN} from…
4 replies
Hi all Experts I just want to know , is there any technique to encrypt the stored procedure coding…
5 replies
SET NOCOUNT ON DECLARE @MyTable TABLE ( ItemName VARCHAR(6), ItemNo INT, ItemValue&…
11 replies
I'm trying to manipulate a field (with thousands of rows) that contains telephone numbers so that I…
9 replies
Viewing 15 topics - 5,236 through 5,250 (of 17,082 total)
You must be logged in to create new topics.