sql-server Archives - Page 4 of 16

I have created a foreign key (in SQL Server) by: alter table company add CountryID varchar(3); alter table company add constraint Company_CountryID_FK foreign ...

May 26, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL variable to hold list of integers

I’m trying to debug someone else’s SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One ...

May 26, 2022
0 Comments

The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’

I’m having problems executing a function. Here’s what I did: Create a function using SQL Server Management Studio. It was successfully created. I ...

May 26, 2022
0 Comments

List the queries running on SQL Server

Is there a way to list the queries that are currently running on MS SQL Server (either through the Enterprise Manager or SQL) ...

May 26, 2022
0 Comments

How to get Time from DateTime format in SQL?

I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: AttDate == 2011-02-09 ...

May 26, 2022
0 Comments

How to wait for 2 seconds?

How does one cause a delay in execution for a specified number of seconds? This doesn’t do it: WAITFOR DELAY '00:02'; What is ...

May 26, 2022
0 Comments

Query to list number of records in each table in a database

How to list row count of each table in the database. Some equivalent of select count(*) from table1 select count(*) from table2 ... ...

May 26, 2022
0 Comments