Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: victorashi
  • Content: Threads
  • Order by date
  1. victorashi

    Is Microsoft heading on open source ?

    I have seen some videos from the Microsoft guys , who teach us how to change certain things in the Vista OS through Microsoft Visual Studio 2005 ??!! .... they say : it`s as simple as that .....
  2. victorashi

    dinamic sql variable problem

    i have a problem with dinamic sql, pls help i want to dinamycally update a table from my database this is the code i wrote so far: declare @temp char set @temp = Cast(@nr_crt as char) declare @Result varchar (8000) select column_name into #temp from information_schema.columns where...
  3. victorashi

    dinamic sql problem

    i have a problem with dinamic sql, pls help i want to dinamycally update a table from my database this is the code i wrote so far: declare @temp char set @temp = Cast(@nr_crt as char) declare @Result varchar (8000) select column_name into #temp from information_schema.columns where...
  4. victorashi

    TEXT-BOX PROBLEM

    Hallo , i have a small problem , i made a form page ,i made a drop down list wich has the AUTO-POST-BACK property, and i made a text-box wich has to be cleared at each POST-BACK , but i don`t know exactly how.Please help
  5. victorashi

    dinamic table update, pls help

    i need to update a table that i select dinamicaly at update i need to acces the table's columns and asign eash a variable. here i'm stuck because i don't know how many columns the tables has, their names, and the variables i need to insert in them -- if @a is the table that i imput exec...
  6. victorashi

    UPDATE tables dinamicaly

    Can someone help me with an algoritm for updating a table imputed dinamicaly . what steps do i have to take to find out the the tables columns , and update .
  7. victorashi

    dinamic sql problem

    i want to make a query in VS2005 wich allows me to dinamicaly imput a table and a column , something like : select * from @a where @b='something' can someone pls help me with the sintax? thank you
  8. victorashi

    Query problem

    i want to make a query wich allows me to dinamicaly imput a table and a column , something like : select @a from @b :) .... maybe
  9. victorashi

    problem with MSSQL2000 or VS2005 ?

    is there a way that the MSSQL2000 doesn`t show a column if it`s value in it is NULL, or a way in VS2005, for making a website, that doesn`t let me to see the column if it is NULL. it`s unproffesional to see on a website with columns with NULL values. Please help . I tried the hole afternoon...
  10. victorashi

    datefiff function - concern

    today i wanted to calculate the difference in years from the date of birth untill today ( how old i am ) so i used the datediff function : select datediff (year, 1982-01-01, getdate()) (no column name) --------------------- 101 is that possible that i am 101 years old, or i didn`t use the...
  11. victorashi

    small problem

    hello , i have here a procedure wich gives me all data from one employee, but the result table gives me more than 4 times the ID column , how should i write it so that it will bring me only one time this column ? CREATE PROCEDURE EmployeeDetails @nr int AS BEGIN SELECT * FROM table1 INNER JOIN...
  12. victorashi

    problem with dbo.LEVENSHTEIN function

    does anybody know how to use in a MSSQLSRV2000 db the LEVENSHTEIN function .... i heard it`s great ! it returns a number that is the distance between 2 strings , for example between : radio and radoi the function gives me 2 --http://www.merriampark.com/ld.htm create function LEVENSHTEIN...
  13. victorashi

    indexig the right way

    hello , thinking of normalising my db i wanted to index the name column so that there is no duplicate possible . this is the index that i made : ALTER TABLE [dbo].[table] WITH NOCHECK ADD CONSTRAINT [PK_table] PRIMARY KEY CLUSTERED ( [usr_id] ) ON [PRIMARY]...

Part and Inventory Search

Back
Top