Topics
Started by
Posts
Last post
Dear Sir, I never use '>' operator in case of text field with where cluse now i see one example …
2 replies
How do i search a string that contains 6 or seven characters but no spaces this is to identify inco…
16 replies
Hi, I am using an insert statement in my stored proc with SCOPE_IDENTITY(). insert into tableA (Co…
3 replies
Hi, I work with sql server 2005 and i have a simple table with some columns declare @tbl table (id …
8 replies
Hi Guys... I am using SET ROWCOUNT because the value comes from a parameter into my procedure. SET …
3 replies
Suppose I have two tables. Students and StudentTopTwoChoices. Students has a primary key, StudentID…
8 replies
Does SQL have something (like Pick) that will search a string, and then break the string apart by t…
5 replies
Hi I am new to SQL server and I am working on a project that needs to insert id's say UID into a us…
14 replies
I recently wrote the following generator script because I did not know of a simplier way to find th…
2 replies
In a Stored Proc, can you use a CASE statement to create your SQL ... (the below try errors out on …
17 replies
As part of a fairly involved project, I need to create a temporary table that has columns named aft…
4 replies
I have a code similiar to this and I want to populate a zero instead of pulling back nothing. SELEC…
3 replies
This is my original table: declare @originalTable table (Username varchar(30), Date datetime, Code…
9 replies
How to avoid the user defined functions in Where Clause in sql server 2005? Im getting performance …
16 replies
Hi, I have a part of my query that works fine for the current month. Thing I can'figure out is how …
5 replies
Viewing 15 topics - 1,066 through 1,080 (of 12,234 total)
You must be logged in to create new topics.