Topics
Started by
Posts
Last post
Hi all I have to form a query, need some help on that,Here is the case.... From a table that has an…
12 replies
Hi, I want to rename the table without using a stored procedure. Possible solution: Create copy of …
5 replies
i have a table having double quotes (" ") in all 10 columns. (sample values like "10101" ,"1291919…
4 replies
I have a particular table that has several indexes. How can I write (a) T-sql statement(s) that wi…
4 replies
Hi everyone, I have a strange requirement in SSIS, that I wanted to share with you all, and need so…
10 replies
I want to delete a row, which is dependent on some other tables(more than 32). How to delete a row …
1 replies
Hello All, I have read many times that cursors are bad and try to avoid using them. However, I have…
6 replies
Hi all, I have a problem to write this query, anyone can give me any ideas ? 🙂 There are two tables…
7 replies
Hi, i would like to compare a value in the Where clause if it is SELECT * FROM Tbl1 WHERE TYPE = CA…
12 replies
Hi What is Column_Type. Why is it used for? Thanks S John
5 replies
In the code below, the function continues to return the columns from the original view after the vi…
7 replies
Hi.. We can fetch the same result by using !<(Not Less than) or >=(Greater than or equ…
4 replies
I am trying Encrypt some numbers using SS 2005 Here is my Table Structure CREATE TABLE [dbo].[Acco…
3 replies
I am using the CONVERT function to format a date with the century. My code is like this: CONVERT(V…
2 replies
Hi, I have a problem with query which is returning more than 45000 records. I have applied covering…
11 replies
Viewing 15 topics - 3,301 through 3,315 (of 12,230 total)
You must be logged in to create new topics.