Topics
Started by
Posts
Last post
I have stored alter commands in table for reindexing. How should I execute them one by one using cu…
2 replies
while i am writing query, select * from table name where column like '%N%' escape'\' in oracle its …
2 replies
I have 2 tables. One table contains all parent accounts, top level of hierarchy. Second table has…
20 replies
Hi Guys, I need to create a stored proc that takes an xml input parameter, which must be used in th…
1 replies
create table QA_Test (ID int,BID varchar(5),NumBldgs int) Insert into QA_Test Select 123,'001',4 Un…
10 replies
I want a merge procedure for every table in a particular schema, and I have a script to create them…
2 replies
Hi, how can I get effectively max(version) to identify any PersonID with multiple VersionID? Person…
3 replies
Hey all, I have a stored proc. It does what i want it to - but it seems over complex and a little …
5 replies
hi All, I am learning sql server optimization, declare @p1 int set @p1 = 1 SELECT ProductID, SalesO…
4 replies
Hi, I have stored procedure having one input parameter . ALTER PROCEDURE [dbo].[CMT_RoomDelete] @…
1 replies
I am trying to write a SQL statement to pad numbers with 0's. The number string has a . delimiter …
5 replies
Hi, I have a little problem where my Database stores Dates in 'yy/mm/dd' format. I want to retrieve…
13 replies
Hi Guys, Hope you're all doing well! I have a problem and will provide an abstraction (extremely si…
6 replies
A column that accepts null values but has a unique constraint can only have a single row with a nul…
29 replies
I am trying to write a stored procedure that cursors through all databases and cursors through each…
3 replies
Viewing 15 topics - 5,371 through 5,385 (of 10,635 total)
You must be logged in to create new topics.