Topics
Started by
Posts
Last post
Hi, is there any script that can check row by row values for comparing the data is it in order or n…
6 replies
I'm using a derived table (see the following code) to retrieve a unique smalldatetime value from a …
3 replies
Hello everyone, DECLARE @MyTable TABLE ( RowID bigint, RowKey int, Locale varchar(10), Descr n…
31 replies
Hi friends, I am having one table which is having startdate and enddate for one work. Now enddate m…
8 replies
Hi Guys.. Does anyone see a problem with the following update query? The last time i ran it, i kill…
13 replies
Hi, I'm writing a series of scripts that will make a copy of my database. So far I have all of the …
2 replies
I have the following dynamic sql that adds a second to a timestamp and then adds quotes with the qu…
3 replies
Hi I have a requirement such that I should insert a new record if there is no entry for a particu…
5 replies
How can i change to other database using command. In stored procedure I am unable to write "USE Dat…
2 replies
I'm new here, so i this is in the wrong forum I apologize. Question: Let's say I have two columns. …
2 replies
I'll try to explain this in the simplest why I can, what I am really after is why the IF/ELSE code …
10 replies
Hi All, My requirement is like, I have one table in that table I want to change col1's values and …
19 replies
I am running the following SQL Query: SELECT p.* FROM OPENROWSET ('SQLOLEDB', 'Truste…
4 replies
Hi friends, I have a table with two columns FromLocation and ToLocation ,these columns may contain …
6 replies
Hi everyone. Just wondering where is the best place to go to get started writing views in SQL 05. I…
3 replies
Viewing 15 topics - 8,866 through 8,880 (of 12,230 total)
You must be logged in to create new topics.