Viewing 15 topics - 268,051 through 268,065 (of 283,787 total)
Topics
Started by
Posts
Last post
I have to pull off a report of people in the current database by selection criteria for an appeal. …
3 replies
By: Jonathan
hi, i am writing a trigger CREATE TRIGGER Ztrig ON TZ FOR INSERT AS BEGIN INSERT TY VALUES (…
1 replies
By: Jonathan
Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If …
26 replies
By: mngong
Is there a way to DROP all my foreign key constraints and then to RE-CREATE them (as I cannot use t…
7 replies
By: Jonathan
Hi DBA's, I got an issue when website is supporting multiple collations. BA need to include UTF-8 f…
1 replies
We're buying a new server and EMC wants to make me a "deal we can't refuse". We are getting a 32G C…
3 replies
By: Ferguson
Hi, Setting Identity columns for a transaction table is correct? Thanks in advance Jag
4 replies
I have created a trigger using SQL Query Analyser. For modification I open SQL Enterprises Manager …
2 replies
By: kokyan
I am trying to get the time value in a 'hh:mm:ss am/pm' format from the getdate() function, can any…
11 replies
Hi guys, I think it is a bad idea to set identity option for a column in a table(master table/trans…
1 replies
Dear friends, Let say i have 500 sales records with four salespersons, SP1= 100 sales records SP2= …
6 replies
SELECT x,y,z FROM A LEFT JOIN B AS b1 LEFT JOIN B AS b2 WHERE condition ORDER BY A.h this is a ske…
3 replies
According to BOL under DBCC CHECKIDENT: "If the value of new_reseed_value is less than the maximum …
3 replies
I would like to know a script that will generate random no of records based on a specified criteria
1 replies
By: sifan
Select * from information_schema.tables The above query is working fine, But when i describe the sa…
4 replies
Viewing 15 topics - 268,051 through 268,065 (of 283,787 total)