Topics
Started by
Posts
Last post
Hi All, I've created a merge statement which Deletes, Inserts and Updates a table, this is working …
2 replies
I created a user (User1) and Schema (shema1). Made schema1 as defult user schema. Now i cannot acce…
9 replies
Hi, I am currently using a SSIS WMI task to watch a folder, which runs in a for-each loop, until a…
3 replies
Is it possible to create sqlserver objects with out schema like Test not like dbo.Test or Function …
5 replies
Hi, Hopefully someone can help. I need the difference between LastOdo (Odometer reading) for curren…
6 replies
I am sure there is a very simple explanation to this! We have found that in some environments, SQL …
3 replies
Hiya, I'm on a site where SQL Developers have a functions database which only contains functions. T…
6 replies
I would like to detect any changes done on update to a text column 'comments' through a trigger. Th…
4 replies
Hi, i need a query to find out all orphan over a hierarchical table with the code above i can get a…
11 replies
I have a table having three column Name Value1 Value2 Value3 A 1 2 …
31 replies
I'm working in an environment where some very wide tables are present (400+ columns). Whilst long t…
5 replies
declare @colnames as varchar(max) set @colnames = ( SELECT STUFF(( SELECT ', ' + name FROM sys.co…
6 replies
I have a Table which have two columns 1. UserName 2.Password. Now I need to create stored procedure…
5 replies
I am working for a small company and have been placed in the roll of a DBA. I am a systems engineer…
3 replies
Hello all, After searching for possible solutions, I haven't found anything that provides me with w…
13 replies
Viewing 15 topics - 2,926 through 2,940 (of 3,091 total)
You must be logged in to create new topics.