Topics
Started by
Posts
Last post
I need to get data from a diff. database and I need to use dynamically the FROM clause like: @datab…
11 replies
I have the following query: SELECT TOP 1 site_id FROM tblSites WHERE displayLink = 1 ORDER BY NEWID…
4 replies
I am looking for a way to get a utc date for any date and to obtain the local date for any utc date…
16 replies
what is wrong wid this procedure, when i execute this via java it execute fine once and then second…
4 replies
I was wondering, if i got fields in table A wanted to do some transformation and copy it to table B…
2 replies
I have been successful in creating a sql that will allow me to update a single record however I nee…
7 replies
Is there any function in SQL Server like RowNum in Oracle https://dbfriend.blogspot.com/
12 replies
All I'm trying to do is fill in a cursor with dynamic SQL because of different tablenames for data …
3 replies
Please pardon the freshman question, but I am wondering about using an optional parameter in the WH…
13 replies
Hi, I have a stored proc that returns rows from my db. I want one of the columns to be returned as …
1 replies
How can we copy a database from one server to a different sever which is having replication.Can any…
6 replies
Are user defined function precompiled and stored in cache like stored procedures?
2 replies
Hello I have a question regarding the use of bit flags. I have a dataset that looks like a bit fla…
16 replies
I am getting an occasional deadlock (SQL 7) with this message: Server: Msg 1205, Level 13, State 3,…
1 replies
Is it possible to alter an existing FK constraint to allow cascades on update or delete? If so, wha…
1 replies
Viewing 15 topics - 14,296 through 14,310 (of 17,082 total)
You must be logged in to create new topics.