Topics
Started by
Posts
Last post
When using sp_executesql, is it possible to "evaluate" a function? In other words, is there anyway …
4 replies
The following error (referring a non-existent column) is not catched: begin try insert into exclu…
2 replies
hi im writing login stored procedures. im having some difficulty with my update user stored procedu…
9 replies
Dear Friends, In my application, I have the below requirement. When the user specifies a keyword, I…
6 replies
I have a query I am trying to write and this is my first attempt at something like this. I need to …
24 replies
Hi, I want to send the results of a query as the message of an SMTP mail i.e. @message = S…
9 replies
Hi, I am using CTE in a Procedure. While executing the Procedure the CTE should returns null value…
5 replies
I have to columns that performs sums. However I want the specific data type to be decimal with two…
3 replies
I need to write some SQL to determine when a record in a table (UsedVehicles) was last updated. I …
8 replies
How can I do this using t-sql? I have two tables, t1 and t2, t1: c1 c2 c3 …
2 replies
Hi, I have a field that contains the number of days between a dated field and today (utilizing date…
5 replies
The field data type is INT. I want to display it always as "01","02","03" format. What is the best …
11 replies
I have 2 tables . Dept and Names . Now I need to grant access to 1 person in Names table on 1 depar…
1 replies
I am trying to remove several lookups in an SSIS package by moving these into 1 stored proc to redu…
3 replies
I have to write a stored procedure that does a numeber of things but the first issue I cant figure …
2 replies
Viewing 15 topics - 8,281 through 8,295 (of 12,234 total)
You must be logged in to create new topics.