I have a table with three fileds userID, userName, userPassword.I have 100 rows in that table, now I want to update the userPassword column with new random generated string password.
View 1 Replies
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).
My constraints are:
That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:
My Table (T1):
Order Type Combined
Place
0090 0001 YYXX 1YY
0091 1001 YYXX YYY
0092 1002 XXXX 2XX
Table 2 (T2):
Order Value
00900001YY XX
00911001YY XX
00921002XX XX
The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.
If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order
If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined
Here's what I have:
[Code]....
I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.
trying to write a stored procedure to select any 5 random columns from a selected row,this is the query i ve written so far
[Code]....
[Code]....
I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
View 7 RepliesI've build a random string generator but I'm having a problem whereby if I call the function multiple times say in a Page_Load method, the function returns the same string twice.here's the code
Public Class CustomStrings
''' <summary>'
''' Generates a Random String'
''' </summary>'
''' <param name="n">number of characters the method should generate</param>'
''' <param name="UseSpecial">should the method include special characters? IE: # ,$, !, etc.</param>'
''' <param name="SpecialOnly">should the method include only the special characters and excludes alpha numeric</param>'
''' <returns>a random string n characters long</returns>'
Public Function GenerateRandom(ByVal n As Integer, Optional ByVal UseSpecial As Boolean = True, Optional ByVal SpecialOnly As Boolean = False) As String.............
I have a function that checks for a username and if it finds the username it will allow the user to update the user, there are 3 main columns: Name,Age,isFemale. I have the enduser supply the information and then I try to update the record but I get a sql error for "not a valid" column.console app:
[Code]....
I pass the spIsFemale by using an enum, here is the Person Class with function.
[Code]....
I get an error that column isFemale is not valid. The isFemale column is a bit type. If it's a 1, it's a female, if 0 male. this is more of a test area and I'm trying to update records or create new one's if the name does not exist.II am new to C # and I am just trying to learn new ideas and methods within C sharp.
While running a project in asp.net in local and live I am getting unwanted characters in th URL.. Given below the sample of the URL
Can I know whats the reason for thisÂ
localhost:3482/Emp/(S(j3llqowtu2ow0lwqvqk0g12t))/Details.aspx
localhost:3482/Emp/(S(j3llqowtu2ow0lwqvqk0g12t))/Details.aspx
I work on an ASP.Net 4 project that uses forms authentication.The majority of our users login without any trouble, however, something strange is happening with a small number of users and I think we've narrowed it done to the User Agent string.Most users when logged in will see a fairly standard looking URL, e.g. http://mywebsite.co.uk/Web/Pages/Default.aspx, the "web" folder is the root of the site.
Some users when logged in are producing URLs such as
http://mywebsite.co.uk/Web/(F(wjNTtmLFYK3PyAUD09idKtZcyRPlf3Mlc6_rJMMwd1r0EvxeL1ROKYoTbd6KQWJNJHebiCs8qN4laZAItib4ZmcfMy75KhGlBrMCjY-47phUNQiJ_Q0-E3ntvf8tscjxfD5A0lVXau-UxDvN6gTgW1TkwhA1))/Pages/Default.aspx. I can only assume the garbage characters are some sort of session identifier string.
These obscure, long URLs work fine for some pages, but a lot of pages (including our home page) use the LoadControl(path) method to dynamic load content, or have hyperlinks to static files on the server (e.g. PDFs). In these scenarios the users with the long URLs crash the application as obviously the files it's looking for don't exist because the paths have been obscured with garbage characters.
We can reproduce this error by using masking the User Agent in Firefox to emulate the Googlebot, and sometimes the iPhone. Is there a particular reason why some user agents will produce this behaviour? Can anyone shed any light at all on why the random string is being injected into every URL on our sites?
/Web/(F(wjNTtmLFYK3PyAUD09idKtZcyRPlf3Mlc6_rJMMwd1r0EvxeL1ROKYoTbd6KQWJNJHebiCs8qN4laZAItib4ZmcfMy75KhGlBrMCjY-47phUNQiJ_Q0-E3ntvf8tscjxfD5A0lVXau-UxDvN6gTgW1TkwhA1))/FDCrew/Airlines/DHL/HomeFooterPanel.ascx
I have a table with 2905 rows. I want to update one column with 2905 values. The values are all different, and they are just stacked one to a line with a line break. One on top of the other like so:
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
http://www.cargoarrainger.com/page6.html
http://www.iceretail.com/resources/link-7953
NULL
NULL
How would I write this query? Do they have to all be separated by commas? What about NULLS?
update tblAdvanceLinkBanned set ReciprocalURL=?
How can I generate a 7-digit random number and special character string in a textbox on a button click event, in VB.Net?
View 2 RepliesI'm trying to use a function in my code behind to let me select a different column each time by calling the function with a different parameter.
However, I keep being told 'invalid column name', even though in the error page the column name appears perfectly valid.
Private Function getData(ByVal s As String) As String
I have a table1 with first column having: usjim, uskim, uspeter, john ....
I need to insert this column into table2 excluding us if contains any ( extract substring basically)
I have tried doing this but doesn't work
[code]....
tbl_salary
salary salperyr hike20 hike20yr
10000.0000 NULL 12000.00 144000.00
12000.0000 NULL 14400.00 172800.00
14000.0000 NULL 16800.00 201600.00
15000.0000 NULL 18000.00 216000.00
18000.0000 NULL 21600.00 259200.00
20000.0000 NULL 24000.00 288000.00
22000.0000 NULL 26400.00 316800.00
in above table salaryper yr (salperyr) has to be modified after caliculation my null values has to be removed and place(salary*12)in one shot.
Inside many of my records, I have some HTML - - inside the HTML, I have a particular tag:
<code>
I'd like to change only that code to:
<pre>
But I don't want to change any other text inside any records...
What sql can I use to do something like this?
Using Stored Procedure (SQL) Am looking to generate a 10 digit alphanumeric number. How do i proceed.
Example:
132AXD1LKM
AD157LKJ1A
i need to show for every refresh of page five categories, every time different how can i do? in SQL do not exist select RND(field)...
View 5 Repliesi have a select statement which returns a column value.
id like to display the lowest column value there is, but if there are multiple rows with the same (and lowest) value id like it to be random which one of the rows is selected.. how would i do this? my select statement is currently:
SELECT TOP (1) url, ABS(r1 - @r1) + ABS(r2 - @r2) AS difference
FROM type
ORDER BY difference
this picks the one lowest result for me, but if there are multiple duplicate lowest results id like to select them, and show one at random..?
I have an ID field where I need to insert unique ID's
the ID should be like -
S- (YY)(MM)9999. where, (YY) is year, (MM) is month and 9999(is a four digit random number)
for example - S-11030001
I am working on a project for a market research company that needs to select and have it displayed to my gridview. I need a select statement that will randomly put on my gridview the following:
Recruitment Goal 21 people and out of those people 10 people have to be male, 11 people female, 9 of them white, 9 of them black, 2 of them hispanic. Is there a way I could do that? I was thinking of doing a stored procedure and doing something like
Select TOP 10 * from Canidates where sex = 'Male' order by newid() Into #tmp
Select TOP 11 * from Canidates where sex = 'Female' order by newid() Into #tmp
Etc... and then just selecting from the Temp Table.
I want to return random records in term of time whithout NEWID
View 5 Repliesi'm using Random function to generate random numbers and store them into arrayTell me how to do This is how an array is declared
[Code]...
i have a query that select random records in access database in terms of time : "SELECT TOP 10 * FROM Tbl ORDER BY Rnd(-10000000*TimeValue(Now())*[ID])" now i wish to convert this query for using in sql server 2005 such that return random records in term of time
View 5 RepliesI have a list box that allows for multiple selections (holding down the control key) the selection quantity is basically unlimited, but realistically should never be more than 50 to 100 items from the listing of about 3000 items.
I need to collect the list of selected items from the drop down list and retrieve each of their full records from the item master and populate a gridview.
I have a list box that allows for multiple selections (holding down the control key) the selection quantity is basically unlimited, but realistically should never be more than 50 to 100 items from the listing of about 3000 items.
I could really use some building the SQL statement to select the choosen record data. I think I have the selection list worked out by populating an array but I am not clear on how to build the SQL query.
