Topics
Started by
Posts
Last post
Hi All, I want to convert time into hours as per below format. Please guide. For example – 2:15:00 …
3 replies
I have two steps in each of my SQL Agent jobs - one called if a job step fails, another if it succe…
1 replies
I have scoured high & low for this solution, so in desperation I am posting here. I have a tab…
11 replies
Hi I would like to know if it's possible to pass NULL value to the database. I want to update a col…
5 replies
I have two tables as below create table #table1 (id int,name varchar(10),[sep-12] varchar(10),[oct-…
5 replies
table has 500 million rows. There are 21 million rows that have one ore more fully duplicate ones, …
6 replies
Hi, I have a two table. One Table having Country code and country name details. Another table havin…
3 replies
Hi all, Can someone tell me what are the pros and cons for choosing a character CHAR(3) data type f…
14 replies
I have two tables; CUSTOMER (customer_id NUMBER, customer_name VARCHAR2(100), recently_purchased VA…
3 replies
Hi, I'm restoring to a remote DB for our DR testing. After the restore I need to create come user m…
2 replies
Hi I am trying to think of the best way to calculate a count of 'no' values vs the count of total v…
2 replies
Hi, I am relatively new to SQL programming and have the following issue: I want to insert a number …
3 replies
here is a sample table: Create table #TableA (ID INT , [1] DECIMAL(6,5…
3 replies
Afternoon all, I need to be able to test columns in a table to see if they contain the correct data…
6 replies
I need my column called 'nameInternal' to derive from another column called 'nameFormal'. If the la…
5 replies
Viewing 15 topics - 2,461 through 2,475 (of 10,647 total)
You must be logged in to create new topics.