Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
Recent questions tagged sql-server
0
votes
Q: How to get first character of a string in SQL?
I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there any ... in SQL to do this? Select the correct answer from above options...
asked
Feb 8, 2022
in
Education
by
JackTerrance
sql
sql-server
sql-server-2005
0
votes
Q: How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
I didn't see any similar questions asked on this topic, and I had to research this for something I'm working ... had the same question. Select the correct answer from above options...
asked
Feb 8, 2022
in
Education
by
JackTerrance
sql
sql-server
line-breaks
0
votes
Q: SQL User Defined Function Within Select
I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of ... WHERE ... Select the correct answer from above options...
asked
Feb 5, 2022
in
Education
by
JackTerrance
sql
sql-server
select
user-defined-functions
0
votes
Q: How to get first character of a string in SQL?
I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there any ... in SQL to do this? Select the correct answer from above options...
asked
Feb 5, 2022
in
Education
by
JackTerrance
sql
sql-server
sql-server-2005
0
votes
Q: How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
I didn't see any similar questions asked on this topic, and I had to research this for something I'm working ... had the same question. Select the correct answer from above options...
asked
Feb 5, 2022
in
Education
by
JackTerrance
sql
sql-server
line-breaks
0
votes
Q: Count(*) vs Count(1) - SQL Server
Just wondering if any of you guys use Count(1) over Count(*) and if there is a noticeable difference in ... SQL Server 2005.) Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
performance
0
votes
Q: How can I list all foreign keys referencing a given table in SQL Server?
I need to remove a highly referenced table in a SQL Server database. How can I get a list of all the ... of the management studio.) Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
0
votes
Q: Should I use != or <> for not equal in T-SQL?
I have seen SQL that uses both != and for not equal. What is the preferred syntax and why? I like !=, ... reminds me of Visual Basic. Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
0
votes
Q: Difference between JOIN and INNER JOIN
Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = ... different SQL implementations? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
join
inner-join
0
votes
Q: How to return only the Date from a SQL Server DateTime datatype
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00: ... How can I get that? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
date
datetime
Page:
« prev
1
2
3
...