Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
Recent questions tagged Sql-servertsql
0
votes
Q: SQL syntax for Same Date Last Year
I am using SQL Server 2014 and I have the following T-SQL query which pulls data from a View Table: SELECT * from MyView ... '2014-07-01' AND CreatedOn = '2014-07-01' AND CreatedOn...
asked
Apr 13, 2022
in
Education
by
JackTerrance
sql-servertsql
0
votes
Q: Filter based on decrypted value using DecryptByKey
I have the following simplified query which should filter the decrypted column values SELECT ResourceId, ClientId, ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Apr 5, 2022
in
Education
by
JackTerrance
sql-servertsql
0
votes
Q: Is there a way to loop through a table variable in TSQL without using a cursor?
Let's say I have the following simple table variable: declare @databases table ( DatabaseID int, Name ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Mar 25, 2022
in
Education
by
JackTerrance
sql-servertsql
To see more, click for the
full list of questions
or
popular tags
.
...
