• Register

Recent questions tagged sql-server

0 votes
1 answer 5 views
0 votes
2 answers 5 views
0 votes
1 answer 7 views
Problem: I have an asp.net Gridviewthat has at least 15 lines with a default textbox <strong> ASPX <asp:GridView ID="gv_Others" runat="server" AutoGenerateColumns="false" CssClass="gvothers"> <Columns> <asp:TemplateField > <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> < ... the textbox by Css class) var $arrT = $('#<%=gv_Others.ClientID %>').find('input:text[id$="txtEmp"]');
asked Dec 25, 2020 sasha 5.3k points
0 votes
1 answer 8 views
Problem I am working on some query for my project and the requirement is to show the second value. For sake of example, say I have salary table in Microsoft SQL Server and I need fetch the second maximum salary. I am not too experienced in T-SQL, I used the ... So I sow there is RANK() function in T-SQL, but I do not completely understand how it works. Any suggestions will very appreciated.
asked Dec 17, 2020 alexh 2.2k points
0 votes
1 answer 5 views
Problem I have created a table worker in the past, for simplicity it has the following fields: CREATE TABLE Worker ( Rid int not null, Id nvarchar(100) not null, FirstName nvarchar(100) not null LastName nvarchar(100) not null ) Now I need to convert the Rid (short cut for &ldquo;row id&rdquo;) field to be auto incremental (identity column). How can it be done?
asked Dec 12, 2020 alexh 2.2k points
0 votes
1 answer 6 views
Problem I had not been used SQL a lot at my last position, the company had dedicated SQL Server DBA, but now I have changed the position and I deal with data bases in general and SQL Server in particular a lot. I am a bit confused by a difference between truncate, delete and drop. All the three removes data, but what is the difference?
asked Dec 10, 2020 alexh 2.2k points
0 votes
1 answer 20 views
I wonder to know how I may connect sql server database in asp.net mvc5 . Note that I&rsquo;m not expert in this field.
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 14 views
Can anyone describe me in brief what Is and the difference union and union all in sql server?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 14 views
I&rsquo;m very new to this issue. So I want to know string or binary data would be truncated sql?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 8 views
I&rsquo;m just starting learning SQL. I want to know to to insert null value in SQL. Hope someone can help.
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 8 views
I could not continue scan with nolock due to data movement. I need some help to solve this issue.
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 10 views
I&rsquo;m new to this. Can anyone help me out to this issue by providing me these information?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 13 views
I could not find the database engine startup handle. How can I solve it?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 8 views
I want to know the way of copying table from one database to another in SQL.
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 6 views
I want to find column name in database in SQL. Can anyone help me to solve it?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 10 views
I&rsquo;m getting trouble to solve it. Can anyone help me to do increment value by 1 in SQL?
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 13 views
I&rsquo;m new in sql server. Can anyone help me to solve this problem?
asked Dec 7, 2020 TeamScript 9.5k points
0 votes
1 answer 11 views
Describe me Microsoft ole db provider for sql server error &lsquo;80004005&rsquo;
asked Dec 7, 2020 TeamScript 9.5k points
0 votes
1 answer 3 views
I&rsquo;m getting error converting data type varchar to numeric sql, how can I solve it?
asked Dec 7, 2020 TeamScript 9.5k points
0 votes
1 answer 9 views
I can not insert the value null into column. Can anyone help me here to solve?
asked Dec 7, 2020 TeamScript 9.5k points