Viewing 10 posts - 1 through 10 (of 10 total)
Hi!
Below is the query that will give you the primary key constraint names and the columns used in them for all the user created tables in your database.
SELECT OBJ.NAME, COLS.CONSTRAINT_NAME,COLS.COLUMN_NAME,COLS.ORDINAL_POSITION
FROM...
November 8, 2005 at 2:03 am
Hi!
If you have all numeric values only in that column of your table it can be inserted without any special handeling, I have given an example pls try this...
Probably this...
June 24, 2004 at 2:57 am
Hi!
try this script, probably solve your purpose....
select table_name, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, isnull( convert(varchar, CHARACTER_MAXIMUM_LENGTH), '-NA-') as CHARACTER_MAXIMUM_LENGTH
from information_schema.columns
order by table_name
June 8, 2004 at 12:50 am
Hi wz700!
I want to give my user an option to upload a picture and store it in SQL 7.0 database, how can I acheive that, I tried to get the...
June 2, 2004 at 10:21 pm
There can be two solutions for this problem:
1) Specify the default values for the columns in the table structure itself and specify the column list in insert statement.
2) Add the...
June 2, 2004 at 6:00 am
Hi!
There can be two ways of doing it:
1) truncate table on the production server and then insert all the records from STAGING server to PROD server.
2) the second option that you...
May 18, 2004 at 12:25 am
Hi!
tried to simulate your problem with temporary tables and following is the code for that, probably it will help you. You need to use charindex for checking the employeeID's existance...
May 15, 2004 at 4:22 am
sp_changeobjectowner
will work if the person wants to change the owner of the object but it seems that in this case its required to keep the object with original owner...
May 12, 2004 at 5:09 am
Hi!
Probably this code will help you.....
delete RoleModule
where roleModule_ID not in (select max(roleModule_ID) from RoleModule
group by Role_ID
having count(*) > 1 )
and Role_ID in (select Role_ID from RoleModule b
group by...
May 12, 2004 at 2:14 am
Hi!
You can write the delete statement based on need i.e. where the difference of invoice date and current date is greater than equal to 48 months. This delete statement can...
May 10, 2004 at 10:52 pm
Viewing 10 posts - 1 through 10 (of 10 total)