Topics
Started by
Posts
Last post
I have a table as follows: CREATE TABLE [dbo].[ReorderS]([Item_Code] [nvarchar](50) NULL, [Quantity…
12 replies
Dear All, I need some help making a triggers/function. this is the situation: i have 4 tables: - a…
4 replies
Hi, I'm new to sql server and I'm looking for a command to fill up the transaction log of the adven…
7 replies
hi I have a table like this one create table #temp ( a int, b int, c int, d int ) insert into #tem…
7 replies
I am looking at; Check DB Integrity Task, Rebuild Index Task, Back Up Database Task, Maintenance Cl…
1 replies
Hi, I want to make a trigger that will forbid update on a specific column. The table is: DefSubje…
1 replies
I'd like to join on two tables, this should be easy right, but I'm getting multiple results. What I…
2 replies
Dear All, i have two tables: - articles - customers i want to write a trigger: when inserting a new…
5 replies
How do i change 140850 into HHMMSS 14:08:50? 🙂 Just playing around with this, my question is very o…
1 replies
col1 col2 col3 col4 row1 aaa 6 6( from col3 and row 1 = 6) row2 bbb 7 3(from col4 and fr…
1 replies
I have a login screen and I want to the username and password fields to be case sensitive. If a vi…
1 replies
Hello, I have a question, on insertion of data from Client 1 I received a Foreign Key Violation er…
1 replies
I'm a SQL n00b and our DBA's have no clue... lovely isn't it 😉 Okay so here is the issue. When cre…
8 replies
We've migrated all our applications from SQL 2000 to 2005. One of my ASP apps is now getting this e…
3 replies
Hi all. I am VERY new to SQL and the little I think I know is self taught. I have a task to search …
6 replies
Viewing 15 topics - 1,591 through 1,605 (of 2,735 total)
You must be logged in to create new topics.