Topics
Started by
Posts
Last post
Is there away to use a Case statement in a where clause based off a value of a local variable? Or w…
10 replies
I am trying to check for errors in a DB before i use the data for my developing, what is the best w…
15 replies
I'm trying to get this code to populate a Gridview in ASP.net. It will be used to populate a up-to-…
2 replies
Hi, I'd like to have the ids or another column of rows I just updated. Is it possible? These column…
4 replies
I know there has to be a way to dynamically tell a select statement the top value without having to…
7 replies
Greetings folks. I have a table I need to modify to allow duplicates of the primary key, so I am a…
6 replies
Hi all, I have taken more than one database backups and i have an idea that we can verify single…
1 replies
I'm trying to set IDENTITY_INSERT OFF in a stored procedure and it doesn't work! Here's the sample …
5 replies
tblemp (empid,jobid,position) Here the acceptable values for field position is (4,6,7) I wud like t…
5 replies
I'm looking for an efficient solution to returning a field in a row, where another field in the row…
6 replies
I am having problems getting results from a stored procedure into a textfile using bcp. The last s…
10 replies
Guys hi, i have a logical problem and i need your help in solving it.. Any suggestions are welcome…
10 replies
I've got a query/stored procedure that has to run under SQL Agent every night. The problem is, I'm …
2 replies
I have an update trigger that inserts into a second table if a date field is populated. When I popu…
14 replies
Greetings folks. I have a simple query whereby I am trying to calculate a percentage as follows. …
8 replies
Viewing 15 topics - 3,781 through 3,795 (of 17,082 total)
You must be logged in to create new topics.